Connection Issues using ADO

JoshuaSaves

I have tried the following connection strings to establish my connection. Each time I run the code I get an error saying that the Database doesn't exist or access denied. However using the same cridentials I was able to create an access db and link to the SQL db. The is for SQL 2000. Can someone look at the connection string below and see if I am missing something or have a parameter wrong?

Server='VISIONSQL\VISION1';Database='Test';Uid=MyUserID;Pwd=myPassword

Data Source='Test DB';Server='VISIONSQL\VISION1';Database='Test';Uid=MyUserID;Pwd=myPassword

Driver={SQL Server};Data Source='Test DB';Server='VISIONSQL\VISION1';Database='Test';Uid=MyUserID;Pwd=myPassword

Driver={SQL Server};Server='VISIONSQL\VISION1';Database='Test';Uid=MyUserID;Pwd=myPassword

ara3n

try this website http://www.connectionstrings.com/


Also this thread is helpful.

http://www.mibuso.com/forum/viewtopic.php?t=23038

JoshuaSaves

This is the correct connection string:

Driver={SQL Server};Server=VISIONSQL\VISION1;Database=Test;Uid=MyUserId;Pwd=myPassword