Cannot Connect To Informix Database Because Of [Informix] -23197 Error Using DG4Ifmx (Doc ID 960088.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database Gateway for Informix - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
**Checked for relevance on 01-AUG-2011***


Symptoms

-- Problem Statement:
You have configured Database Gateway for Informix (DG4Informix) to connect to Informix from Oracle 10.2.
A select gives the following error -

SQL> select * from "table_name"@dg4informix;
select * from "table_name"@dg4informix
*
ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system
returned this message:
[Oracle][ODBC Informix Wire Proto driver][Informix]-23197[Oracle][ODBC
Informix Wire Protocol driver]Invalid attribute in connection string:
ArraySize.[Oracle][ODBC Informix Wire Protocol driver]Invalid attribute in
connection string: TruncateOversizedColumnValues.
ORA-02063: preceding 2 lines from DG4INFORMIX

The error -23197 is -

-23197 Database locale information mismatch.
The locale information GL_CTYPE or GL_COLLATE in the system catalog of the
specified database does not match the locale information in the specified
environment variable DB_LOCALE. Check the value of DB_LOCALE.

However, all the Oracle and Informix NLS parameters are correct.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms