Setup Heterogeneous Service

Server (Sybase) requirements:
Add an ODBC entry in System DSN tab, make sure connection test is successful #Be aware of 32/64 bit of ODBC driver, in this example odbcSYB as DSN (Data Source Name) is named.
Install Oracle 11g database software only on Sybase server.
#Create Oracle HS init file
$ORACLE_HOME/hs/admin/initodbcSYB.ora
HS_FDS_CONNECT_INFO = odbcSYB
HS_FDS_TRACE_LEVEL = off
#Link HS SID in listener.ora
$ORACLE_HOME/network/admin/listener.ora
SID_LIST_LISTENER=
  (SID_LIST=
      (SID_DESC=
         (SID_NAME=odbcSYB)
         (ORACLE_HOME=C:\oracle\product\11.1.0\db_1)
         (PROGRAM=DG4ODBC)
      )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = SYB_SERVER)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
#Restart Listener

Client requirements:

tnsnames.ora
odbcSYB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SYB_SERVER)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = odbcSYB)
    )
  (HS=OK)
  )
database link
create database link odbcSYB
connect to “sa” identified by “1234”
using ‘odbcSYB‘;
global_names
global_names has to set to FALSE
network connectivity
A port connectivity needs to be opened bi-directional between client and server for listener, default is 1521.