Error: Row handles must be released before new ones can be obtained
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
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.