Solved TD-22154: .NET ODBC not working with SalTblpopulate

Report TD 5.x and 6.x bugs and possible workarounds.
a_sivababu
India
Posts: 505
Joined: 10 Mar 2017, 08:46
Location: Chennai,India

TD-22154: .NET ODBC not working with SalTblpopulate

Post by a_sivababu » 11 Oct 2014, 10:31

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
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.

VEspinal

Re: TD-22154: .NET ODBC not working with SalTblpopulate

Post by VEspinal » 13 Oct 2014, 21:29

Hi Siva:

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.

a_sivababu
India
Posts: 505
Joined: 10 Mar 2017, 08:46
Location: Chennai,India

Re: TD-22154: .NET ODBC not working with SalTblpopulate

Post by a_sivababu » 14 Oct 2014, 15:33

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

VEspinal

Re: TD-22154: .NET ODBC not working with SalTblpopulate

Post by VEspinal » 14 Oct 2014, 22:21

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
You do not have the required permissions to view the files attached to this post.

a_sivababu
India
Posts: 505
Joined: 10 Mar 2017, 08:46
Location: Chennai,India

Re: TD-22154: .NET ODBC not working with SalTblpopulate

Post by a_sivababu » 15 Oct 2014, 05:44

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

VEspinal

Re: TD-22154: .NET ODBC not working with SalTblpopulate

Post by VEspinal » 15 Oct 2014, 21:28

Hi Siva:

Defect: TD-19905

Thanks for the information.

Regards,
Victor

a_sivababu
India
Posts: 505
Joined: 10 Mar 2017, 08:46
Location: Chennai,India

Re: TD-22154: .NET ODBC not working with SalTblpopulate

Post by a_sivababu » 05 Jun 2015, 09:12

Hi Victor,

Will this be expected in TD 6.2 SP4? and TD 6.3?

Thanks!
Siva A

VEspinal

Re: TD-22154: .NET ODBC not working with SalTblpopulate

Post by VEspinal » 10 Jun 2015, 18:24

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

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 4 guests