Last updated on JANUARY 19, 2017
Applies to:Oracle Database Gateway for Informix - Version 18.104.22.168 to 22.214.171.124 [Release 11.1]
Information in this document applies to any platform.
**Checked for relevance on 01-AUG-2011***
-- 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.
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