Compile error 08.04.0200 with unix-odbc 2.2.14p2-1 on Debian Squeeze AMD64 - Mailing list pgsql-odbc

Hi,

I am trying to compile 08.04.0200 on Debian Squeeze AMD64 with unix-odbc
2.2.14p2-1, hoping to get a working version of SQLForeignKeys hich
return nothing when I use 08.03.0200.

The compilation however fails with:

...
odbcapi.c: At top level:
odbcapi.c:1115: error: expected declaration specifiers or '...' before 'SQLROWSETSIZE'
odbcapi.c:1110: error: conflicting types for 'SQLExtendedFetch'
/usr/include/sqlext.h:1857: note: previous declaration of 'SQLExtendedFetch' was here
odbcapi.c: In function 'SQLExtendedFetch':
odbcapi.c:1133: error: 'pcrow' undeclared (first use in this function)
odbcapi.c:1133: error: (Each undeclared identifier is reported only once
odbcapi.c:1133: error: for each function it appears in.)


The actual declaration in /usr/include/sqlext.h is:

SQLRETURN SQL_API SQLExtendedFetch(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       fFetchType,
    SQLLEN             irow,
    SQLULEN      *pcrow,
    SQLUSMALLINT    *rgfRowStatus);

whereas the driver is expecting:

RETCODE        SQL_API
SQLExtendedFetch(
                 HSTMT hstmt,
                 SQLUSMALLINT fFetchType,
                 SQLLEN irow,
#ifdef WITH_UNIXODBC
                 SQLROWSETSIZE *pcrow,
#else
                 SQLULEN *pcrow,
#endif /* WITH_UNIXODBC */
                 SQLUSMALLINT *rgfRowStatus)

I have checked unix-odbc 2.3 (the latest release I believe) but that
version contains the same definition for SQLExtendedFetch

Is there a solution for this problem? Or can I just remove/change the
#ifdef in this case (including in the function definition of course)
without getting into any problems?

TIA


--
Met vriendelijke groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl