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

Upload file through ASP.net

<% @Page Language="C#" %><html><head>  <title>File upload in...

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

MS SQL Server 2005 connection String

MS SQL server 2005 connection string :...

Enable Parent Paths in Plesk - Windows Server

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