[freetds] FreeTDS 0.82 returning ODBC v2 values instead ofODBCv3 values

Frediano Ziglio freddy77 at gmail.com
Thu Jan 7 10:59:45 EST 2010

2009/12/22 Frediano Ziglio <freddy77 at gmail.com>:
> For anybody interesting I attach some stripped down compressed log he
> sent to me. As you can say Oracle issue a SQLColumns getting columns
> informations. As detected some days ago our drivers returned wrong
> data_type using SQLColumns cause it does not append version information
> calling sp_columns. I already fixed both 0.82 branch and CVS HEAD but I
> think to backport entire patch (with fix for Sybase db) and test.
> As you can see Oracle correctly set odbc version to 3.
> Regards
>  Frediano Ziglio
> Il giorno mar, 22/12/2009 alle 07.50 -0500, Mike Blake ha scritto:
>> I tried to email some logs but the email was rejected.  Is there a size limit or other restriction?
>> -----Original Message-----
>> From: freetds-bounces at lists.ibiblio.org [mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Frediano Ziglio
>> Sent: Monday, December 21, 2009 11:11 AM
>> To: FreeTDS Development Group
>> Subject: Re: [freetds] FreeTDS 0.82 returning ODBC v2 values instead ofODBCv3 values
>> 2009/12/21 Mike Blake <Michael.Blake at raymondjames.com>:
>> > I tested with the Easysoft ODBC driver and saw that Sql Server datetime
>> > columns get translated to SQL_TYPE_TIMESTAMP data type 93.  Is there a
>> > way to make FreeTDS translate the same way?
>> >
>> > Oracle 11 will not be able to use FreeTDS until date columns can be
>> > queried.
>> >
>> Could you please send us a working or not working (better both) odbc trace?

Mike reply to me and confirmed that latest updates and backports fixed
the problem.

Happy New Year to everybody!


More information about the FreeTDS mailing list