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

    Connect from Oracle 12.2.0.1.0 to Sybase

    4045678

      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