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"  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@fastmail.fm
> 
> -- 
> http://www.fastmail.fm - A no graphics, no pop-ups email service
> 
> 
> -- 
> Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
-- 
  V S P
  toreason@fastmail.fm

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