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

Mailenable Component - Mail Code

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

How do I connect to MS SQL DB from servlets ?

Get the system DSN name from the client. Prepare a SQL System DSN with access to clients SQL db....

Sending email using CDOSYS

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

Enable Parent Paths in Plesk - Windows Server

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

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