I'm trying to configure Oracle Database Gateway for Sybase. I've followed oracle manuals but link to sybase is not working. I receive following error while trying to select from sybase database:
SELECT * FROM DUAL@billd * ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: ORA-02063: preceding line from BILLD
Here's what trace says:
HOSGIP for "HS_FDS_TRACE_LEVEL" returned "ON"
ODBCINST set to "/opt/oracle/product/11.1.0/db_1/dg4sybs/driver/dg4sybs.loc"
RC=-1 from HOSGIP for "LD_LIBRARY_PATH"
LD_LIBRARY_PATH from environment is "/opt/oracle/product/11.1.0/db_1/lib"
HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "libodbc.so"
Failed to load ODBC library symbol: libodbc.so(SQLAllocHandle)
String HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "libodbc.so" looks suspiciously because I've explicitly defined that HS_FDS_SHAREABLE_NAME=/opt/oracle/product/11.1.0/db_1/dg4sybs/driver/lib/libodbc.so It seems to me that this setting gets ignored and that's why the whoole system doesn't work. Any suggestions ? Thanks in advance -)