Connecting to a DSN

[googie]

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!!

[VorTechS]

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>