Page 1 of 1

MS Access DSN Less connection string

PostPosted: Sun Mar 11, 2012 5:27 pm
by webhostingindia
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")