Error Ora-28500 and Sqlstate I or Displays a Square Bracket - [ - Issuing Selects From a Unicode Oracle RDBMS With Dg4odbc To Non-Oracle Databases Using the UnixODBC Driver Manager (Doc ID 756186.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Information in this document applies to any platform.
*** checked for relevancy 31-MAY-2010 ***
*** checked for relevancy 15-AUG-2012 ***

Symptoms

Using Database gateway for ODBC (DG4ODBC)  to select from MySQL or other non-Oracle databases, such as a Cache database, gives errors similar to the following -

SQL> select count(*) from "mysql_table"@dg4odbc;
select count(*) from "mysql_table"@dg4odbc
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[

SQL>


A DG4ODBC debug trace selecting from MySQL shows the following -

Entered hgopoer at 2008/12/12-13:17:16
hgopoer, line 159: got native error 0 and sqlstate I; message follows...
[
Exiting hgopoer, rc=0 at 2008/12/12-13:17:16
hgocont, line 1903: calling SqlDriverConnect got sqlstate I
Exiting hgocont, rc=28500 at 2008/12/12-13:17:16 with error ptr FILE:hgocont.c LINE:1923
FUNCTION:hgocont() ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2008/12/12-13:17:16 with error ptr FILE:hgolgon.c LINE:612
FUNCTION:hgolgon() ID:Calling hgocont
Entered hgoexit at 2008/12/12-13:17:16

 

The same error may also be received when selecting from a SQL*Server table.
A debug trace selecting from SQL*Server may show the following -

Entered hgopoer at 2013/05/07-19:06:47
hgopoer, line 233: got native error 18452 and sqlstate 2; message follows...
[
Exiting hgopoer, rc=0 at 2013/05/07-19:06:47
hgocont, line 2752: calling SqlDriverConnect got sqlstate 2
Exiting hgocont, rc=28500 at 2013/05/07-19:06:47 with error ptr FILE:hgocont.c LINE:2772 FUNCTION:hgocont() ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2013/05/07-19:06:47 with error ptr FILE:hgolgon.c LINE:781 FUNCTION:hgolgon() ID:Calling hgocont
Entered hgoexit at 2013/05/07-19:06:47
Exiting hgoexit, rc=0

 

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