ODBC Connection Failure

I am having a problem getting the ODBC driver to connect.

I just installed VS2005 and can't connect to my SQL2000 server. It is there. I can't connect using either one of the mix mode authentication.

I can login to SQL from another pc when logged in with this user name. It has to be something on this pc blocking it.

Iam not rying to do this from a ASP web page just trying to setup a ODBC driver and I get these errors.

I get the error:" Login failed for user (null)" Not associated with a trusted connection

Thanks

Mike

I downloaded and installed manager studio and I can see the server in the network tab but still can't connect. I get the error 11001

Any Ideas?

Thanks

|||

Let's see your connection string. I would also read: http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

|||

This link was broken for a while and I could not reply.

William,

Little background. I have had this application up and running since Oct 05 with the connection string on several different pc's.

There is no problem with the connection string.

I recently had difficulty on two new PC, one laptop and one desktop. Neither could access SQL2000 running on another PC. Both could run the application and connection string locally if I copied the DB down to express. This application is a smart client app not an ASP app.

Both instances had newly installed VS2005 and SQL Express installed on them.

I could not even set up a DSN using ODBC manager. It would not connect to the SQL 2000 server.

When I tried using SQL Mgr Studio Express, it could see the SQL 2000 server but not connect to it.

I always got some kind of connection error.

Thanks.