This discussion is archived
2 Replies Latest reply: Aug 7, 2012 11:50 AM by tx103108 RSS

Oracle Transparent Gateway for ODBC error on SELECT from Sybase Anywhere 11

tx103108 Newbie
Currently Being Moderated
Environment:
------------------
O/S: CentOS 6.2 (64-bit)
Oracle DB: Oracle XE 11.2.0.2.0 (64-bit)
Sybase DB: Sybase Anywhere 11 (64-bit)
ODBC driver: unixODBC 2.3.1 (64-bit)
ODBC drivers: Sybase Anywhere Client ODBC (64-bit)
Oracle ODBC Gateway: 11.2.0.1.0 (64-bit)
NOTE: Both databases are local.
Modified init.ora in gateway home directory and modified (and using) listener.ora and tnsnames.ora in Oracle XE home directory.
The listener and tnsping started/worked successfully.
-----------------------------------------------------------

Issue:
----------

Getting the following error when trying to SELECT from a Sybase Anywhere 11 database via the Oracle ODBC Gateway running with Oracle XE:

SQL> select * from employees@SybASA;
select * from employees@SybASA;
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[

SQL>

Enabled trace in gateway init.ora file (initSybASA.ora) and got the following at the end of the trace file:

hgocont, line 2752: calling SqlDriverConnect got sqlstate 0
Exiting hgocont, rc=28500 at 2012/08/05-08:44:56 with error ptr FILE:hgocont.c LINE 2772 FUNCTION:hgocont() ID:Something other than invalid authorization
Exiting hgocont, rc=28500 at 2012/08/05-08:44:56 with error ptr FILE:hgocont.c LINE 781 FUNCTION:hgolgon() ID:Calling hgocont
Entered hgoexit at 2012/08/05-08:44:56
Exiting hgoexit, rc=0

---------------------------------------
Any advice would be appreciated. Thx.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points