Oracle Database Discussions

I am getting the following error trying to use a SQL gateway on Windows platforms:
TNSPing seems fine (which seems like listener is fine).


ERROR at line 1:
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 DG4MSQL

The dg4msql gateway (32 bit box, 11.2.0) exists on a separate machine from the 64 bit Oracle database (10.2.0.4)
and is trying to call a MS SQL 2005 database. The listener starts and stops fine and TNSPing from the database box returns OK.

Thanks for any advice in advance and sorry for the length of the post but I tried to show all the relevant parts. I am a newbie for sure.

The Oracle_Home is on: C:\product\11.2.0\tg_1 and that is included as the first part of the path statement (C:\product\11.2.0\tg_1\bin).

LISTENER.ORA File (running on the gateway server box)
=============================
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = clickimrs.blackfoot.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ADR_BASE_LISTENER = C:\product\11.2.0\tg_1

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4msql)
(ORACLE_HOME=C:\product\11.2.0\tg_1)
(PROGRAM=dg4msql)
)
)


initdg4msql.ORA file (exists in C:\product\11.2.0\tg_1\dg4msql\admin on gateway box)
====================================
# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for Microsoft SQL Server

#
# HS init parameters
#
HS_FDS_CONNECT_INFO=[MG-FM]/MG-FM/Blackfoot_OasisFM
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER


TNSMAMES.ORA (running on the database server box)
=======================================
dg4msql =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=CLICKIMRS.blackfoot.com)(PORT=1521))
(CONNECT_DATA=(SID=dg4msql))
(HS=OK)
)


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


SQLNET.ORA (running on the database server box)
=====================================
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)


My create dblink statement:
====================================
create public database link dg4msql connect to "Axiom" identified by "ax" using 'dg4msql';