数据库连接方式汇总
<p><strong> 1.Access数据库的DSN-less连接方法:</strong></p>
<p>
</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code52203">
<br>
set adocon=Server.Createobject("adodb.connection")<br>
adoconn.Open"Driver={Microsoft Access Driver(*.mdb)};DBQ="& _<br>
Server.MapPath("数据库所在路径")</div>
<p>
</p>
<p>
<strong> 2.Access OLE DB连接方法：</strong></p>
<p>
</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code43917">
<br>
set adocon=Server.Createobject("adodb.connection")<br>
adocon.open"Provider=Microsoft.Jet.OLEDB.4.0;"& _<br>
"Data Source=" & Server.MapPath("数据库所在路径")</div>
<p>
</p>
<p>
<strong>3.SQL server连接方法：</strong></p>
<p>
</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code21890">
<br>
set adocon=server.createobject("adodb.recordset")<br>
adocon.Open"Driver={SQL Server};Server=(Local);UID=***;PWD=***;"& _<br>
"database=数据库名;"</div>
<p>
</p>
<p>
<strong> 4.SQL server OLE DB连接方法:</strong></p>
<p>
</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code61411">
<br>
set adocon=Server.Createobject("adodb.connection")<br>
adocon.open"provider=SQLOLEDB.1;Data Source=RITANT4;"& _<br>
"user ID=***;Password=***;"& _<br>
"inital Catalog=数据库名"</div>
<p>
</p>
<p>
<strong>5.Oracle 连接方法:</strong></p>
<p>
</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code42848">
<br>
set adocon=Server.Createobject("adodb.connection")<br>
adocon.open"Driver={microsoft odbc for oracle};server=oraclesever.world;uid=admin;pwd=pass;"</div>
<p>
</p>
<p>
<strong> 6.Oracle OLE DB 连接方法:</strong></p>
<p>
</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code25095">
<br>
set adocon=Server.Createobject("adodb.connection")<br>
adocon.open"Provider=OraOLEDB.Oracle;data source=dbname;user id=admin;password=pass;"</div>
<p>
</p>
<p>
<strong> 7.dBase 连接方法:</strong></p>
<p>
</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code51798">
<br>
set adocon=Server.Createobject("adodb.connection")<br>
adocon.open"Driver={microsoft dbase driver(*.dbf)};driverid=277;dbq=------------;"</div>
<p>
</p>
<p>
<strong> 8.mySQL 连接方法:</strong></p>
<p>
</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code71688">
<br>
set adocon=Server.Createobject("adodb.connection")<br>
adocon.open"Driver={mysql};database=yourdatabase;<br>
uid=username;pwd=yourpassword;option=16386;"</div>
<p>
</p>
<p>
<strong> 9.Visual Foxpro 连接方法:</strong></p>
<p>
</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code38576">
<br>
set adocon=Server.Createobject("adodb.connection")<br>
adocon.open"Driver={microsoft Visual Foxpro driver};sourcetype=DBC;sourceDB=*.dbc;Exclusive=No;"</div>
<p>
</p>
<p>
<strong> 10.MS text 连接方法:</strong></p>
<p>
</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code37912">
<br>
set adocon=Server.Createobject("adodb.connection")<br>
adocon.open"Driver={microsoft text driver(*.txt; *.csv)};dbq=-----;"&_<br>
"extensions=asc,csv,tab,txt;Persist SecurityInfo=false;"</div>
<p>
</p>
<p>
<strong> 11.MS text OLE DB 连接方法:</strong></p>
<p>
</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code13345">
<br>
set adocon=Server.Createobject("adodb.connection")<br>
adocon.open"Provider=microsof.jet.oledb.4.0;data source=your_path;"&_<br>
"Extended Properties'text;FMT=Delimited'"</div>
<p>
</p>
頁:
[1]