I am getting the following ADODB.Recordset error '800a0bcd'
Posted on 2011-05-10
I haven't changed anything in our website but for some reason we are getting the error above. I am new to asp but understand the logic the error we are getting is the following when someone tries to log in.
ADODB.Recordset error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/holiday/adjustleaveadmin.asp, line 100 \
Line 100 looks like this
Set Rs1 = Server.CreateObject("ADODB.RecordSet")
sSQL = "SELECT * FROM tAdmin WHERE Login='" & EmpNameAdjust & "'"
Rs1.Open sSQL, sDSN, adOpenKeySet, adLockPessimistic, adCmdText
if leaveType = "Sick" then
Rs1("SickTaken") = sLeave_Taken
Rs1("SickOverdue") = overdue
Elseif leaveType = "Vacation" then
Rs1("VacationTaken") = sLeave_Taken
Rs1("VacationOverdue") = overdue
Set Rs1 = Nothing