Oracle Connect to SQL Server via heterogeneous Services

Folks,

This is actually a little different than the last question i asked which was a listener issue.  This may be as well.  however i had to scrap the last method as HS doesnt support 64 bit ODBC.  I am trying to make a connection to sql server via heterogeneous Services with Oracle 10.2 database and also OWB 10.2.  I have followed the tutorial on http://www.databasejournal.com/features/oracle/article.php/10893_3442661_1 
Scenario
windows server 2003 with oracle 10.2 database and owb 10.2 in different homes
listener etc in the following
db =D:\oracle\product\10.2.0\rdbms\NETWORK\ADMIN
owb = E:\oracle\product\owb\network\ADMIN
sql server on machine B which is a standalone server so i must use uid/pwd to connect
odbc connection to sql server systemdsn name = "mysqlserverdsn" test = "TESTS COMPLETED SUCCESSFULLY!"


I have the same files in 4 places
OWB path
D:\oracle\product\10.2.0\rdbms\NETWORK\ADMIN
D:\oracle\product\10.2.0\rdbms\hs\admin
DB Path
E:\oracle\product\owb\network\ADMIN
E:\oracle\product\owb\hs\admin

INITMYSQLSERVERDSN.ORA =
      HS_FDS_CONNECT_INFO = MYSQLSERVERDSN
      HS_FDS_TRACE_LEVEL  = OFF

LISTENER.ORA =
      SID_LIST_LISTENER =
        (SID_LIST =
          (SID_DESC =
            (SID_NAME = PLSExtProc)
            (ORACLE_HOME = d:\oracle\product\10.2.0\rdbms)
            (PROGRAM = extproc)
          )
        )
      
      LISTENER =
        (DESCRIPTION_LIST =
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
            (ADDRESS = (PROTOCOL = TCP)(HOST = srv-winora.bob.org)(PORT = 1521))
          )
      
        )
      
      LISTENERMYSQLSERVERDSN =
       (ADDRESS_LIST=
            (ADDRESS=(PROTOCOL=tcp)(HOST=srv-winora.bob.org)(PORT=1522))
            (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
      
      SID_LIST_LISTENERMYSQLSERVERDSN=
        (SID_LIST=
            (SID_DESC=
               (SID_NAME=MYSQLSERVERDSN)
               (ORACLE_HOME = E:\oracle\product\owb)
               (PROGRAM=hsodbc)
             )
         )


SQLNET.ORA
      SQLNET.AUTHENTICATION_SERVICES= (NTS)
      NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
      
      
TNSNAMES.ORA
      RDBMS =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = srv-winora.bob.org)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = rdbms)
          )
        )
      
      OWBREPO =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = srv-winora.bob.org)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = owbrepo.bob.org)
          )
        )
      
      EXTPROC_CONNECTION_DATA =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
          )
          (CONNECT_DATA =
            (SID = PLSExtProc)
            (PRESENTATION = RO)
          )
        )
      
      MYSQLSERVERDSN  =
        (DESCRIPTION=
          (ADDRESS=(PROTOCOL=tcp)(HOST=srv-winora.bob.org)(PORT=1522))
          (CONNECT_DATA=(SID=MYSQLSERVERDSN))
          (HS=OK)
        )

so i have the same 4 files in each of the above directories.
and i stop and start my listeners.
>lsnrctl stop
>lsnrctl stop listenermysqlserverdsn
>lsnrctl start
>lsnrctl start listenermysqlserverdsn

try a tns ping
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=srv-winora
.bob.org)(PORT=1522)) (CONNECT_DATA=(SID=MYSQLSERVERDSN)) (HS=OK))
OK (20 msec)


start sql plus
connect sys@rdbms as sysdba
... connected
SQL>create database link mysqlserverdsn
 connect to sa identified by pwd using 'MYSQLSERVERDSN'

Database link created.

SQL> desc vehicle@mysqlserverdsn
ERROR:
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 MYSQLSERVERDSN

I try the same thing with
connect sys@owbrepo as sysdba
and get the same results

recap
machine A windows server 2003 with oracle 10.2 database and owb 10.2 in different homes
listener etc in the following
db =D:\oracle\product\10.2.0\rdbms\NETWORK\ADMIN
owb = E:\oracle\product\owb\network\ADMIN
sql server on machine B which is a standalone server so i must use uid/pwd to connect
odbc connection to sql server systemdsn name = "mysqlserverdsn" test = "TESTS COMPLETED SUCCESSFULLY!"
TNSPING ok
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 MYSQLSERVERDSN

I have searched high and low and the oracle errors point me to a tns ping which works.
One thing i ddn't do is set any path variables which may be the whole issue.  

however i executed sqlplus from each home directory/bin

Thanks,

Steve