FreeTDS Development Group

[Stacy Gaddy <stacy.gaddy AT sienatech.com>]

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