[freetds] Oracle 11.2 DG4ODBC and datetime columns
freddy77 at gmail.com
Tue Dec 15 16:44:22 EST 2009
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
> 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
More information about the FreeTDS