My Oracle Support Banner

ORA-28500 A Syntax Error Has Occurred After Upgrading To DG4ODBC 11.2.0.3 When Selecting From an Informix Database (Doc ID 1464712.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

After upgrading to 11.2.0.3 from 11.2.0.2, the following error occurs when connecting to an Informix database via a database link using Database Gateway for ODBC (DG4ODBC).

SQL> select * from people@visa;
select * from people@visa
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Informix][Informix ODBC Driver][Informix]A syntax error has occurred. {42000,NativeErr = -201}
ORA-02063: preceding 2 lines from VISA



In 11.2.0.2, this worked successfully without double quotes surrounding the table names.

Changes

 In the 11.2.0.2 gateway trace file, we can see:

Heterogeneous Agent Release
11.2.0.2.0

Oracle Corporation --- FRIDAY    MAY 18 2012 10:50:48.632
   Version 11.2.0.2.0

Parameter HS_FDS_QUOTE_IDENTIFIER is not set
........
SQLGetInfo returns   (0x20) for SQL_IDENTIFIER_QUOTE_CHAR
SQLGetInfo returns N for SQL_COLUMN_ALIAS
4 instance capabilities will be uploaded
 capno:1989, context:0x00000000, add-info:        0
 capno:1991, context:0x00000000, add-info:        0
 capno:1992, context:0x0001ffff, add-info:        1, translation:" "
 capno:3007, context:0x00000000, add-info:       -3, translation:"36"

In the 11.2.0.3 gateway trace file, we can see:

Heterogeneous Agent Release
11.2.0.3.0
Oracle Corporation --- MONDAY    MAY 21 2012 14:19:10.137
   Version 11.2.0.3.0
setting HS_FDS_QUOTE_IDENTIFIER to default of "TRUE"
.....
SQLGetInfo returns 32 for SQL_MAX_SCHEMA_NAME_LEN
SQLGetInfo returns 128 for SQL_MAX_TABLE_NAME_LEN
SQLGetInfo returns 128 for SQL_MAX_PROCEDURE_NAME_LEN
HOSGIP returned value of "TRUE" for HS_FDS_QUOTE_IDENTIFIER
SQLGetInfo returns   (0x20) for SQL_IDENTIFIER_QUOTE_CHAR
3 instance capabilities will be uploaded
 capno:1989, context:0x00000000, add-info:        0
 capno:1992, context:0x0001ffff, add-info:        0
 capno:3007, context:0x00000000, add-info:       -3, translation:"36"

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.