IBM® Informix® Client Software Development Kit, Version 4.10

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

Parent topic: Troubleshooting installation, configuration, or operation problems

Send feedback | Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.
timestamp Release date: September 2013