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 09:49:07 -0500

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



Archive powered by MHonArc 2.6.24.

Top of Page