IBM Support

DataDirect® Connect™ ODBC returning "Error Data type for parameter has changed since" with Enterprise Gateway Manager

Troubleshooting


Problem

DataDirect® Connect™ ODBC returning "Error Data type for parameter has changed since" with Enterprise Gateway Manager

Symptom

While using the IBM® Informix® Enterprise Gateway Manager™ with a DataDirect® Connect™ ODBC driver, you receive the following error when the application executes again a prepared statement with a different scale, precision, or sqltype:


ODBC Error ([0 S1000 IXor8:03.11.0000] Data type for parameter 1 has changed since ).

Cause

The DataDirect Connect ODBC driver WorkArounds configuration parameter is not set to 536870912 for the ODBC data source.

Resolving The Problem


Modify the data source and set the WorkArounds parameter to 536870912. This setting allows the application to re-execute a prepared statement with a different scale, precision, or sqltype


Operating System
How to change the ODBC Data Source Definition
UNIX
1. Edit the ODBC.INI file for the ODBC Data source.

2. Add the WorkArounds parameter and set it to 536870912.
    Example:
      WorkArounds=536870912
Windows
1. Use the registry editor to modify the ODBC Data source under section:
    HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
2. Add a new string value named WorkArounds with its data value set to 536870912.


Note: The WorkArounds parameter will affect all connections connecting to the data source where this property is set.

[{"Product":{"code":"SSVT2J","label":"Informix Tools"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Informix Enterprise Gateway Manager","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF025","label":"Platform Independent"},{"code":"PF008","label":"DYNIX\/ptx"},{"code":"PF010","label":"HP-UX"},{"code":"PF015","label":"IRIX"},{"code":"PF016","label":"Linux"},{"code":"PF026","label":"Reliant UNIX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.2;7.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 January 2022

UID

swg21142219

Page Feedback