Hello -

I've been trying to configure Heterogeneous Services to create a connection between an Oracle 11g database & an ODBC based database. I did the following:

1) Created a System DSN to the ODBC based database. The DSN connects to the database successfully when tested. The DSN name is HSTEST.


2) Creating initHSTEST.ora (in C:\app\me\product\11.1.0\db_1\hs\admin) as follow:

# 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 = HSTEST
HS_FDS_TRACE_LEVEL = off


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

3) Changed listener.ora as follow:

# listener.ora Network Configuration File: C:\app\me\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
)

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=HSTEST)
(ORACLE_HOME=C:\app\me\product\11.1.0\db_1)
(PROGRAM=dg4odbc)
)
)

4) Changed Tnsnames.ora as follow

# tnsnames.ora Network Configuration File: C:\app\me\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

HSTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip scrubbed)(PORT = port scrubbed))
(CONNECT_DATA = (SID = HSTEST)
)
(HS = OK)
)

5) restarted the listener

6) pinged hstest and got the following error

C:\Documents and Settings\me>tnsping hstest

TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 07-JUL-2009 15:59:26

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

Used parameter files:
C:\app\me\product\11.1.0\db_1\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

C:\Documents and Settings\me>

Pls Advice
Txs
Shaf