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")

  • Email, SSL
  • 11 Users Found This Useful
Was this answer helpful?

Related Articles

Give write permissions - .mdb, files & folders

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

Upload file through ASP.net

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

Mailenable Component - Mail Code

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

Sending email using CDOSYS

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

How to connect to MySQL with JSP/JDBC?

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