ODBC in CVS head: SQL_DATETIME?
iODBC Maintainer
iodbc at openlinksw.com
Sat Nov 24 15:59:49 EST 2001
Hi Steve,
> As of revision 1.2 of src/odbc/odbc.c (which includes a changelog entry
> reading 'fixed SQL_DATE things in ODBC'), this file contains a reference
> to a SQL_DATETIME constant. However, I've been unable to locate this
> macro in either the iODBC headers or the unixodbc 2.0.8 headers, and its
> abence naturally causes compilation of the ODBC driver to fail. I have
> found one reference to SQL_DATETIME in the unixodbc 2.0.11 headers, so
> compilation against unixodbc is possible. But how should this be
> handled so that people who only have iODBC installed can still compile
> this driver?
The current version of iODBC does have this constant. You can download the
latest iODBC version from:
http://www.iodbc.org/
This constant was introduced in ODBC V3 API specification and has been
part of the iODBC source for a long time now. I have successfully compiled
the FreeTDS ODBC driver with iODBC.
> I see SQL_DATE used elsewhere in the source, and SQL_DATE and
> SQL_DATETIME both have the same value in unixodbc 2.0.11. Is it
> acceptable to s/SQL_DATETIME/SQL_DATE/ on the source and call it good,
> or is this just a coincidence?
>
As your driver is currently written against the ODBC 2.0 specification, i
recommend you use the SQL_DATE constant. You may also want to compile with
-DODBCVER=0x0200 to make sure you do not use ODBC 3 constants by mistake.
Best regards,
Patrick
--
Patrick van Kleef Email : iodbc at openlinksw.com
Maintainer iODBC Web : http://www.iodbc.org/
OpenLink Software
Universal Data Access & Data Integration Technology Providers
More information about the FreeTDS
mailing list