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 JUNE 19, 2018

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

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.