5 ways to connect databases in ASP

5 ways to connect databases in ASP
(01-3-30 199)
From:chinaasp.com by Caoli
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; Pwd=password;database=database_name
Set conn = Server.CreateObject ("Adodb.connection")
Conn.Open strconn
Third Kind
Strconn= "Driver={microsoftaccessdriver (*.mdb)};" &_
"Dbq=f:inetpubwwwrootsomedirdb1.mdb;defaultdir=f:inetpubwwwrootsomedir;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