Create MS Access DSNLess connection string

Many people have requested this so here it is: 


"DRIVER={Microsoft Access Driver (*.mdb)}; 
DBQ=C:\MYDB\TEST.MDB" 

If you want to use the native OLEDB provider for 
Access, here it is. This should perform a 
little better than ODBC: 

conn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("./db/database.mdb")

Was this answer helpful?

 Print this Article

Also Read

How do I create a database in Plesk?

To create a new Database, please follow these steps: Open a web browser and connect to your...

Give write permissions - .mdb, files & folders

Plesk give write permissions to MS Access database .mdb file OR normal file & folder...

How do I send email from ASP using SMTP Authentication.

Please note that our mail server is configured with Authentication. Below is the code snippet...

Mailenable Component - Mail Code

Mailenable Component - Mail Code <%@ Language=VBScript %><%Dim oMailSet oMail =...

What is Difference between Disk Space and Hard Disk Quota in Plesk Control Panel?

 if you have a disk space limit of 1000mb you can upload more than 1000Mb, if more than...