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).