Operations related to databases are often used. It includes connection codes, SQL commands, etc., but I have never deliberately remembered them (I don’t want to remember this thing), so I often check the books and flip through them when I use them. Some less used databases may not be found smoothly, so now I will summarize them here for your reference. (If personal level is limited, you are welcome to correct any defects.)
<I>. Database connection method:
1. DSN-less connection method of Access database:
setadocon=Server.Createobject("adodb.connection")
adoconn.Open"Driver={Microsoft AccessDriver(*.mdb)};DBQ="&_
Server.MapPath("Path where the database resides")
2. AccessOLEDB connection method:
setadocon=Server.Createobject("adodb.connection")
adocon.open"Provider=Microsoft.Jet.OLEDB.4.0;"&_
"DataSource="&Server.MapPath("Path where the database resides")
3.SQLserver connection method:
setadocon=server.createobject("adodb.recordset")
adocon.Open"Driver={SQLServer};Server=(Local);UID=***;PWD=***;"&_
"database=database name;"
4.SQLserverOLEDB connection method:
setadocon=Server.Createobject("adodb.connection")
adocon.open"provider=SQLOLEDB.1;DataSource=RITANT4;"&_
"userID=***;Password=***;"&_
"initalCatalog=database name"
5.Oracle connection method:
setadocon=Server.Createobject("adodb.connection")
adocon.open"Driver={microsoftodbcfororacle};server=oraclesever.world;uid=admin;pwd=pass;"
6.OracleOLEDB connection method:
setadocon=Server.Createobject("adodb.connection")
adocon.open"Provider=OraOLEDB.Oracle;datasource=dbname;userid=admin;password=pass;"
7.dBase connection method:
setadocon=Server.Createobject("adodb.connection")
adocon.open"Driver={microsoftdbasedriver(*.dbf)};driverid=277;dbq=------------;"
8.mySQL connection method:
setadocon=Server.Createobject("adodb.connection")
adocon.open"Driver={mysql};database=yourdatabase;uid=username;pwd=yourpassword;option=16386;"
9. VisualFoxpro connection method:
setadocon=Server.Createobject("adodb.connection")
adocon.open"Driver={microsoftVisualFoxprodriver};sourcetype=DBC;sourceDB=*.dbc;Exclusive=No;"
10.MStext connection method:
setadocon=Server.Createobject("adodb.connection")
adocon.open"Driver={microsofttextdriver(*.txt;*.csv)};dbq=----;"&_
"extensions=asc,csv,tab,txt;PersistSecurityInfo=false;"
11.MStextOLEDB connection method:
setadocon=Server.Createobject("adodb.connection")
adocon.open"Provider=microsof.jet.oledb.4.0;datasource=your_path;"&_
"ExtendedProperties'text;FMT=Delimited'"
<two>. Four commonly used SQL commands:
1. Query data records (Select)