Five ways for ASP to open a database

Data | Database First-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

The second type-this method is used in SQL Server for more

strconn = "Driver={sql erver};D Escription=sqldemo; server=127.0.0.1; Uid=loginid;&_
Pwd=password;database=database_name

Set conn = Server.CreateObject ("Adodb.connection")

Conn.Open strconn

Third Kind

Strconn= "Driver={microsoftaccessdriver (*.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:

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