1、通過ADO連接各種數據庫的字符串翠集.txt <%dim oconn,strconnset oconn=server.createobject(“adodb.connection”)strconn= "provider=adsdsoobject;" & _"user id=myusername;" & _"password=mypassword;"oconn.open strconn%>2) ole db provider for db2<%dim oconn,strconnset oconn=ser

2、ver.createobject(“adodb.connection”)strconn= "provider=db2oledb;" &"network transport library=tcpip;" &"network address=myserver;" & _"package collection=mypackage;" &"host ccsid=1142""initial catalog=mydb;" &"user

3、id=myusername;" & _"password=mypassword;"oconn.open strconn%>3) ole db provider for index server<%dim oconn,strconnset oconn=server.createobject(“adodb.connection”)strconn= "provider=msidxs;" & _"data source=mycatalog;"oconn.open strconn%>4) ole db

4、 provider for internet publishing<%dim oconn,strconnset oconn=server.createobject(“adodb.connection”)strconn= "provider=msdaipp.dso;" & _"data source=http:/mywebsite/mydir;" & _"user id=myusername;" & _"password=mypassword;"oconn.open strconn%&g

5、t;5) ole db provider for microsoft jet 標準的也是常用的訪問方式。<%dim oconn,strconnset oconn=server.createobject(“adodb.connection”)"data source=c:somepathmydb.mdb;" & _"user id=admin;" & _"password=;"oconn.open strconn%> 假如是一個工作組的系統數據庫，那么連接字符串如下。<%dim oconn,strcon

6、nset oconn=server.createobject(“adodb.connection”)"data source=c:somepathmydb.mdb;" & _"jet oledb:system database=mysystem.mdw;", _"admin", ""oconn.open strconn%>注意：在使用4.0 ole db provider 提供者的驅動程序時，要記得把mdb和mdw轉換成the 4.0 database格式。 如果mdb是設置密碼的話，那么使用如下連接

7、字符串。"data source=c:somepathmydb.mdb;" & _"jet oledb:database password=mydbpassword;", _"admin", "" 如果mdb是位于網絡中并且是共享的話，那么使用如下連接字符串。"data source=myservermysharemypathmydb.mdb; 如果要想使用專有的方式來訪問數據庫，那么使用如下連接字符串。oconn.mode = admodeshareexclusive"data sou

8、rce=c:somepathmydb.mdb;" & _"user id=admin;password=;"6）使用ole db provider for microsoft jet來訪問excel電子數據表。<%dim oconn,strconnset oconn=server.createobject(“adodb.connection”)"data source=c:somepathmyexcelspreadsheet.xls;" & _"extended properties=""ex

9、cel 8.0;hdr=yes;"""oconn.open strconn%>說明：這里的hdr=yes的意思是，提供者訪問excel電子數據表時沒有把第一排的數據加入到數據集中；而當hdr=no時的意思是提供者訪問excel電子數據表時動作恰好跟上面所述相反。7）ole db provider for odbc databases 訪問ms access數據庫<%dim oconn,strconnset oconn=server.createobject(“adodb.connection”)strconn= "provider=msdas

10、ql;" & _"driver=microsoft access driver (*.mdb);" & _"dbq=c:somepathmydb.mdb;" & _"uid=myusername;" & _"pwd=mypassword;"oconn.open strconn%> 訪問ms sql server 數據庫<%dim oconn,strconnset oconn=server.createobject(“adodb.connection”)strco

11、nn= "provider=msdasql;" & _"driver=sql server;" & _"server=myservername;" & _"database=mydatabasename;" & _"uid=myusername;" & _"pwd=mypassword;"oconn.open strconn%>8) ole db provider for oracle (from microsoft)<%d

12、im oconn,strconnset oconn=server.createobject(“adodb.connection”)strconn= "provider=msdaora;" & _"data source=myoracledb;" & _"user id=myusername;" & _"password=mypassword;"oconn.open strconn%>9) ole db provider for oracle (from oracle)<%dim

13、oconn,strconnset oconn=server.createobject(“adodb.connection”)strconn= "provider=oraoledb.oracle;" & _"data source=myoracledb;" & _"user id=myusername;" & _"password=mypassword;"oconn.open strconn%>10) ole db provider for sql server 標準連接方式<%d

14、im oconn,strconnset oconn=server.createobject(“adodb.connection”)strconn= "provider=sqloledb;" & _"data source=myservername;" & _"initial catalog=mydatabasename;" & _"user id=myusername;" & _"password=mypassword;"oconn.open strconn%&g

15、t; 通過機器的ip地址訪問<%dim oconn,strconnset oconn=server.createobject(“adodb.connection”)strconn= "provider=sqloledb;" & _"network library=dbmssocn;" & _"initial catalog=mydatabasename;" & _"user id=myusername;" & _"password=mypassword;"oconn.open strconn%>sqlserver默認端口：1433附錄1：ado數據對象及其功能簡介ado數據對象功能.connection代表與一個數據源的唯一對話.command用co