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: Tue, 15 Dec 2009 22:44:22 +0100

Il giorno mar, 15/12/2009 alle 15.49 -0500, Mike Blake ha scritto:
> 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.
>

Please post unixODBC log working and not working. I still don't
understand where this data type came...

>
>
> Frediano Ziglio was kind enough to send me freetds-0.82.1 (FreeTDS
> 0.82.1.dev.20091209) in hopes it would cure the problem, but is did not
> help.
>
>
>
> Has anybody had any luck using FreeTDS with unixODBC and Oracle 11.2
> DG4ODBC on RedHat 4 (64-bit)?
>
>
>
> Michael Blake
>
> Senior Database Administrator
>
> Raymond James
>
> (248)213-3462
>

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page