Is This Content Helpful?
We're glad to know this article was helpful.
Can I disconnect a recordset that includes spatial data using the ESRI OLE DB provider?
Yes. Before opening the recordset, you must set the recordset cursorlocation to adUseClient and the locktype to adLockBatchOptimistic.
Once the recordset has been opened, disconnect from the data source by setting the recordset's activeconnection property to nothing.