Quickly master the common syntax of ASP connecting 11 kinds of databases

This article mainly introduces the ASP connection 11 kinds of database common syntax, the detailed content please refer to the following:

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 ' "