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

Give write permissions - .mdb, files & folders

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

Do you support ASP?

 Yes, we support ASP. 

How do i logon to Plesk control panel?

To login to to Plesk go to:https://YourDomainName.com:8880/  Login details are normally...

Do you support Cold Fusion?

We do not support or Cold Fusion on our shared hosting servers, however you are more than welcome...

MS SQL Server 2005 connection String

MS SQL server 2005 connection string :...