.jpg)
小編整理的常見(jiàn)的幾種數(shù)據(jù)庫(kù)的連接方式，分享給大家
?1.Access數(shù)據(jù)庫(kù)的DSN-less連接方法:
set?adocon=Server.Createobject("adodb.connection") adoconn.Open"Driver={Microsoft?Access?Driver(*.mdb)};DBQ="&?_ Server.MapPath("數(shù)據(jù)庫(kù)所在路徑")
? 2.Access OLE DB連接方法：
set?adocon=Server.Createobject("adodb.connection") adocon.open"Provider=Microsoft.Jet.OLEDB.4.0;"&?_ "Data?Source="?&?Server.MapPath("數(shù)據(jù)庫(kù)所在路徑")
3.SQL server連接方法：
set?adocon=server.createobject("adodb.recordset") adocon.Open"Driver={SQL?Server};Server=(Local);UID=***;PWD=***;"&?_ "database=數(shù)據(jù)庫(kù)名;"
? 4.SQL server OLE DB連接方法:
set?adocon=Server.Createobject("adodb.connection") adocon.open"provider=SQLOLEDB.1;Data?Source=RITANT4;"&?_ "user?ID=***;Password=***;"&?_ "inital?Catalog=數(shù)據(jù)庫(kù)名"
5.Oracle 連接方法:
set?adocon=Server.Createobject("adodb.connection") adocon.open"Driver={microsoft?odbc?for?oracle};server=oraclesever.world;uid=admin;pwd=pass;"
? 6.Oracle OLE DB 連接方法:
set?adocon=Server.Createobject("adodb.connection") adocon.open"Provider=OraOLEDB.Oracle;data?source=dbname;user?id=admin;password=pass;"
? 7.dBase 連接方法:
adocon=Server.Createobject("adodb.connection") adocon.open"Driver={microsoft?dbase?driver(*.dbf)};driverid=277;dbq=------------;"
? 8.mySQL 連接方法:
set?adocon=Server.Createobject("adodb.connection") adocon.open"Driver={mysql};database=yourdatabase; uid=username;pwd=yourpassword;option=16386;"
? 9.Visual Foxpro 連接方法:
set?adocon=Server.Createobject("adodb.connection") adocon.open"Driver={microsoft?Visual?Foxpro?driver};sourcetype=DBC;sourceDB=*.dbc;Exclusive=No;"
? 10.MS text 連接方法:
set?adocon=Server.Createobject("adodb.connection") adocon.open"Driver={microsoft?text?driver(*.txt;?*.csv)};dbq=-----;"&_ "extensions=asc,csv,tab,txt;Persist?SecurityInfo=false;"
? 11.MS text OLE DB 連接方法:
set?adocon=Server.Createobject("adodb.connection") adocon.open"Provider=microsof.jet.oledb.4.0;data?source=your_path;"&_ "Extended?Properties'text;FMT=Delimited'"
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請(qǐng)勿轉(zhuǎn)載。
THE END
.png)
