Re: Oracle 11.2 DG4ODBC and datetime columns

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