<%
dim conn
set conn=Server.Createobject("ADODB.Connection")
conn.Open"Driver={SQL Server}; Server=210.72.132.133;Uid=guoguo;Pwd=guoguo;DATABASE=sypm"
set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from dbo.user" --加上你的用户试试
rs.open sql,conn,2,1
do while not rs.eof
Response.Write(rs("name")) %><br><%
rs.movenext
looprs.Close%>
dim conn
set conn=Server.Createobject("ADODB.Connection")
conn.Open"Driver={SQL Server}; Server=210.72.132.133;Uid=guoguo;Pwd=guoguo;DATABASE=sypm"
set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from dbo.user" --加上你的用户试试
rs.open sql,conn,2,1
do while not rs.eof
Response.Write(rs("name")) %><br><%
rs.movenext
looprs.Close%>
则要将 select * from user 改为 select * from obd.user
用企业管理器看一下,user表对应的用户是guoguo,还是dbo?
sql="select * from guoguo.user"
or
sql="select * from dbo.user"
所有者是dbo,加上dbo.user还是不行