Standard Practices for connecting to Access through ADO

Standard Methods for connecting to Access through ADO: There are two methods for connecting the ADO data object to the database: ODBC and OLEDB (1) ************************************* * ******************** OLEDBProviderforMicrosoftJet ***************** **************

Standard Methods for connecting to Access through ADO: There are two methods for connecting the ADO data object to the database: ODBC and ole db (1) ************************************ * ********************* ole db Provider for Microsoft Jet *********** ********************

Standard Practices for connecting to Access through ADO:

There are two ways to connect ADO data objects to a database: ODBC and ole db.

(1) Using OLE DB

**************************************** ****************

* ** Ole db Provider for Microsoft Jet

**************************************** ****************

Dim oConn, strConn

Set oConn = Server. CreateObject ("ADODB. Connection ")

StrConn = "Provider = Microsoft. Jet. OLEDB.4.0 ;"&_

"Data Source = c: somepathmyDb. mdb ;"&_

"User Id = admin ;"&_

"Password = ;"

OConn. Open strConn

**************************************** ****************

* ** Ole db Provider for ODBC Databases

**************************************** ****************

Access the MS Access Database

Dim oConn, strConn

Set oConn = Server. CreateObject ("ADODB. Connection ")

StrConn = "Provider = MSDASQL ;"&_

"Driver = {Microsoft Access Driver (*. mdb )};"&_

"Dbq = c: somepathmydb. mdb ;"&_

"Uid = myUsername ;"&_

"Pwd = myPassword ;"

OConn. Open strConn

(2) using ODBC

**************************************** ****************

* ** ODBC Driver for Access

**************************************** ****************

Dim oConn, strConn

Set oConn = Server. CreateObject ("ADODB. Connection ")

StrConn = "Driver = {Microsoft Access Driver (*. mdb )};"&_

"Dbq =" & Server. MapPath ("Testdb. mdb ");&_

"Uid = AdminAccount ;"&_

"Pwd = Password ;"

OConn. Open strConn