English

FAQ: Can I disconnect a recordset that includes spatial data using the ESRI OLE DB provider?

Question

Can I disconnect a recordset that includes spatial data using the ESRI OLE DB provider?

Answer

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.