FreeTDS Development Group

["Laerte de Sousa" <LAERTE AT griffo.com.br>]

I'm trying to configue the freetds version 0.63 in a Oracle 10.2 version with 
Linux ES to connect a SqlServer 2000.
I install the freetds, unixodbc and configure the Oracle's files.
I connect to SqlServer with tsql and isql and all it's ok. The tnsping return 
ok too, but when I try to user a dblink I reveice the message:
select * from "Region"@lnk_ymf
              *
ERROR at line 1:
ORA-02068: following severe error from LNK_YMF
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.37.13)(PORT=1521))(CONNECT
_DATA=(SID=hsodbc)))
 
Below is my Oracle's files.
 
I will be tankfull if you can help me.
 
Tks
 
 
listener.ora
 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/app/product/10.2.0/db_dw)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = hsodbc)
      (ORACLE_HOME = /home/oracle/app/product/10.2.0/db_dw)
      (PROGRAM = hsodbc)
      
(ENVS="LD_LIBRARY_PATH=/home/oracle/app/product/10.2.0/db_dw/lib:/usr/lib")
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.37.13)(PORT = 1521))
    )
  )
 
 
tnsnames.ora
 
YMFSQL = 
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.37.13) (PORT = 1521))
    (CONNECT_DATA = (SID=hsodbc) )
    (HS=OK)
  )
 
 
odbc.ini
 
[ODBC Data Sources]
ymf = SqlServer YMF
 
[ymf]
Driver = FreeTDS
Description = Servidor YMF
Trace = Yes
Database = Northwind
TracelFile = /tmp/sql.log
Servername = YMFSQL
Port = 1433
TDS_Version = 8.0
 
 
odbcinst.ini
 
[FreeTDS]
Description = v0.63 (develop)
Driver = /usr/lib/libtdsodbc.so
Setup = /usr/lib/libtdsodbc.so
FileUsage = 1
Trace = Yes
TraceFile = /tmp/sql.log
 
[ODBC]
Trace = Yes
Tracefile = /tmp/sql.log
ForceTrace = Yes
Pooling = No
 
 
 
freetds.conf
 
[YMFSQL]
      host = 192.168.37.44
      port = 1433
      tds version = 8.0
 
 
 
 
Laerte Alves de Souza
Monitoria
++55 11 3704 8750
++55 11 3704 8666 (fax)
laerte AT griffo.com.br
________________________________

Esta mensagem, incluindo seus anexos, pode conter informação confidencial 
e/ou privilegiada. Se você recebeu este e-mail por engano, não utilize, copie 
ou divulgue as informações nele contidas. Por favor, avise imediatamente o 
remetente, respondendo ao e-mail, e em seguida apague-o. Caso necessite de 
atendimento imediato, recomendamos utilizar um dos canais disponíveis: 
www.griffo.com.br ou telefone (11) 3704 8600. Agradecemos sua colaboração.

This message, including its attachments, may contain confidential and/or 
privileged information. If you have received this email by mistake, do not 
use, copy or disseminate any information herein contained. Please notify us 
immediately by replying to the sender and then delete it. In case you need 
immediate assistance, please use one of the following: www.griffo.com.br ou 
phone: 55 11 3704 8600. Thank you for your cooperation. 
________________________________

Attachment: image001.gif
Description: image001.gif