(50分)一个网页怎么实现链接两个数据库?急在线等,行马上结贴!!

[woodfire]

数据库是MS Server 2000,两个数据库在同一台机器上!

[yuanquan]

我想还是LZ把你的代码贴出来，大家看了再帮你，才有的放矢啊，应该很容易就解决的

[jianjian51]

set conn1=server.createobject("adodb.connection")
conn.open "Driver={SQL Server};Server="172.0.0.1";Uid=as_itrade;Pwd=197752;Database=iTrade_2;"
rec1.open sql1,conn,1,3

set conn2=server.createobject("adodb.connection")
conn.open "Driver={SQL Server};Server="172.0.0.2";Uid=as_itrade;Pwd=197752;Database=iTrade_test;"
rec1.open sql2,conn,1,3

我用的

[jianjian51]

set conn1=server.createobject("adodb.connection")
conn.open1 "Driver={SQL Server};Server="172.0.0.1";Uid=as_itrade;Pwd=197752;Database=iTrade_2;"
rec1.open sql1,conn,1,3

conn1.open "Driver={SQL Server};Server="172.0.0.1";Uid=as_itrade;Pwd=197752;Database=iTrade_test;"
rec1.open sql2,conn,1,3

[jianjian51]

set conn_finnt_2005=server.CreateObject ("adodb.connection")
connStr="Provider=SQLOLEDB.1; Persist Security Info=True; Data Source=172.16.2.90; Initial Catalog=UFDATA_008_2005; Uid=sa;Pwd=;"
conn_finnt_2005.Open connStr

set conn_finnt_2004=server.CreateObject ("adodb.connection")
connStr="Provider=SQLOLEDB.1; Persist Security Info=True; Data Source=172.16.2.90; Initial Catalog=UFDATA_008_2004; Uid=sa;Pwd=;"
conn_finnt_2004.Open connStr

[tigerwen01]

写两个连接数据库字符串分别连接两个数据库

[woodfire]

你说是两个ADODB.Connection对象吗?
Set conn1 = Server.CreateObject("ADODB.Connection")
Set conn2 = Server.CreateObject("ADODB.Connection")
试过了不行!!

[loye]

就这样啊，怎么会不行？

[hwqing]

两个 Connection 对象分别赋予两个不同的连接字符串，就可以了。

[legend1970]

实际上建立一个连接，做两个不同的recordset就行了！
Set rs=Server.CreateObject("adodb.recordset")
sql="select categoryid,categoryname from category where categoryOrder="&CategoryOrder
rs.open sql,Conn,3,1

sql_1="select * from category where left(categoryid,5)='"&left(rs("categoryid"),5)&"' and categorytype='新闻'"
rs_1.open sql_1,Conn,3,1
可以实现哟！