数据库!!!!!急……
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
/CheckLogin.asp, 第 32 行
<%
Dim UserName,Password
UserName=Request("username")
Password=Request("password")
if UserName="" then
Response.Redirect"Login.htm"
end if
if Password="" then
Response.Redirect"Login.htm"
end if
'如果用户名和密码为空,则返回
Set obj=Server.CreateObject("ADODB.Connection")
obj.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("musiclib.mdb")
Set oRS=Server.CreateObject("ADODB.Recordset")
Set oRS.ActiveConnection=obj
oRS.Open ="SELECT * FROM admin_user WHERE UseName='" & username & " '"
'上一行为32
if oRS.EOF then
Resopnse.Write"<center><b>用户名</b>错误,请<a href=Login.htm>重新登录</a>!!!</center>" & vbCrLf
Else
if oRS("password").value = Password then
Session("UserName") = Username
Session("LoginOK") = True
Response.Redirect "music_admin.asp"
Else
Session("UserName") = ""
Session("LoginOK") = False
Response.Write"<center><b>密码</b>错误,请<a href=Login.htm>重新登录</a> !!!</center>" & vbCrLf
end if
end if
oRS.Close
Set oRS = Nothing
obj.Close
Set obj = Nothing
%>