4 Replies Latest reply on Sep 2, 2019 3:12 PM by Toni Junior

    Connect from Oracle to Sybase

    Toni Junior

      Hello ,

      please let me know what should I do to make this connection possible by database link from Oracle connecting to Sybase .


      What I did so far is I modified   initdg4odbc.ora /app/oracle/product/12.2/db_1/hs/admin 


      # This is a sample agent init file that contains the HS parameters that are # needed for the Database Gateway for ODBC

      # #HS init parameters #


      HS_FDS_CONNECT_INFO = sybaseDBname

      HS_FDS_TRACE_LEVEL = off

      HS_FDS_SHAREABLE_NAME = /app/oracle/product/12.2/db_1/dg4odbc.o  -->is this correct ?


      # # ODBC specific environment variables #

      set ODBCINI=<full path name of the odbc initilization file>  -> for this I don't know where odbc init file is


      # # Environment variables required for the non-Oracle system #


      set <envvar>=<value>  -> don't know what to put here



      This the OS on which Oracle is :


      Linux  4.14.35-1844.2.5.el7uek.x86_64