ASP网页内部错误
<% dim username, password,constr
constr="Provider=Microsoft.Jet.OLEDB.4.0;Data source="&server.mappath("a.mdb")
username=request("user")
password=request("password")
if username="" then
response.Write("用户名不能为空")
response.end
end if
set Conn=Server.Createobject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
Conn.open conn
sql="select * from user where username='"&username "'and password='"&password "'"
rs.open sql ,constr,1,1
if not rs.eof and not rs.bof then
response.Redirect("lyb.asp")
else
response.Write(" 用户名或密码错误")
end if
rs.close
conn.close
%>
运行以上代码后,提示 HTTP 500 - 内部服务器错误
请问高手是什么原因?
参考答案:Conn.open conn
这句错了
改为：
Conn.open constr
==========================================================
sql="select * from user where username='"&username "'and password='"&password "'"
rs.open sql ,constr,1,1
这两句也都错了
改为：
sql="select * from user where username='"&username&"'and password='"&password& "'"
rs.open sql ,conn,1,1