这样试试:
set conn=Server.CreateObject("ADODB.Connection")
set rs=Server.CreateObject("ADODB.RecordSet")
SQLQuery="..."
conn.Open "..."
set conn1=Server.CreateObject("ADODB.Connection")
SQLQuery1="..."
conn1.Open "..."
rs.Open SQLQuery, conn
rs.Open SQLQuery1, conn1
set conn=Server.CreateObject("ADODB.Connection")
set rs=Server.CreateObject("ADODB.RecordSet")
SQLQuery="..."
conn.Open "..."
set conn1=Server.CreateObject("ADODB.Connection")
SQLQuery1="..."
conn1.Open "..."
rs.Open SQLQuery, conn
rs.Open SQLQuery1, conn1
People.mdb 数据库 [ 表: Alumni, Users, Manager ]
Community.mdb 数据库 [ 表: LeaveWord, Sharing, Articles ]在削去冗余字段后,我发现在编写社区应用时,我必须访问两个数据库才成.
就象下面的SQL语句(当然是不对的了,不然我就不问了): SELECT LeaveWord.*, Users.* FROM Community.LeaveWord, People.Users
WHERE LeaveWord LEFT OUTER JOIN Users ( ON LeaveWord.Name=Users.Name )
ORDER BY Time DESC我知道,其实将People数据库中的所有表导入到Community中就肯定不会出现上面的问题.
但是,我就不! 除非ASP或Access或MS SQL Server都不支持打开多个数据库功能!
select * from a as a1,[Databasename].[dbo].[tableName] as b1 where a1.id=b1.id 记得你的帐号要有权限访问令一个database
或者把数据存入dataset中然后更改conn连接,打开另一数据库