How to open a database source
S T E P - 1
- In the Connection object, it provides the Open method to open a database:
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("db1.mdb")
S T E P - 2
- If this connection required user name and user password:
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("db1.mdb"), User, Password
S T E P - 3
- After using the connection, we will need to close it!
oConn.Close
Set oConn = Nothing
No comments:
Post a Comment