Heterogeneous Connectivity

[dp123]

Hello

I have a need to connect Oracle RDBMS 10g r2 (10.0.2.5.0) to SQL Server 2008 on WIN 64 bit machine.

To achieve this, I have downloaded and Installed Oracle Gateway for ODBC 11G and followed steps outlined below.

However when I create the database link and run a SELECT statement I get following error:

ORA-12154: TNS:could not resolve the connect identifier specified

Below are details of all files. Not sure what is causing this. I have checked TNSNAMES.ora multiple times and no luck :(

No matter what I do I am getting ORA 12154.

Below is my TNSNAME.ora entry from Oracle Database server

SSLTMS=(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=SQLSERVER-DB)(PORT=1521)))
(CONNECT_DATA=(SID=SSLTMS))
(HS=OK)
)

Below is my Listener.ora entry from Gateway server

LISTENER =
 (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=SQLSERVER-DB)(PORT=1521))
 )
 
SID_LIST_LISTENER=
  (SID_LIST=
      (SID_DESC=
         (SID_NAME=SSLTMS)
         (ORACLE_HOME=C:\product\11.2.0\tg_1)
         (PROGRAM=dg4odbc)
      )
  )

And below is the entry of intiSSLTMS.ini file

# 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 = SSLTMS
HS_FDS_TRACE_LEVEL = off
 
 
#
# Environment variables required for the non-Oracle system
#
#set =

My sqlnet.ora on Oracle DB supports all names as shown below

NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10

AND, for some weird reasons Listener does not show any services running is this normal?

STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Produ
ction
Start Date                02-DEC-2011 23:25:34
Uptime                    0 days 0 hr. 7 min. 46 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\product\11.2.0\tg_1\network\admin\listener.ora
Listener Log File         C:\product\11.2.0\tg_1\diag\tnslsnr\SQLSERVER-DB\listene
r\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SQLSERVER-DB)(PORT=1521
)))
The listener supports no services
The command completed successfully

Please help :(

[stecal]

http://www.dbasupport.com/oracle/ora...m-Oracle.shtml

[dp123]

Unfortunatley, Gateway for SQL Server is a paid product and we dont have it.

I am using Oracle Database Gateway for ODBC