Re: Bug #2 in latest ODBC driver (07.02.0004) - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Bug #2 in latest ODBC driver (07.02.0004)
Date
Msg-id 3DE33B35.16B290D3@tpf.co.jp
Whole thread Raw
In response to Bug #2 in latest ODBC driver (07.02.0004)  ("Glen Parker" <glenebob@nwlink.com>)
List pgsql-odbc
Glen Parker wrote:
>
> This bug *seems* to be the result of incomplete statement recycling (old
> values left behind from previous executions).  This is mostly a guess.
> Log is attached.
>
> If a non-select statement is executed (INSERT in this case) followed by
> a select, trying to fetch the rows from the select will fail with an
> invalid scroll type error.
>
> Compiling the driver without the DRIVER_CURSOR_IMPLEMENT flag eliminates
> the errors.  Turning updatable cursors on/off in the driver config has
> no apparent affect.

I committed a change to cvs though I tested none about it.
Could you try it ? Please nmake clean before rebuilding it.

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/

pgsql-odbc by date:

Previous
From: "Han"
Date:
Subject: SQL_C_CHAR & SQL_VARBINARY
Next
From: Hiroshi Inoue
Date:
Subject: Re: Very large queries with ODBC