Connecting via ODBC

[dvannoy]

I am running Netware at my location. I am putting in a SQL 2000 server that users will use to look up Info. The front end will be in VB6. I want to create a SQL server account for each user and have them log into the DB with ODBC. I am having a hard time trying to make this work..in the windows ODBC manager i can create a connection using tcp/ip with NT auth. and it works fine. if i try and use sql auth. with the user being sa it says user not trusted with the associated sql server.??? why...sa is admin.

how should i be setting this up?

Thanks in Advance


DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[tlbroadbent]

The message about "Trusted Server" indicates you are attempting to connect with NT authentication rather than SQL authentication. Do you get this message when setting up the ODBC connection or after it has been set up and you try to open a SQL table? You may be encountering a SQL ODBC driver bug. Check the following link.

http://support.microsoft.com/support/kb/articles/Q279/5/26.ASP

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[dvannoy]

OK that sounds like whats happening. I was choosing SQL auth. not NT. Then when I would Click next thats when i got the error.

OK, once I download the patch and create the datasource. in my code do i specify the ODBC connection I created as the SQL driver??? or what..

Thanks



DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[dvannoy]

I installed service pack 1. and still am getting the same problems. when i setup the ODBC connection using NT auth. connecting via TCP/IP it works fine. If i check SQL auth. it still says user "sa is not associated with a trusted SQL server connection"..

Does anyone have any input for me?

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[rushdib]

Hi,
This is a MS Access/SQL Server question. I am getting an error &quot;ODBC-Connection <database name> Failed&quot;, if I try to make a shortcut for an application which already has ODBC connection to tables in SQL Server. The user names are different on the PCs. Is it possible to connect to the SQL server, this way?

Thank You,

Rushdi Basir