hi,

When i am trying to connect from oracle to Sql server through db_link following error is showing. Please try to help me out in this regard.

SQL> desc temp_empbankacc_gpms@sqltest
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 SQLTEST

Heterogenous Configuration Details
------------------------------------
ODBC.ini
----------

[sqltest]
Driver = TDS
Description = MS SQL Test
Trace = No
Servername = MSTEST
Database = VDPMASTER
UID =
Port = 1433

odbcinst.ini
------------

[TDS]
Description = v0.62.3 with protocol v4.2
Driver = /usr/local/lib/libtdsodbc.so
Setup = /usr/local/lib/libtdsodbc.so
FileUsage = 1
CPUTimeout =
CPReuse =

[ODBC]
Trace = Yes
TraceFile = /tmp/freetds.log
ForceTrace = Yes
Pooling = No


freetds.conf
--------------
[MSTEST]
host = 172.27.42.179
port = 1433
tds version = 8.0

initSQLTEST.ora
----------------

# needed for an ODBC Agent.

#
# HS init parameters
#

HS_FDS_CONNECT_INFO = sqltest

HS_FDS_TRACE_LEVEL = 0

following is Added in my existing listener.ora
-------------------------------------------


(SID_DESC =
(ORACLE_HOME=/u01/payroll/oracle/product/10.2.0.1)
(PROGRAM=hsodbc)
(SID_NAME=sqltest)

following is Added in my existing tnsnames.ora
-------------------------------------------
SQLTEST =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP) # edit to point to your LISTENER
(HOST=172.16.189.186) # edit to point to your LISTENER
(PORT=1522) # edit to point to your LISTENER
)
)
(CONNECT_DATA=(SID=sqltest))
(HS=OK)

I can able to connect with isql and tsql...

but i am unble to connect with db_link

SQL> CREATE PUBLIC DATABASE LINK sqltest connect to "payrolluser" IDENTIFIED by "user@payroll" using 'sqltest';

Database link created.
SQL> desc temp_empbankacc_gpms@sqltest
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 SQLTEST


where i would have gone wrong. Please help me.


Thanks in Advance.
Rama.