Re: psqlodbc and SQLFetch after SQLTables gives

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?

Thanks for helping me solve this.

Giuliano

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org