Skip to Content.
Sympa Menu

freetds - [freetds] A help to configure freetds.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Laerte de Sousa" <LAERTE AT griffo.com.br>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] A help to configure freetds.
  • Date: Fri, 15 Sep 2006 13:51:40 -0300

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




Archive powered by MHonArc 2.6.24.

Top of Page