Postgres Pro
Downloads
Home   >   mailing lists

SQLColumns, SQLTables where fails depending on row cache size - Mailing list pgsql-odbc

From Wayne Armstrong
Subject SQLColumns, SQLTables where fails depending on row cache size
Date
Msg-id 200304100321.h3A3LTdv021841@mail.bacchus.com.au
Whole thread Raw
In response to Re: problems with sqlsetpos -->having odbc intercept alter command  ("Dave Page" <dpage@vale-housing.co.uk>)
Responses Re: SQLColumns, SQLTables where fails depending on row cache size
List pgsql-odbc
Tree view 
Hi,
 an SQLColumns or SQLTables request to the odbc driver will fail if the number
of columns(or tables) returned is a multiple of the row cache size and
use_declare_fetch is true.
The error returned is :-='Unrecognized return value from
copy_and_convert_field.'
This is returned because the driver has read 1 row past the end of the result,
and is trying to convert nulls.
I am using the 7.02.00.05 drivers.
I have read the source some, but can't actually see what needs changing (I am
not really a c programmer :).  I have debug logs for this if anyone's
interested.

Regards,
Wayne

pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: problems with sqlsetpos -->having odbc intercept alter command
Next
From: "Daniel F Garcia"
Date:
Subject: Connection to posgresql database works under windows scripting host but not IIS/ASP