Connect the database first-this method is used in access with the most
strconn = "Driver=microsoft Access DRIVER (*.mdb);D bq=" _
& Server.MapPath ("Aspfree.mdb")
Set conn = Server.CreateObject ("Adodb.connection")
Conn.Open strconn
The second type-this method is used in SQL Server for more
strconn = "Driver={sql Server};D Escription=sqldemo; server=127.0.0.1; "_
& "Uid=loginid; password=;D Atabase=database_name "
Set conn = Server.CreateObject ("Adodb.connection")
Conn.Open strconn
Third Kind
strconn= "Driver={microsoft Access Driver (*.mdb)};" _
& "Dbq=f:\inetpub\wwwroot\somedir\db1.mdb;defaultdir=" _
& "F:\inetpub\wwwroot\somedir;uid=loginid" _
& "Pwd=password;driverid=25;fil=msaccess;"
Set conn = Server.CreateObject ("Adodb.connection")
Conn.Open strconn
Fourth application of system data sources
The following uses a Data Source name:example
Set conn = Server.CreateObject ("Adodb.connection")
Conn.Open "Example"
The fifth way to use ODBC data sources is if you have to set up the data source in the Control Panel ODBC
Set rs = Server.CreateObject ("Adodb.recordset")
Rs.Open "Tblname", "DSNname", 3, 3 the first one-this method is used in access for the most
strconn = "Driver=microsoft Access DRIVER (*.mdb);D bq=" _
& Server.MapPath ("Aspfree.mdb")
Set conn = Server.CreateObject ("Adodb.connection")
Conn.Open strconn
