Skip to Content.
Sympa Menu

freetds - Re: [freetds] Oracle 11.2 DG4ODBC and datetime columns

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Oracle 11.2 DG4ODBC and datetime columns
  • Date: Wed, 16 Dec 2009 10:58:55 +0100

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




Archive powered by MHonArc 2.6.24.

Top of Page