Re: psqlodbc and SQLFetch after SQLTables gives SQL_NO_DATA_FOUND - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: psqlodbc and SQLFetch after SQLTables gives SQL_NO_DATA_FOUND
Date
Msg-id EKEJJICOHDIEMGPNIFIJGEMJKJAA.Inoue@tpf.co.jp
Whole thread Raw
In response to Re: psqlodbc and SQLFetch after SQLTables gives  (Giuliano Gavazzi <dev+pgsql@humph.com>)
Responses Re: psqlodbc and SQLFetch after SQLTables gives  (Giuliano Gavazzi <dev+pgsql@humph.com>)
List pgsql-odbc
> -----Original Message-----
> From: Giuliano Gavazzi [mailto:dev+pgsql@humph.com]
>
> At 16:02 +0900 2003/02/10, Hiroshi Inoue wrote:
> [...]
> >  > 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.
> >
>
> Hi Hiroshi, sorry but I do not understand. In both cases (the working
> one and the not working one) it is "Table". What seems to change is
> the way the client application retrieves the data.  I have now enable
> debug and repeated the test, may I send you the output?
>
> Where would I change the source anyway? In info.c?

I've just committed a change to cvs(info.c).
Please try it.

regards,
Hiroshi Inoue


pgsql-odbc by date:

Previous
From: Giuliano Gavazzi
Date:
Subject: Re: psqlodbc and SQLFetch after SQLTables gives
Next
From: Giuliano Gavazzi
Date:
Subject: Re: psqlodbc and SQLFetch after SQLTables gives