Before you begin you should check to make sure that you have MDAC v2.1 SP2 or later installed on
your server. To get the latest MDAC goto
http://www.microsoft.com/data. If you are
unsure which version of MDAC you have installed Microsoft provides a tool called
ComCheck which will tell you.
A basic OLEDB Connection String looks like this:
Of course you will have to replace the path above ("c:\db1.mdb") with the path and filename of your own
database. If the database is located on an ISP's server and you don't know the physical path of your database you can
use the Server.Mappath() function. Eg:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("/db1.mdb")
However it is not recommended that you place your database in a folder that has IIS read permissions enabled (as any
casual web-browser will be able to download the file if the filename is known).
It is recommended that you assign your connection string to an application level global variable or create an
include file that contains code that assigns the connection string to a local variable (with the include file being
included on each page that requires a database connection). This way if your database ever changes you only
need to make one change to your code to enable it to connect to your new database. Eg (in your global.asa):
You may need to specify additional parameters for the connection string (eg a User ID and Password, if you have
placed a UserName/Password restriction on the database).
Application("strDBConnectionString") = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\db1.mdb"
The following is a list of additional parameters that can go into the connection string. Each parameter takes the form of:
and is separated from the next parameter by a ;
User ID (default: User ID=Admin)
Password (default: Password="")
Jet OLEDB:Registry Path
Jet OLEDB:Database Password
Jet OLEDB:Engine Type
Jet OLEDB:Database Locking Mode
Jet OLEDB:Global Partial Bulk Ops
Jet OLEDB:Global Bulk Transactions
Jet OLEDB:New Database Password
Jet OLEDB:Create System Database
Jet OLEDB:Encrypt Database
Jet OLEDB:Don't Copy Locale on Compact
Jet OLEDB:Compact Without Replica Repair
For a comprehensive list of connection strings (Access or otherwise) check out
this page over at Able Consulting.
Back to FAQ listing.