And access databases on the link sgl Now in a page, links to databases, Sql数据 library information : name bbs owner dbo database user name a password aa Calling need Table dv_user Access the database name anq.mdb Calling need Table question Calling database link "!--#include File=" connbbs.asp "TOP 10 "!--#include File=" conn.asp "TOP 10 These two Now, Table to the users who took dv_user Reads 。。。。。。。。 Sgl = "Select * From bbs.dbo.Dv_User Where Username = '" &Username& "'" Set rs ＝ = conn.Execute (sgl) 。。。。。 Calling access question reads Table 。。。。。。 Set rs3=server.CreateObject ( "adodb.recordset") Sql3= "select * from question Where Username = '" &Username& "'" Rs3.open sql3, conn,1,1 。。。。。 Heading heading heading heading heading : "%=rs3 (" question.title ") endothelium 。。。。。 Testing, no data page, will be how to write specific?

Set a target for the current record judgment Perhaps not even that users

Some users If there are no users would suggest rs.eof wrong. Now, I encountered the problem is that the problem can not be deployed for two databases

If the "!--#include file=" conn.asp "This sentence is not on the second line of Guangzhou Trade Fair, on the 。。。。。。 Set rs3=server.CreateObject ( "adodb.recordset") Sql3= "select * from question Where Username = '" &Username& "'" Rs3.open sql3, conn,1,1 。。。。。 Ahead, Sgl dv_user can transfer the Table "%=rs (" Username ") %><br> Password : "%=rs (" userpassword ") %><br> Integral : "%=rs (" userEP ") %><br><br> But Heading heading heading heading heading : "%=rs3 (" question.title ") endothelium The value of the air

Conn you confirm these two is not a target, and if so, separately wrote.

You are two "ADODB.Connection" object Definition, the use of the same name A definition for conn Another test called conn2

[ Closed window ]