freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Oracle 11.2 DG4ODBC and datetime columns
- 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
-
[freetds] Oracle 11.2 DG4ODBC and datetime columns,
Mike Blake, 12/15/2009
- Re: [freetds] Oracle 11.2 DG4ODBC and datetime columns, Frediano Ziglio, 12/15/2009
- Re: [freetds] Oracle 11.2 DG4ODBC and datetime columns, Frediano Ziglio, 12/16/2009
Archive powered by MHonArc 2.6.24.