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")

  • Email, SSL
  • 11 Users Found This Useful
Was this answer helpful?

Related Articles

Sending email using CDOSYS

If you are using a Windows 2000 / 2003 Server, or even XP Pro chances are that CDOSYS is your...

How to create MSAccess Database DSN in Plesk Control Panel?

To Create DSN for MSAccess Database do following steps. 1. Access your control panel 2....

I got 500 Error when viewing my Site ?

This normally happens because you turn on the Friendly Error on your IE. By default, IE always...

Enable Parent Paths in Plesk - Windows Server

Many scripts use a function called parent paths. If you are running one of these...

Give write permissions - .mdb, files & folders

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