Hello all -

I've been trying to configure Heterogeneous Services to create a connection between an Oracle 10g database & a SQL Server database in my sandbox environment.

I went through the process of:


1) Creating a System DSN to the SQL Server database. The DSN connects to the database successfully when tested. The DSN name is HSTEST.


2) Creating the InitHS file (named initHSTEST.ora), here are the results:

# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = HSTEST
HS_FDS_TRACE_LEVEL = OFF


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


3) Made adjustments to listener.ora. Here are the modifications:

LISTENERHSTEST =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=thk10g)(PORT=1521))
)

SID_LIST_LISTENERHSTEST=
(SID_LIST=
(SID_DESC=
(SID_NAME=HSTEST)
(ORACLE_HOME = c:\oracle\product\10.1.0\db_1)
(PROGRAM=hsodbc)
)
)




4) Made adjustments to tnsnames.ora. Here are the modifications:

HSTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = thk10g)(PORT = 1521)
)
(CONNECT_DATA=
(SID=HSTEST)
)
(HS=OK)
)


I restarted both of my listeners without a problem, but when I try tnsping on the Oracle server, here's what I get:

C:\>tnsping hstest

TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 03-MAY-2
005 12:49:49

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:

TNS-03505: Failed to resolve name




SQL Server and Oracle are running on the same machine. I don't have an issue with tnsping on any of the other Oracle databases. What I'm trying to figure out is if I have done anything incorrectly on the HS configuration.

If I haven't done anything incorrectly, is the Transparent Gateway an option? And can I download the Transparent Gateway from OTN for development use?

All help will be sincerely appreciated!


- E