Microsoft JET Database Engine (0x80040E10)
错误类型:
Microsoft JET Database Engine (0x80040E10)
至少一个参数没有被指定值。
/web/jsyxqyw/admin/logoin.asp, 第 9 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
网页:
POST 50 ??? /web/jsyxqyw/admin/logoin.asp
<!--#include file="conn.asp"-->
<%
if Request.ServerVariables("REQUEST_METHOD")="POST" then
admin=Request.Form("name")
password=Request.Form("password")
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from ADMIN where ADMIN='" & admin & "' and PASSWORD='" & password & "'"
rs.OPEN sql,Conn,0,1
if rs.eof and rs.bof then
Response.Write "密码或用户名错误!!!"
else
Session("ADMIN")="YESADMIN"
Response.Redirect "main.asp"
end if
end if
%>
conn.asp
<%
dim conn
dim connstr
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../data/JSYXQYW-DATABASE.mdb")
conn.Open connstr
If Err Then
err.Clear
Set Conn = Nothing
Response.Write "数据库连接出错,请检查连接字串。"
Response.End
End If
sub CloseConn()
On Error Resume Next
Conn.close
set Conn=nothing
end sub
%>