Skip to Content.
Sympa Menu

freetds - RE: [freetds] 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] Bug in SQLNumResultCol function
  • Date: Thu, 10 Jun 2004 08:45:34 +0200

>
> Hi,
>
> I am trying to use unixODBC and freetds for Oracle Generic
> Connectivity so
> that I
> can create database links to MS SQL Server in Oracle 10g database.
>
> I can run the unixodbc command isql -v <MS DB Name> <user
> name> <password>
> to connect to the MS SQL Server and run the sql query
> succssfully select *
> from scProblem.
> But the same query select * from "scProblem"@msticket doesn't work by
> using the database link msticket of the MS SQL server.
> Oracle support verified that the configuration of the db link
> is fine. I
> can run the following queries successfully:
> 1) select * from dual@msticket;
> 2) select * from all_catalog@msticket;
>
> Oracle support told me the reason that query select * from
> "scProblem"@msticket doesn't work is that known bugs in freetds.
> The bugs are:
> 1) "describe table scProblem" doesn't work in freetd
>
>
> 2) In SQLNumResultCol function, freetds may return something
> similar to:
>
>
> [ODBC][22261][SQLNumResultCols.c][233]
> Exit:[SQL_SUCCESS]
> Count = ffbed858 -> 0
>
> instead of returning the real number of rows.
>
> when I run the query select * from "scProblem"@msticket.
>
> Could someone verify that? If so, are there any patches for them?
>
> Thank a lot in advanced.
>
> Jun
>

Hi Jun!

First you must use 0.63 version. We can't help with tests cause we don't
own Oracle + binder. Please enable unixODBC log and freetds log and post
them. If data contain sensitive data please send them privately to me
(or James).

I never see "describe table scProblem" syntax before... Perhaps it's an
Oracle syntax??

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page