SYMPTOM:
The Strategy ODBC driver for Informix XPS is shipped with Strategy products and is used to facilitate connectivity to an Informix Extended Parallel Server (XPS) database. This driver is manufactured by DataDirect Technologies. This driver is called 'Strategy ODBC driver for Informix XPS' in Strategy 9.x.
User attempts to connect to an Informix XPS database using the Strategy ODBC driver for Informix XPS and obtains the following error:
Sample Code/Error
"Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. Specified driver could not be loaded due to system error 126 (Strategy ODBC driver for Informix XPS)"
This error is obtained when attempting to connect from the Strategy Connectivity Configuration Wizard (when attempting to test the connection) as well as from the Strategy DB Query Tool.
CAUSE:
The Strategy ODBC driver for Informix XPS requires the Informix native client connectivity software (also known as Informix Client SDK) for its functioning. This error occurs when the client software has not been installed on the machine where the Strategy ODBC driver for Informix XPS is present.
ACTION:
Install the Informix Client SDK on the machine where the Strategy ODBC driver for Informix XPS is present. This software is not included with the Strategy product suite installation and must be obtained through the database vendor. For information on installation, refer to the product documentation directly provided by the database vendor.
Refer to the Strategy General Information Readme file for the precise version of this ODBC driver and Informix Client SDK that is certified for a specific Strategy product release.
Refer to the following Knowledge Base technical note for details on configuring a Data Source Name (DSN) for the Strategy ODBC Driver for Informix XPS on Windows:
KB30495 - How to configure a Data Source Name for the Strategy ODBC Driver for Informix XPS on Windows
For details on configuring a DSN for the Strategy ODBC Driver for Informix XPS on UNIX/Linux platforms, refer to the information provided in the product manual, Installation and Configuration Guide > Connecting to Databases: ODBCs and DSNs > Creating DSNs for specific ODBC drivers > ODBC Driver for Informix 8 for UNIX.
Third Party Software Installation WARNING
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
