Server-side cursor fails to update records
If you open a server-side cursor (adUseServer) on
an SQL command (adCmdText), attempts to perform an update fail
with an ADO provider not capable
error.
This problem applies only to 7.x, 8.x, and 9.1x servers.
Possible cause
A server-side cursor that is opened on SQL text against HCL Informix® servers before version 9.2 cannot be updated.
Resolution
Use the client-side cursor (adUseClient) instead, or open the server-side cursor on the table (adCmdTableDirect).