MS Access DSNLess connection string sample

By Robbe Morris
Access over 40 UI widgets with everything from interactive menus to rich charts.

MS Access DSNLess connection string sample

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:

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\temp\mydb.mdb"


Submission Date:  3/18/2002 11:21:37 AM
Submitted By:  Robbe Morris
My Home Page:  http://www.robbemorris.com

Popularity  (335 Views)
Picture
Biography - Robbe Morris
Robbe has been a Microsoft MVP in C# since 2004. He is also the co-founder of EggHeadCafe.com which provides .NET articles, book reviews, software reviews, and software download and purchase advice.  Robbe also loves to scuba dive and go deep sea fishing in the Florida Keys or off the coast of Daytona Beach. Microsoft MVP