DG4ODBC 11.2 Gives Errors ORA-28500 or ORA-01858 Connecting To Red Brick

(Doc ID 1267393.1)

Last updated on NOVEMBER 30, 2010

Applies to:

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


After configuring the Oracle Database Gateway for ODBC on IBM AIX 6.1 any SELECT from Oracle Server to Red Brick fails with a variety of errors, for example -

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:


ERROR:ORA-01858: a non-numeric character was found where a numeric was expected


empty rows are returned for the SELECT


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