Oracle Database Discussions

Hi All,

i'am doing heterogeneous connectivity as oracle 10G (Unbreakable linux4) to sql server (SQL SERVER 2008)

The DSN and the connections works ok (FreeTDS and UniXODBC).

I create the dblink

create database link inforpyme connect to "sa" identified by " " using 'INFORPYME';

and when I do select * from "sysobjects"@inforpyme I get the next error:

ORA-28545: error diagnosticado por Net8 al conectar a un agente
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: 2 lines precediendo a INFORPYME

***************************************************************************************
This is my listener:
IBK =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY=PNPKEY))
)
)
)

SID_LIST_IBK =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ibk)
(ORACLE_HOME = /App/oracle/ora10g2)
(SID_NAME = ibk)
)
(SID_DESC=
(SID_NAME=inforpyme)
(ORACLE_HOME=/App/oracle/ora10g2)
(PROGRAM=hsodbc)
)
)

******************************************************************************************
My tnsnames:
INFORPYME =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.1)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME=inforpyme))(HS=OK)
)

The TNSping gets

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.1)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME=inforpyme))(HS=OK))
OK (0 msec)

******************************************************************************************
and the initINFORPYME.ora:
HS_FDS_CONNECT_INFO = inforpyme
HS_FDS_TRACE_LEVEL = debug
HS_FDS_TRACE_FILE_NAME = /tmp/freetds.trc
HS_FDS_SHAREABLE_NAME = /usr/local/lib/libtdsodbc.so

#
# ODBC specific environment variables
#
set ODBCINI=/usr/local/etc/odbc.ini


Anybody may help me? Thanks