We have an agent that use ADO to conect and import data from a SQL Server 2008.
The agent runs always on server.
Sometimes, the agent get the following error:
The version of the software are the following:
(-) Lotus Domino Server 8.5.1 FP3
(-) Windows 2003 Server 5.2
“ADODB.Field: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record”.
The error ocurrs in line rs.MOVENEXT which should bring the next register in the RS (recordset object).-
I supose this means I have no record in the RS … BUT … why the MOVENEXT would move to a record which does not exist ??. Or the record could have been lost ? Why ? How ? Could the recordset be deleted if the conection to the SQL database is lost ?
Can you give me any clue to make a troubleshooting ?