9 Replies Latest reply: May 29, 2014 2:13 AM by Kgronau-Oracle RSS

    Can't open lib '/usr/local/93AS/connectors/odbc/lib/edb-odbc.so'

    2671659

      Hi guys,

      I want to connect from oracle 11g to EDB  . l get this error

      create database link cc connect to "enterprisedb" identified by "oracle" using 'EDB';

      select * from "tba"@cc;

      ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

      [unixODBC][Driver Manager]Can't open lib'/usr/local/93AS/connectors/odbc/lib/edb-odbc.so' : file not found {01000}

      ORA-02063: preceding 2 lines from CC

       

      I can connected to EDB using isql,but in sqlplus I got the error.

      tnsping EDB is ok!

      Why these happening how to solve this?

      Thank you!



      odbc.ini:

      [EDB]

      Driver = /usr/local/93AS/connectors/odbc/lib/edb-odbc.so

      Description = Test2EDB

      Servername = localhost

      PORT = 5444

      UserName = enterprisedb

      Password = oracle

      Database = testdb

      TRACE =Yes

      TaceFile = /tmp/sql.log

       

      initiEDB.ora:

      HS_FDS_CONNECT_INFO = EDB

      HS_FDS_TRACE_LEVEL = 255

      HS_FDS_SHAREABLE_NAME = /usr/local/unixodbc/lib/libodbc.so

      HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1

      HS_NLS_NCHAR = UCS2

      set ODBCINI=/etc/odbc.ini

      set LD_LIBRARY_PATH=/usr/local/93AS/lib