SQL Server and ADO DSN Connect String?

P

Pete

I have a MS Access database that has several linked SQL
tables. I need to know how to write the connect string
in ADO to create either a DSN less connection or allow me
to pass the user name and password to the existing DSN
connection on the PC. I do not want to prompt the user
for this information.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to avoid login prompt for Linked Tables thru DSN entry? 1
Trusted Connection in Pass-trough query... 4
How to Upgrade SQL back end of Access linked tables. 7
Linked tables to SQL 1
SQL back end for Access 7
DSN-LESS Connection Strings in Pass Thru QueryDef 1
ConnectionString without DSN not working 0
Connect to SQL with DSN without uid and password 3

Top