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 JULY 15, 2023
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.
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>
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
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
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
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 |
| Cause |
| Solution |
| References |