Re: gda-odbc-server problem

[Rodrigo Moya <rodrigo linuxave net>]

> 
> 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?
> 
> 
The thing is that Nick added support for the unixODBC libs, and since
then,
I've been myself using the ODBC provider with unixODBC, and nobody has
ever sent a bug report about it, so I guess there are really
differences between those two.

If you could find those differences and add #ifdefs whenever
appropriate,
it would be great.

BTW, do you know of unixODBC debian packages? I volunteered myself to
Nick
to do the debian packages, but as I haven't had time to learn how to do
them,
I haven't done it. Maybe you could help Nick in adding them?