Several normative practices for ADO connecting to access

Several normative practices for ADO connecting to access:

ADO Data objects are used to connect to a database in two ways, namely, ODBC and OLE DB methods

(i) Using OLE DB methods

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

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

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

Accessing 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

(ii) Use of ODBC methods

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

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