Re: 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: [email protected] [mailto:[email protected]] 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 <[email protected]>:
>> 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
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds