Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True,

nkhaternkhater Washington DCMember Posts: 1

Can someone tell me what I have wrong in this code? This is a call center wallboard that I am using from VOIPMonkey website, so it is not my code; and I am not a developer, I tried contacting the author to no luck, the error is below the code:

<!DOCTYPE html>


                WBConnect = "Dsn="& DSN &";" & _
                       "Host="& DBsource &";" & _
                       "Server="& ServerName &";" & _
                       "Service="& ServicePort &";" & _
                       "Protocol="& Protocol &";" & _
                       "Database="& DBdatabase &";" & _
                       "Uid="& DBuserID &";" & _
                       "Pwd="& DBpass &""

                Set cn = Server.CreateObject("ADODB.Connection")
                cn.ConnectionTimeout = Session("ConnectionTimeout")
                cn.CommandTimeout = Session("CommandTimeout")

                Set SQLStmt = Server.CreateObject("ADODB.Command")
                Set RS = Server.CreateObject ("ADODB.Recordset")
                SQLStmt.CommandText = SQL_Command
                SQLStmt.CommandType = 1
                Set SQLStmt.ActiveConnection = cn
                RS.Open SQLStmt




// DOM Ready !!
// Data Check and Div Change

        // Check Available Agents and set Display Colours

        // Check Logged In Agents and set Diaplay Colours

        // Check Calls Waiting and set Display Colours

Logged In Agents


Average Talk


Longest Talk


Available Agents


Average Wait


Longest Wait


Talking Agents


Oldest Contact


Calls Handled


Calls Waiting



<% sOffset = +0 'The time offset from GMT at the server cTime = i + sOffset tDiff = (DateAdd("h",cTime,Now)) Response.write FormatDateTime(tDiff,3) %>

Calls Abandoned


<!-- End of Container Div -->

<% RS.Close cn.Close %>

Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/wb/mainwb.asp, line 29

Sign In or Register to comment.