TD-22154: .NET ODBC not working with SalTblpopulate
TD-22154: .NET ODBC not working with SalTblpopulate
Hi Gupta,
.NET ODBC connectivity for SQL Server is not working with SalTblpopulate(). it shows invalid login for "sa"
ODBC - SQL Server - Not working
ODBC - SQL Server Native - Not Working
ODBC - using SqlDatabase - Working
OLEDB - Working
SQLServer Client - Working.
However, It works If I use SqlFetchNext but not returning complete result.
Sample Attached. testing in TD 622 and TD 6222 with SQL Server 2012.
Thanks
Siva A
.NET ODBC connectivity for SQL Server is not working with SalTblpopulate(). it shows invalid login for "sa"
ODBC - SQL Server - Not working
ODBC - SQL Server Native - Not Working
ODBC - using SqlDatabase - Working
OLEDB - Working
SQLServer Client - Working.
However, It works If I use SqlFetchNext but not returning complete result.
Sample Attached. testing in TD 622 and TD 6222 with SQL Server 2012.
Thanks
Siva A
You do not have the required permissions to view the files attached to this post.
Last edited by Anonymous on 14 Oct 2014, 15:50, edited 1 time in total.
Re: TD-22154: .NET ODBC not working with SalTblpopulate
Hi Siva:
It is working for me: TD62 SP2 UPD2, SQL Server 2012, Windows 7
Please try the attached sample.
HTH
Regards,
Victor Espinal
It is working for me: TD62 SP2 UPD2, SQL Server 2012, Windows 7
Please try the attached sample.
HTH
Regards,
Victor Espinal
You do not have the required permissions to view the files attached to this post.
Re: TD-22154: .NET ODBC not working with SalTblpopulate
Hi Victor,
Thanks for your quick review and response on this. It works if i use trusted connection for SQL Server & Native Driver but not working if I specify userid and password. I raised this bug only for this case.
Can you please check and confirm as I am not sure whether I am stupid here.
! Call SqlConnectDotNet(hSql1, 'Driver={SQL Server Native Client 11.0};Server=SERVER01;Database=TESTDB;Uid=sa;Pwd=sa;', "", DBP_PROVIDER_ODBC )
Call SqlConnectDotNet(hSql1, 'Driver={SQL Server};Server=SERVER01;Database=TESTDB;Uid=sa;Pwd=sa;', "", DBP_PROVIDER_ODBC )
Thanks
Siva A
Thanks for your quick review and response on this. It works if i use trusted connection for SQL Server & Native Driver but not working if I specify userid and password. I raised this bug only for this case.
Can you please check and confirm as I am not sure whether I am stupid here.
! Call SqlConnectDotNet(hSql1, 'Driver={SQL Server Native Client 11.0};Server=SERVER01;Database=TESTDB;Uid=sa;Pwd=sa;', "", DBP_PROVIDER_ODBC )
Call SqlConnectDotNet(hSql1, 'Driver={SQL Server};Server=SERVER01;Database=TESTDB;Uid=sa;Pwd=sa;', "", DBP_PROVIDER_ODBC )
Thanks
Siva A
Re: TD-22154: .NET ODBC not working with SalTblpopulate
Hi Siva:
Works for me, see below and attached picture/video.
!!CB!! 72
Set sConnectionString = "Driver={SQL Server Native Client 11.0};Server=Server Name;Database=TEST;Uid=sa;Pwd=test;Trusted_Connection=yes;"
If SqlConnectDotNet( hSql1, sConnectionString, "", DBP_PROVIDER_ODBC )
Thanks.
Regards,
Victor
Works for me, see below and attached picture/video.
!!CB!! 72
Set sConnectionString = "Driver={SQL Server Native Client 11.0};Server=Server Name;Database=TEST;Uid=sa;Pwd=test;Trusted_Connection=yes;"
If SqlConnectDotNet( hSql1, sConnectionString, "", DBP_PROVIDER_ODBC )
Thanks.
Regards,
Victor
You do not have the required permissions to view the files attached to this post.
Re: TD-22154: .NET ODBC not working with SalTblpopulate
Hi Victor,
Thanks and appreciated your time for providing the details on this. However, I feel the system connects through windows authentication due the trusted_connection entry in the connection string.
Can you please remove the trusted_connection which is windows authentication and then test only with SQL Server authentication which is through SQL Server userid/pwd?
For Eg, changed your connection string...
!!CB!! 72
Set sConnectionString = "Driver={SQL Server Native Client 11.0};Server=Server Name;Database=TEST;Uid=sa;Pwd=test;"
If SqlConnectDotNet( hSql1, sConnectionString, "", DBP_PROVIDER_ODBC )
some info about this:
http://msdn.microsoft.com/en-us/library/ms144284.aspx
Thanks!
Siva A
Thanks and appreciated your time for providing the details on this. However, I feel the system connects through windows authentication due the trusted_connection entry in the connection string.
Can you please remove the trusted_connection which is windows authentication and then test only with SQL Server authentication which is through SQL Server userid/pwd?
For Eg, changed your connection string...
!!CB!! 72
Set sConnectionString = "Driver={SQL Server Native Client 11.0};Server=Server Name;Database=TEST;Uid=sa;Pwd=test;"
If SqlConnectDotNet( hSql1, sConnectionString, "", DBP_PROVIDER_ODBC )
some info about this:
http://msdn.microsoft.com/en-us/library/ms144284.aspx
Thanks!
Siva A
Re: TD-22154: .NET ODBC not working with SalTblpopulate
Hi Siva:
Defect: TD-19905
Thanks for the information.
Regards,
Victor
Defect: TD-19905
Thanks for the information.
Regards,
Victor
Re: TD-22154: .NET ODBC not working with SalTblpopulate
Hi Victor,
Will this be expected in TD 6.2 SP4? and TD 6.3?
Thanks!
Siva A
Will this be expected in TD 6.2 SP4? and TD 6.3?
Thanks!
Siva A
Re: TD-22154: .NET ODBC not working with SalTblpopulate
Hi Siva:
First at all, correction on the defect number.
This is the correct one: TD-22154 and it is expected to be fixed on TD 6.2 SP4 Update 1.
Thanks,
Victor Espinal
First at all, correction on the defect number.
This is the correct one: TD-22154 and it is expected to be fixed on TD 6.2 SP4 Update 1.
Thanks,
Victor Espinal
Who is online
Users browsing this forum: [Ccbot] and 4 guests