ERROR

Row handles must be released before new ones can be obtained

Last Published: April 25, 2020

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

Article ID:000003433

Software:
  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic