FreeTDS Development Group

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

So, it appears your oracle setup is correct.  I posted this very problem to 
this list a few weeks ago.  I think the advice I got was to provide some 
trace info from odbc.  I did extensive testing with both the freetds driver 
and a commercial driver. Using the tools that come with freetds, I could 
never get the data I was requesting from SQLServer to fail, worked every 
time...as soon as I tried to retrieve the same data via the oracle 
connection....it would randomly fail.  I had the poorest luck requesting data 
from SQLServer from Oracle using the SQLServer image data type.  I ended up 
abandoning the odbc method and opted to write some java code that could be 
loaded directly into oracle db and used jdbc to get data from SQLServer.  I 
know this isnt a solution to your problem, but in my option, the hsodbc 
interface that oracle provides just isnt very solid.  Neither is the Oracle 
Gateway for SQLServer...had similar problem with that.

Stacy

On Friday 15 September 2006 12:59 pm, Laerte de Sousa wrote:
> 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