ASP connection 11 Kinds of Database syntax summary

Data | database | Syntax often uses operations on the database. Including the connection code, SQL commands and so on, and never deliberately to remember them (I am not willing to remember this stuff), so often in the use of the time to check the books, turn over. Some relatively less use of the database may not be able to find a smooth, so now they are all summed up here, to provide you with reference.

< a > database connection method：

1.Access Database Dsn-less Connection method:

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:

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:

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:

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:

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:

Set Adocon=server.createobject ("Adodb.connection")
Adocon.open "Provider=oraoledb.oracle;data source=dbname;user id=admin;password=pass;"

7.dBase Connection method:

Set Adocon=server.createobject ("Adodb.connection")
Adocon.open "Driver={microsoft dbase Driver (*.dbf)};d riverid=277;dbq=------------;"

8.mySQL Connection method:

Set Adocon=server.createobject ("Adodb.connection")
Adocon.open "Driver={mysql};d atabase=yourdatabase;
uid=username;pwd=yourpassword;option=16386; "

9.Visual Foxpro Connection method:

Set Adocon=server.createobject ("Adodb.connection")
Adocon.open "Driver={microsoft Visual Foxpro driver};sourcetype=dbc;sourcedb=*.dbc; Exclusive=no; "

10.MS Text Connection method:

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:

Set Adocon=server.createobject ("Adodb.connection")
Adocon.open "Provider=microsof.jet.oledb.4.0;data Source=your_path;" &_
"Extended Properties" text; Fmt=delimited ' "

[1] [2] Next page