asp+sqlserver2000开发聊天室是遇到数据库连接问题
ADO方式连接数据库,失败,语句如下,请问问题何在,高手指教!!!在线等待
dim conn,rs,sql,connstr
connstr="driver={SQL Server};server=mycomputer;uid=sa;pwd=1;database=mychat;"
set conn=Server.CreateObject("ADODB.Connection")
conn.open connstr
set rs=Server.createobject("adodb.recordset")
sql="select * from userinfo where userid='aa' "
rs.open sql,conn
if rs.eof then
response.write rs("password")
else
response.write "<br>no this man "
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
结果数据库中明明有userid=aa的记录也输出"no this man ".我怀疑是连接问题.有人能解吗???