English

Error: Row handles must be released before new ones can be obtained

Error Message

When trying to persist an ADO recordset, in either ADTG or XML format, using the ESRI OLE DB provider, the following error occurs:

Run time error '-2147217883 (80040e25)
Row handles must be released before new ones can be obtained

Cause

After the ADO recordset was opened, some operation has been undertaken on the recordset that has left open row handles on the recordset.

Solution or Workaround

Before saving the recordset, call the requery method on the recordset; this will release any open row handles and allow you to persist the recordset.

Code:
<recordset object>.requery