p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: Error 80040e21 when updating


Message #1 by "Mike H." <mhaining@p...> on Fri, 1 Dec 2000 15:51:37 -0000
I am verifying a logon and trying to update 

my table with time of last login. We just upgraded our server to W2K/IIS

5.0 and now this doesn't work (it worked fine under NT/IIS 4.0) Here is

the code:



strUserName = request.form("UserName") 

strPassword = request.form("Password") 

strConn = {connection string} 

strSQL = "SELECT * FROM Clients " 

strSQL = strSQL & "WHERE Upper(Username) = '" & Trim(Ucase(strUserName)) &

"'" 

strSQL = strSQL & " AND Upper(Password) = '" & Trim(Ucase(strPassword)) &

"'" 



Set rsLogin = Server.CreateObject("ADODB.Recordset") 

rsLogin.Open strSQL, strConnect, adOpenStatic, adLockPessimistic, 

adCmdText 



If rsLogin.EOF AND rsLogin.BOF Then 

'user is not logged in, inform the user 

'give them the form again to try to login again 

else 'user is successfully logged on 

rsLogin("Lastlogin") = Date          'this is line 74 

rsLogin.Update 

Response.Clear 

Response.Redirect("LoggedInPage.asp") 

end if 



Here is the error: 

Error Type: 

Microsoft OLE DB Provider for ODBC Drivers (0x80040E21) 

Multiple-step OLE DB operation generated errors. Check each OLE DB status

value, if available. No work was done. 

/myUrl/LoginPage.asp, line 74 



Any suggestions? 



Thanks, 




  Return to Index