The syntax of ASP connecting 11 kinds of databases

　　1.Access Database Dsn-less Connection method:

The following are the referenced contents:

Set Adocon=server.createobject ("Adodb.connection")

Adoconn. Open driver={microsoft Access Driver (*.mdb)};D bq= "& _

Server.MapPath ("Path to Database")

　　2.Access OLE db connection method:

The following are the referenced contents:

Set Adocon=server.createobject ("Adodb.connection")

Adocon.open "Provider=Microsoft.Jet.OLEDB.4.0;" & _

"Data source=" & Server.MapPath ("Path to Database")

　　3.SQL Server Connection method:

The following are the referenced contents:

Set Adocon=server.createobject ("Adodb.recordset")

ADOcon. Open "Driver={sql Server}; server= (local); uid=***; pwd=***; " & _

"Database= Database name

　　4.SQL Server OLE db connection method:

The following are the referenced contents:

Set Adocon=server.createobject ("Adodb.connection")

Adocon.open "Provider=SQLOLEDB.1;Data source=ritant4;" & _

"User id=***; password=***; " & _

"Inital catalog= database name"

　　5.Oracle Connection method:

The following are the referenced contents:

Set Adocon=server.createobject ("Adodb.connection")

Adocon.open "Driver={microsoft ODBC for Oracle};

Server=oraclesever.world;uid=admin;pwd=pass; "

　　6.Oracle OLE DB Connection method:

The following are the referenced contents:

Set Adocon=server.createobject ("Adodb.connection")

Adocon.open "Provider=oraoledb.oracle;data source=dbname;

User Id=admin;password=pass; "

　　7.dBase Connection method:

The following are the referenced contents:

Set Adocon=server.createobject ("Adodb.connection")

Adocon.open "driver=

{Microsoft dBASE driver (*.dbf)};d riverid=277;dbq=--; "

　　8.mySQL Connection method:

The following are the referenced contents:

Set Adocon=server.createobject ("Adodb.connection")

Adocon.open "Driver={mysql};d atabase=yourdatabase;

uid=username;pwd=yourpassword;option=16386; "

　　9.Visual Foxpro Connection method:

The following are the referenced contents:

Set Adocon=server.createobject ("Adodb.connection")

Adocon.open "Driver={microsoft Visual Foxpro Driver};

SOURCETYPE=DBC;SOURCEDB=*.DBC; Exclusive=no; "

　　10.MS Text Connection method:

The following are the referenced contents:

Set Adocon=server.createobject ("Adodb.connection")

Adocon.open "Driver={microsoft

Text Driver (*.txt *.csv)};d bq=-----; &_

"Extensions=asc,csv,tab,txt; Persist Securityinfo=false; "

　　11.MS text OLE DB connection method:

The following are the referenced contents:

Set Adocon=server.createobject ("Adodb.connection")

Adocon.open "Provider

=microsof.jet.oledb.4.0;data Source=your_path; " &_

"Extended Properties" text; Fmt=delimited ' "