新闻中心
ASP在一个页面同时读取2个数据库
发布时间:2010-8-8 阅读次数:14210 
set conn1=server.CreateObject(“adodb.connection”)
conn1.open “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=”&server.MapPath;(“数据库1路径”)
set conn2=server.CreateObject(“adodb.connection”)
conn2.open “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=”&server.MapPath;(“数据库2路径”)
set rs1=server.CreateObject(“adodb.recordset”)
rs1.open “select * from 数据库1”,conn1,1,1
set rs2=server.CreateObject(“adodb.recordset”)
rs2.open “select * from 数据库2”,conn2,1,1
conn1.open “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=”&server.MapPath;(“数据库1路径”)
set conn2=server.CreateObject(“adodb.connection”)
conn2.open “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=”&server.MapPath;(“数据库2路径”)
set rs1=server.CreateObject(“adodb.recordset”)
rs1.open “select * from 数据库1”,conn1,1,1
set rs2=server.CreateObject(“adodb.recordset”)
rs2.open “select * from 数据库2”,conn2,1,1




