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

  • 15 Users Found This Useful
Was this answer helpful?

Related Articles

Sending email using CDOSYS

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

Upload file through ASP.net

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

Mailenable Component - Mail Code

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

How to create MSAccess Database DSN in Plesk Control Panel?

To Create DSN for MSAccess Database do following steps. 1. Access your control panel 2. Click on...

MS SQL Server 2005 connection String

MS SQL server 2005 & 2008 connection string : ------------------------------------------...