Simple OLEDB connection to Microsoft Access database - ASP Scripts
The following example shows you how to open a Microsoft Access database connection via ASP and its OLEDB 4.0 database drivers.
There are essentially 2 types of connection drivers for Microsoft Access but OLEDB is the most reliable and provide the best performances.
Our sample database is called
database.mdb and it is located in the same folder of the file that will open the database connection.
First of all we have to create a new
ADODB object instance and define a new variable to hold the database connection string.
Then we simply need to open a new database connection as follows.
<% ' Create a new ADODB instance Set objConn = Server.CreateObject("ADODB.Connection") ' Create the connection string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("database.mdb") ' Open the connection objConn.Open strConn %>Please note that the script above provides a relative path to the database using the statement
If the database is located in a parent folder starting from the script you simply need to change the path including the classic HTML statement
'..' before the path.
If the database is located in a child folder starting from the script you simply need to add the subfolder name to the path.
Once the database connection is open you will be able to execute SQL queries but don't forget to close database connection as soon as you don't need it anymore and destroy the object in order to free server resources.
<% ' Close the connection objConn.Close ' Release objects Set objConn = Nothing %>