Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS 0.82 returning ODBC v2 values instead of ODBCv3 values

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Mike Blake" <Michael.Blake AT RaymondJames.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS 0.82 returning ODBC v2 values instead of ODBCv3 values
  • Date: Thu, 17 Dec 2009 11:23:09 -0500

The Heterogeneous Services (ODBC connector) in Oracle got re-written in
version 11 can only do ODBC v3 and assumes that the ODBC driver is v3.
The previous version would figure out if the driver was v2 or v3 and
could do both.

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Michal Seliga
Sent: Thursday, December 17, 2009 10:02 AM
To: freetds AT lists.ibiblio.org
Subject: Re: [freetds] FreeTDS 0.82 returning ODBC v2 values instead of
ODBCv3 values

hi,

when i am connecting to odbc from qt in linux i had to add connection
parameter
SQL_ATTR_ODBC_VERSION=SQL_OV_ODBC3, otherwise it also didn't worked
properly

i don't know oracle, but try to find if you can set connection
parameters
somewhere, it might help in your case too


On 17. 12. 2009 15:49, Mike Blake wrote:
> Just doing isql or tsql I can query the datetime columns. The problem
is when I try to query from Oracle. I have a DB link in Oracle pointing
to the ODBC connection (FreeTDS). When I try to do the query including
the datetime columns in Oracle, the log form Oracle shows the datetime
columns being ignored. The datatype code listed for the columns being
ignored is 11 (ODBC v2) instead of 93 which is the ODBC v3 code for
datetime or timestamp. I need FreeTDS to always use the ODBC v3 values.
Is there any way to force it to default to ODBC v3? Or is there
something in unixODBC that can be set to force ODBC v3? Anybody who
upgrades to Oracle 11 will lose the ability to use FreeTDS if it can't
do ODBC v3 by default.
>
> I don't get anything very useful in the FreeTDS or unixODBC logs when
querying from Oracle since the query fails. I can attach the Oracle log
which shows the list of columns being looked at and the datetime columns
being ignored due to being datatype 11.
>
>
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Frediano Ziglio
> Sent: Wednesday, December 16, 2009 4:53 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] FreeTDS 0.82 returning ODBC v2 values instead
of ODBCv3 values
>
> Yes, but to help fixing the problem you should also report which
> function returns an invalid type. There are many function which can
> return this type of information
> - SQLDescribeCol
> - SQLColumns
> - SQLSpecialColumns
> - SQLGetDescAttr
> - SQLGetRecField
> Looking at unixODBC log would help a lot. You can enable it adding
>
> [ODBC]
> Trace = Yes
> TraceFile = /path/to/log/file
>
> to odbcinst.ini
>
> freddy77
>
> 2009/12/16 Mike Blake <Michael.Blake AT raymondjames.com>:
>> I'm still trying to get FreeTDS to work with Oracle 11.2 DG4ODBC. As
>> near as I can tell, FreeTDS is returning the data type codes for
ODBCv2
>> instead of ODBCv3. Specifically, datetime columns return as a type
11
>> instead of a type 93. I checked the log from the make of FreeTDS and
>> checked odbc_config -longodbcversion which returns 3.52. What would
>> make FreeTDS return ODBCv2 formatted data?
>>
>>
>>
>> Michael Blake
>>
>> Senior Database Administrator
>>
>> Raymond James
>>
>> (248)213-3462
>>
>>
>>
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS AT lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page