Re: gda-odbc-server problem

[Nick Gorham <nick lurcher org>]

Akira TAGOH wrote:

> Hi Nick,
>
> I installed libiodbc2-2.50.3-1 and libiodbc2-dev-2.50.3-1 on
> my machine (Debian woody).
>
> However, failed in the compilation with the following error:
> gda-odbc-connection.c: In function `gda_odbc_connection_begin_transaction':
> gda-odbc-connection.c:183: `SQL_ATTR_AUTOCOMMIT' undeclared (first use in this function)
> gda-odbc-connection.c:183: (Each undeclared identifier is reported only once
> gda-odbc-connection.c:183: for each function it appears in.)
> gda-odbc-connection.c: In function `gda_odbc_connection_start_logging':
> gda-odbc-connection.c:296: `SQL_ATTR_TRACE' undeclared (first use in this function)
> gda-odbc-connection.c: In function `gda_odbc_connection_stop_logging':
> gda-odbc-connection.c:324: `SQL_ATTR_TRACE' undeclared (first use in this function)
> gda-odbc-connection.c: In function `gda_odbc_connection_get_gda_type':
> gda-odbc-connection.c:451: `SQL_TYPE_DATE' undeclared (first use in this function)
> gda-odbc-connection.c:455: `SQL_TYPE_TIME' undeclared (first use in this function)
> gda-odbc-connection.c:459: `SQL_TYPE_TIMESTAMP' undeclared (first use in this function)
> gda-odbc-connection.c: In function `gda_odbc_connection_get_c_type':
> gda-odbc-connection.c:517: `SQL_C_TYPE_DATE' undeclared (first use in this function)
> gda-odbc-connection.c:520: `SQL_C_TYPE_TIME' undeclared (first use in this function)
> gda-odbc-connection.c:523: `SQL_C_TYPE_TIMESTAMP' undeclared (first use in this function)
>
> These are not really defined in sql.h and sqlext.h.
> Is this a difference of ODBC and iODBC

Well I built the driver with unixODBC, using ODBC 3 constants, it should work with iODBC, it
may be worth trying iODBC 3.5 but SQL_TYPE_DATE should be defined at the least in sql.h.

--
Nick Gorham
"I wish there was a knob on the TV to turn up the intelligence,
There's a knob called brightness, but it doesn't work."
- Eugene P. Gallagher