Bueno, eso es por que no estas usando el
cerrojo adecuado para que obtengas los registros. Para ello deberías usar, por ejemplo, el valor de
adOpenStatic en
cursorType.
Buscando algo referente a tu problema
encontré esto:
Cita: SYMPTOMS
When attempting to enlist in a distributed transaction by using either the Microsoft ODBC for Oracle or the Microsoft OLE DB Provider for Oracle, the following error message occurs:
Driver not capable.
CAUSE
The Microsoft ODBC for Oracle driver and Microsoft OLE DB Provider for Oracle use the Mtxoci.dll file to communicate with the OCI layer of Oracle. The version of Mtxoci.dll that is provided with Microsoft Data Access Components (MDAC) 2.5 or later requires full security access to the registry keys for the Oracle client DLLs. If the MDAC client does not have full access to these keys, the MDAC client defaults to using the Oracle 7.x client DLLs. If Mtxoci.dll cannot find the proper Oracle library DLLs, it unloads itself and the Microsoft Oracle drivers default to using the Ociw32.dll file directly. If Mtxoci.dll is not loaded, you can access normal Oracle database functionality through the Ociw32.dll file, but extended functionality, such as distributed transactions, is disabled.
RESOLUTION
Because Microsoft Windows 95 and Microsoft Windows 98 do not have security settings on the registry keys, this problem does not affect Microsoft Windows 95 or Microsoft Windows 98-based computers. On Microsoft Windows NT and Microsoft Windows 2000-based computers, use the Regedt32.exe tool to set permissions on the appropriate keys (grant Everyone full permissions, or grant full permissions to restricted users such as the System account). Refer to the "More Information" section on which keys are affected.
Como puedes ver, aunque la información es vieja, apoya la teoría del problema entre el conector y el ADO
¿Puedes actualizar el controlador?
¿Tienes la versión 2.8 de ADO?
Revisa las llaves del registro y verifica lo que en el artículo siguiere