Errors ORA-28500 And SQL State S1000 When Selecting From Ingres 2.0 Database Using Generic Connectivity (Doc ID 153173.1)

Last updated on JULY 20, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.2 - Release: 11.1 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 20-Jul-2011***

Symptoms

Generic Connectivity using Database Gateway for ODBC (DG4ODBC) has been configured to access Ingres v2.0 and a select gives the following error -

SQL> select count(*) from user_catalog@hsodbc;
select count(*) from user_catalog@hsodbc
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Transparent gateway for ODBC][CA][Ingres ODBC Driver][Ingres]The connection to
the server has been aborted. (SQL State: S1000; SQL Code: 5)
ORA-02063: preceding 2 lines from HSODBC

A gateway debug trace will show the following -

(0) hoalgon(7); Entered. name = INGRES.
(0) [CA][Ingres ODBC Driver][Ingres]The connection to the server has been aborted.
(0) (SQL State: S1000; SQL Code: 5)
(0) DRV_InitTdp: [CA][Ingres ODBC Driver][Ingres]The connection to the server has
(0) been aborted. (SQL State: S1000; SQL Code: 5)
(0)
(0) nvRETURN (P:\Src\DRV\DRV_BIND.C 324): -2220
(0) nvRETURN (P:\Src\NAV_BIND.C 417): -2220
(0) nvOUT (P:\Src\UTIL\GETERROR.C 327): DRV_InitTdp: [CA][Ingres ODBC
(0) Driver][Ingres]The connection to the server has been aborted. (SQL State:
(0) S1000; SQL Code: 5)
(0) hoalgon(7); Exited with retcode = 28500.
(0) hoaexit(6); Entered.
(0) hoaexit(6); Exited with retcode = 0.
(0) hoautil; Closing log file at WED JUL 25 11:07:09 2001.


the line -

(0) hoalgon(7); Entered. name = INGRES.


shows that the logon attempt to the Ingres database is as the user INGRES in upper case.

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