Oracle Database Discussions

Hi to All,

In order to create an heterogeneous connection between Oracle DB 10g and MSSQL Server, in the listener.ora I have:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\OraHome10)
(PROGRAM = extproc)
)
)

SID_LIST_LISTENERTESTSQL2005DSN =
(SID_LIST =
(SID_DESC =
(SID_NAME = TESTSQL2005DSN)
(ORACLE_HOME = E:\oracle\product\10.2.0\OraHome10)
(PROGRAM = hsodbc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = softblue01.sede.softblue.lan)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

LISTENERTESTSQL2005DSN =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = softblue01.sede.softblue.lan)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
)
)


In the tnsnames.ora I have:

TESTSQL2005DSN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = softblue01.sede.softblue.lan)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = TESTSQL2005DSN)
)
)


SOFTBLUE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = softblue01.sede.softblue.lan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = SOFTBLUE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


Both the listener are started correctly. But if I try to validate the DSN connection this is the result:

C:\>tnsping TESTSQL2005DSN

TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 20-OTT-2007 13:19:54

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

Used parameter files:
e:\oracle\Devsuite10\network\admin\sqlnet.ora

TNS-03535 Failed to resolve name

The Oracle Home e:\oracle\Devsuite10 is the home of developper Suite; the correct OH must be E:\oracle\product\10.2.0\OraHome10

Please, can You help me in order to resolve this problem ?

Thank You and Best Regards
Gaetano

PS I have installed 3 Oracle Home: the first for Oracle DB 10g, the second for Oracle Application Services Forms and Reports, the third for Oracle Dev Suite 10.