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

Installing and managing Java Web Applications from Plesk

Installing Java Web Applications You can install Java Web application packages in the Web...

I need to be able to run Tomcat applications from Document Root to access them as www.domainname.com/index.jsp?

Resolution Firstly, you should deploy an application with Plesk then edit the 'path' value for...

Do you support Servlets/JSP on Windows Server?

 Yes, we support Servlet/JSP on our Windows Server. 

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...

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...