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.
Known issues with OLE DB .NET bridgeIn a .NET application, when calling stored procedures that take no parameters, the OledbCommand attribute "CommandType" does not function as expected.

Known issues with OLE DB .NET bridge

In a .NET application, when calling stored procedures that take no parameters, the OledbCommand attribute "CommandType" does not function as expected.

Possible cause

This behavior is due to the requirement of HCL Informix® servers to have parentheses as part of the syntax of the stored procedure, even if there are no parameters.

Resolution

To work around this problem, use the OledbCommand's commandText attribute to build your own string for the stored procedure call before calling the Executexxx methods of the command interface.

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.