Skip site navigation (1) Skip section navigation (2)

Re: [Q] SQLMoreResults causes error in SQLFetchScroll

From: "V S P" <toreason(at)fastmail(dot)fm>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [Q] SQLMoreResults causes error in SQLFetchScroll
Date: 2009-05-17 06:09:41
Message-ID: 1242540581.14055.1315835679@webmail.messagingengine.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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


In response to

Responses

pgsql-odbc by date

Next:From: Christophe GaraultDate: 2009-05-17 09:14:20
Subject: Re: [Q] SQLMoreResults causes error in SQLFetchScroll
Previous:From: V S PDate: 2009-05-17 05:58:53
Subject: [Q] SQLMoreResults causes error in SQLFetchScroll

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group