set conn=server.createobject("adodb.connection")
conn.open"driver={sql server};server=服务器名;pwd=123456;uid=sa;database=NorthWind"
set rs=server.createobject("adodb.recordset")sql = "SELECT * FROM aa"
rs.open sql,conn,adopenstaticdo while not rs.eof
response.write rs("a") & "<br>"
rs.MoveNext
looprs.close
set rs = nothing
conn.close
set conn = nothing
conn.open"driver={sql server};server=服务器名;pwd=123456;uid=sa;database=NorthWind"
set rs=server.createobject("adodb.recordset")sql = "SELECT * FROM aa"
rs.open sql,conn,adopenstaticdo while not rs.eof
response.write rs("a") & "<br>"
rs.MoveNext
looprs.close
set rs = nothing
conn.close
set conn = nothing
如果与实例名不一致,其它正确都不能访问.