HS_FDS_CONNECT_INFO = data_extract
HS_FDS_TRACE_LEVEL = 0

sqlserver.db =
        (DESCRIPTION =
                (ADDRESS = (protocol=tcp)(host=10.10.10.10)(port=49400))
                        (connect_data = (sid=data_extract))
                        (hs=ok)
        )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = merlin)(PORT = 1525))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u/app/oracle/product/10.2.0/db)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ccsbill.syntegra.bt.co.uk)
      (ORACLE_HOME = /u/app/oracle/product/10.2.0/db)
      (SID_NAME = billdb)
    )
    (SID_DESC =
        (SID_NAME = Avante_Import)
        (ORACLE_HOME = /u/app/oracle/product/10.2.0/db)
        (program = hsodbc)
    )
  )

create database link sqlservdb using 'sqlserver.db';

sqlplus> select * from TESTTABLE@sqlservdb;
select * from TESTTABLE@sqlservdb
                           *
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from ORASQLSERVER

VERSION
-----------------
10.2.0.3.0

28545, 0000, "error diagnosed by Net8 when connecting to an agent"
// *Cause:   An attempt to call an external procedure or to issue SQL
//           to a non-Oracle system on a Heterogeneous Services database link
//           failed at connection initialization.  The error diagnosed
//           by Net8 NCR software is reported separately.
// *Action:  Refer to the Net8 NCRO error message.  If this isn't clear,
//           check connection administrative setup in tnsnames.ora
//           and listener.ora for the service associated with the
//           Heterogeneous Services database link being used, or with
//           'extproc_connection_data' for an external procedure call.

CMS=(DESCRIPTION=
    (ADDRESS=(PROTOCOL=TCP)
             (HOST=localhost)
             (PORT=1531)
           )
(CONNECT_DATA=(SID=CMS))
              (HS=OK)
        )

LISTENERhs =
 (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1531))
      (ADDRESS=(PROTOCOL=ipc)(KEY=CMS))
 )

SID_LIST_LISTENERhs=
  (SID_LIST=
       (SID_DESC=
         (SID_NAME=CMS)
         (ORACLE_HOME = /pfk/app/oracle/product/10.2.0)
         (PROGRAM=hsodbc)
         (ENVS=LD_LIBRARY_PATH=/usr/local/lib:/pfk/app/oracle/product/10.2.0/lib32)
      )
)

HS_FDS_CONNECT_INFO = CMS
HS_FDS_SHAREABLE_NAME = /usr/local/lib/libodbc.so
HS_LANGUAGE=American_America.we8iso8859p1

# ODBC specific environment variables
set ODBCINI=/usr/local/etc/odbc.ini

[CMS]
Driver = TDS
Description = Document Management System
Servername = srvCMS
Database = cms_db

[srvCMS]
        host = 192.168.10.5
        port = 1433
        tds version = 7.0

CMS=(DESCRIPTION=
    (ADDRESS=(PROTOCOL=TCP)
             (HOST=localhost)
             (PORT=1531)
           )
(CONNECT_DATA=(SID=CMS))
              (HS=OK)
        )