Re: Compile error 08.04.0200 with unix-odbc 2.2.14p2-1 on Debian Squeeze AMD64

HI,

(2010/11/01 15:46), Joost Kraaijeveld wrote:
> 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?

Could you plaese try 9.00.0200?

regards,
Hiroshi Inoue