MS Access DSN Less connection string

Windows Web Hosting Related Discussions

MS Access DSN Less connection string

Postby webhostingindia » Sun Mar 11, 2012 5:27 pm

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")
webhostingindia
 
Posts: 51
Joined: Sun Mar 11, 2012 4:46 pm

Return to Windows Web Hosting Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron