Skip to Content.
Sympa Menu

freetds - RE: [freetds] RE: Bug in SQLNumResultCol function?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] RE: Bug in SQLNumResultCol function?
  • Date: Tue, 15 Jun 2004 09:18:03 +0200

>
> freddy77,
>
> After I did ./configure --prefix=/usr/local/freetds
> --with-unixodbc=/usr/local/unixODBC as you suggested with the
> following
> configuration in /etc/odbcinst.ini
>
> [TDS]
> Description = FreeTDS v0.63
> Driver = /usr/local/freetds/lib/libtdsodbc.so
> Setup = /usr/local/freetds/lib/libtdsodbc.so
> FileUsage = 1
> Trace = Yes
> TraceFile = /tmp/sql.log
>

Section for trace settings should be ODBC, I think your odbcinst.ini
should be

[TDS]
Description = FreeTDS v0.63
Driver = /usr/local/freetds/lib/libtdsodbc.so
Setup = /usr/local/freetds/lib/libtdsodbc.so
FileUsage = 1

[ODBC]
Trace = Yes
TraceFile = /tmp/sql.log
ForceTrace = Yes
Pooling = No

> and /etc/odbc.ini
>
> [peregrine]
> Description = Peregrine MS SQL Server
> Driver = TDS
> Servername = peregrine
> Trace = Yes
> TraceFile = /tmp/sql.log
> ForceTrace = Yes
> Pooling = No
>
> the command isql -v peregrine <username> <password> works fine.
> But the database link msticket in oracle to the MS SQL server
> peregrine
> still doesn't work. I run select * from "scProblem"@msticket
> in Oracle
> SQLPLUS
> and got the error:
> select * from "scProblem"@msticket
> *
> ERROR at line 1:
> ORA-02068: following severe error from MSTICKET
> ORA-28511: lost RPC connection to heterogeneous remote agent
> using SID=%s
> ORA-28509: unable to establish a connection to non-Oracle system
>

Mmmm... I don't know Oracle, are you sure connection is set ok?

> The log sql.log didn't get created. I also did export
> TDSDUMP=/admin/home/oracle/freetds.log and the file
> freetds.log is empty.

It seems FreeTDS it's not trying to connect...

> I also turned on trace on the database link. Here is the trace from
> Oracle.
>

It's not clear to me. Try changing odbcinst.ini as specified.

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page