Re: psqlodbc and SQLFetch after SQLTables gives SQL_NO_DATA_FOUND

Giuliano Gavazzi wrote:
>
> Dear list,
>
> I posted some time ago about a problem with retrieving table in
> MSQuery on MacOSX using  postgres 3.7.1 and psqlodbc-7.2.5  with
> iODBC (iODBC-SDK-3.5.3).
>
> At the time I found, by snooping the TCP stream, that the SQLTables
> function, that must be used by MSQuery to retrieve the table list,
> did indeed return the tables, but for some reason MSQuery was unable
> to get this data.
>
> Now I have enabled tracing and found where the failure is. Apparently
> MSQ uses SQLFetch just after SQLTables to get the table list, this
> SQLFetch fails by returning SQL_NO_DATA_FOUND. Here I have two
> snippets from the traces of MSQ retrieving tables first using
> OpenLink Postgres Lite driver (that succeeds) and then using psqlodbc
> (that fails):
>
> 1) openlink driver:
>
> iODBC[Microsoft Query]  ThID:A0000DEC  ENTER SQLTables
>
> iODBC[Microsoft Query]  ThID:A0000DEC  EXIT  SQLTables  with return
> code 0 (SQL_SUCCESS)
>
> Microsoft Query  ThID:A0000DEC  EXIT  SQLTables  with return code 0
> (SQL_SUCCESS)
>            HSTMT         0x01619a00
>            CHAR*         00000000 "..."
>            SMALLINT      -3536
>            CHAR*         00000000 "..."
>            SMALLINT      -18992
>            CHAR*         00000000 "..."
>            SMALLINT      15056
>            CHAR*         0x001c3fd8 "Table"

Hmm, if it is "TABLE", it seems to work.
OK I would change the driver to be insenitive about
it.

regards,
Hiroshi Inoue
    http://www.geocities.jp/inocchichichi/psqlodbc/