Home
Client APIs and toolsYou can use the HCL Informix® implementation of client APIs to develop applications for Informix® database servers.
Informix® OLE DB Provider GuideThe Informix® OLE DB Provider Programmer's Guide describes the software requirements for using Informix® OLE DB Provider, show how to install and configure the provider for your use, and explain how to use Informix® OLE DB Provider to enable client applications, such as ActiveX Data Object (ADO) applications and web pages, to access data on the Informix® server.
Troubleshooting installation, configuration, or operation problemsThis section describes how to resolve problems that you might encounter when installing, configuring, or using Informix® OLE DB Provider.
Server-side cursor fails to update recordsIf 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.

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

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.