Skip to Content.
Sympa Menu

freetds - Re: [freetds] Datetime field issue

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Mike Blake" <Michael.Blake AT RaymondJames.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Datetime field issue
  • Date: Thu, 10 Dec 2009 15:24:53 -0500

Doing some digging. It appears that FreeTDS is reporting the DATETIME
columns as type 111.

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Mike Blake
Sent: Thursday, December 10, 2009 11:41 AM
To: freetds AT lists.ibiblio.org
Subject: [freetds] Datetime field issue

Working on a migration from Oracle 10.2 on Windows to Oracle 11.2 on
Linux. There are processes that use ODBC to get data from SQL Server.
I have created an 11.2 database on a test Linux box and configured
unixODBC, FreeTDS, and the Oracle Gateway for ODBC. When I try to query
a table with a DATETIME column it comes back with an ORA-00904 that the
column does not exist. Looking at the gateway log, the DATETIME columns
are showing up as a dtype:11 which is not mapping to any data type. The
other data types are mapping OK. Oracle support says that the ODBC
driver (FreeTDS) is using the ODBC v2 standard and that the gateway
requires ODBC v3 which would tag the DATETIME column as dtype:93. Is
Oracle support confused? Is FreeTDS installed wrong on my Linux server?



Mike Blake



_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page