[freetds] RES: A help to configure freetds.

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


Sorry, I forget this.

Thank you



inithsodbc.ora

# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent. 

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = ymf
HS_FDS_TRACE_LEVEL = 4
HS_FDS_TRACE_FILE_NAME = freetds.trc
HS_FDS_SHAREABLE_NAME = /usr/lib/libodbc.so

#
# ODBC specific environment variables
#
set ODBCINI=/etc/odbc.ini


#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>



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

-----Mensagem original-----
De: freetds-bounces at lists.ibiblio.org [mailto:freetds-bounces at lists.ibiblio.org] Em nome de Stacy Gaddy
Enviada em: sexta-feira, 15 de setembro de 2006 13:58
Para: FreeTDS Development Group
Assunto: Re: [freetds] A help to configure freetds.

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
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds



More information about the FreeTDS mailing list