-
I am trying to connect to a DSN, which points to an access database, on our server. I can't figure out what the connection string would be. Can anyone help?? I did it in ASP and printed out the connectionstring property. I modifed this string by adding the server name. I get the message DSN not found, not default specifed. Here is my connectionstring
db.Open "Provider=MSDASQL.1;server=TestSvr;DSN=Tst;"
What other information do I need to provide? Help!!
-
When using DSN's to connect to a database in the way you have, you need to include the following: -
DBQ= <your databasename with full path>
UID= <database login name>
PASSWORD= <database login password>