Hvad er der galt?
Jeg får fejlen:Microsoft OLE DB Provider for ODBC Drivers fejl '80040e10'
[Microsoft][ODBC Microsoft Access-driver] Der er for få parametre. Der var ventet 1.
/user/usrLogin.asp, linje 18
når jeg kører dette script:
<%@ Language=VBScript %>
<%
'dim strUsername, strPassword, intUserID, strErr
strErr = "shgf"
'If Request.Form("Action") = "usrLogin" Then
strUsername = Trim(Replace(Request.Form("Username"),"'",""))
strPassword = Trim(Replace(Request.Form("Password"),"'",""))
If Len(strUsername) > 0 And Len(strPassword) > 0 Then
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../data/ws.mdb")
strSQL = "SELECT usrID FROM Bruger "&_
" WHERE (usrName = '" & strUsername & "')"&_
" AND (usrPassword = '" & strPassword & "')"
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
intUserID = rs("usrID")
Else
strERR = "Du har ikke indtastet dit brugernavn/password korrekt ind, prøv igen."
End If
myConn.Close
Set myConn = Nothing
If Len(intUID) Then
Session("usrID") = intUserID
Session("usrName") = strUsername
Session("usrPassword") = strPassword
Response.Cookies("WS")("usrID") = intUserID
Response.Cookies("WS")("usrName") = strUsername
Response.Cookies("WS")("usrPassword") = strPassword
Application("loginUser") = Application("loginUser") + 1
Response.Redirect("usrArrival.asp")
End If
Else
strErr = "Du skal skrive både brugernavn og adgangskode"
End If
If Len(strErr) > 0 Then
strErr = "<p><font color=red>" & strErr & "</font></p>"
End If
'End If
strUsername = Request.Cookies("WS")("usrName")
strPassword = Request.Cookies("WS")("usrPassword")
%>
<HTML>
<HEAD>
<TITLE>Ankomst Check-In</TITLE>
</HEAD>
<BODY>
<%=strErr %>
<FORM METHOD="POST" ACTION="usrLogin.asp" NAME="login">
Brugernavn:<BR>
<input type="text" value="<%=strUsername %>" name="Username"><BR>
<BR>Adgangskode:<BR>
<input type="text" value="<%=strPassword %>" name="Password"><BR>
<BR>
<input type="submit" value="Check-Ind" name="CheckInd">
</FORM>
</BODY>
</HTML>
<-AHL->
