Trying to setup an odbc for sql server...have errors

[1712]

No matter what I try, I get connection failed when testing out an ODBC driver I build for Sql server. It says my sql server does not exist or access denied. I am simply trying an example in a book that uses the northwind.mdb database.

I am doing this development on my laptop and have visual studio 6 enterprise loaded. SQl server is loaded and running. No matter which way I try building it (win nt or sql server authenication it still fails on me.

Any ideas to try out??

 

[bassguy]

Could you please explain what you have tried and what application you are trying to use...are you setting up a system DSN ? Have you tried a UDL? I struggled with this for a month or two a year ago...maybe I can help
thanks...


Bassguy

 

[1712]

I am using a system dsn. I am trying an example out of a book creating a ado connection to a database, in this case northwind.mdb.

I went into the odbc administrator in win 2000 professional to set this up but I am confused which way is the best. I have tried a number of combinations (win nt or sql authenication). I get a failed connection when testing the odbc connection saying server does not exist or access denied.

 

[tlbroadbent]

Try these settings in your ODBC Data Source setup.

Server: (local)
Login ID: sa
Password: NULL (or empty string) unless you changed the password for sa when you installed SQL Server. If you changed the password, then use that password.

Hope this helps. Terry Broadbent


"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[1712]

Thanks for your response. Unfortunately I have already tried that and still no luck. I am not an expert with sql server(only use it to set up datebases), and I don't remember frankly, of any password setup when I installed it on my laptop. (Is there a way to check?)

Anyway if you have any more suggestions to try I would be appreciated.

 

[tlbroadbent]

I suggest that you rebuild tha master database. Check the topic "Rebuilding the master Database" in SQL BOL to learn how to do this. Terry Broadbent


"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin