Skip to Content.
Sympa Menu

freetds - Re: [freetds] A help to configure freetds.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Stacy Gaddy <stacy.gaddy AT sienatech.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] A help to configure freetds.
  • Date: Fri, 15 Sep 2006 12:57:49 -0400

What does your "inithsodbc.ora" file look like?

On Friday 15 September 2006 12:51 pm, Laerte de Sousa wrote:
> 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))(CO
>NNECT _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.
> ________________________________

--
Stacy Gaddy
W-(919)321-0855
C-(910)376-1256
stacy.gaddy AT sienatech.com




Archive powered by MHonArc 2.6.24.

Top of Page