Help needed for Heterogenous Service from Oracle to Sql server
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.
