[freetds] Oracle 11.2 DG4ODBC and datetime columns

Frediano Ziglio freddy77 at gmail.com
Wed Dec 16 04:58:55 EST 2009


2009/12/15 Mike Blake <Michael.Blake at raymondjames.com>:
> I've been able to query common data types, including datetime using the
> Heterogeneous Services in Oracle 10.2 (HS4ODBC) and FreeTDS.  Now
> looking at switching to Oracle 11.2 and datetime columns don't work.
> Oracle re-wrote their Heterogeneous Services in 11.2 (DG4ODBC) and it
> does not like datetime columns through FreeTDS anymore.  In the DG4ODBC
> log, there is a message saying that datatype 11 ?????? is not supported.
> If I use isql (via FreeTDS) to query datetime columns the unixODBC log
> says that datetime columns are datatype 111.  The same query using
> unixODBC and EasySoft says the datetime columns are Timestamp, datatype
> 93 and the Heterogeneous Services likes those.
>

Did you specify -3 option to isql? By default drivers use ODBC 2, not ODBC 3.

Type 111 is the TDS type for DATETIME (SYBDATETIMN). Did you use "help
table" on isql ??

freddy77



More information about the FreeTDS mailing list