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
Last updated on JANUARY 19, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [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 ***
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 -
select count(*) from "mysql_table"@dg4odbc
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
A DG4ODBC debug trace selecting from MySQL shows the following -
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 -
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
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