How do I code a DSN-less connect string?

05. Scripting

You can setup a DSN-less connection to an Access database using ASP's Server.MapPath and a relative path to the database, as shown in the example below.

DSN_NAME = "DBQ=" & Server.MapPath("/database/mydatabase.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"

Article ID: 510, Created: March 9, 2011 at 6:33 PM, Modified: March 9, 2011 at 6:33 PM

How do I code a DSN-less connect string?

Add Feedback

Was this article helpful?

Share this article