Re: [Q] SQLMoreResults causes error in SQLFetchScroll

Sorry forgot to mention the actual error I am getting:

http://pastebin.com/d49e830c0

SQLSTATE = HY010
NATIVE ERROR = 0
MSG = [Microsoft][ODBC Driver Manager] Function sequence error

this is winXP 32 against postgres 8.4 latest candidate.
using pgODBC 8.03.04 ANSI

On Sun, 17 May 2009 01:58 -0400, "V S P" <toreason(at)fastmail(dot)fm> wrote:
> Hello,
>
> I am using the method recommended to obtain a row count
> from an operation.
>
> That method relies on call SQLMoreResults
>
>
> It appears, however, that that mechanism causes
> an error down the stream (that I do not undersand)
> in SQLFetchScroll
>
>
> I have an example source file that demonstrates the problem
>
> http://pastebin.com/m2b11b28d
>
> It is an 'extract' of the actual ODBC calls that are going on
> in from within OTL C++ library.
>
> Essentailly non of SQL statements are working (because OTL
> tries to obtain the row count and then deploys the sequence of
> ODBC statements described in the example)
>
>
> Wanted to ask if somebody has ran into this or if it is a bug,
> how to log it (if it is allowed to be logged) and if there is a
> workaround.
>
> Thank you in advance for any help,
> Vlad
> --
> V S P
> toreason(at)fastmail(dot)fm
>
> --
> http://www.fastmail.fm - A no graphics, no pop-ups email service
>
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
--
V S P
toreason(at)fastmail(dot)fm

--
http://www.fastmail.fm - The way an email service should be