Re: Oracle 11.2 DG4ODBC and datetime columns
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
2009/12/15 Mike Blake <[email protected]>: > 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 mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds