My Oracle Support Banner

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>


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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.