[freetds] A help to configure freetds.

Laerte de Sousa LAERTE at griffo.com.br
Fri Sep 15 12:51:40 EDT 2006


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. 
________________________________

 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 1646 bytes
Desc: image001.gif
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20060915/3907e86c/attachment.gif 


More information about the FreeTDS mailing list