2 Replies Latest reply: Aug 7, 2012 1:50 PM by tx103108 RSS

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

    tx103108
      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.