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

PHP send mail with SMTP Authentication

<?php require_once "Mail.php";   $from = "XXXXXX@yourDOMAIN.com"; $to =...

How to connect to MySQL with JSP/JDBC?

<%@ page import="java.sql.*" %><%@ page import="com.mysql.jdbc.Driver" %><%!//...

MS SQL Server 2005 connection String

MS SQL server 2005 connection string :...

Do you support Cold Fusion?

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

Installing and managing Java Web Applications from Plesk

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