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

Bug #2 in latest ODBC driver (07.02.0004)

From: "Glen Parker" <glenebob(at)nwlink(dot)com>
To: "'Hiroshi Inoue'" <Inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Bug #2 in latest ODBC driver (07.02.0004)
Date: 2002-11-25 21:15:34
Message-ID: 009601c294c7$cc01d4b0$0b01a8c0@johnpark.net (view raw or flat)
Thread:
Lists: pgsql-odbc
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.

Glen Parker
glenebob(at)nwlink(dot)com

Attachment: ODBC.log
Description: application/octet-stream (9.5 KB)

In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-11-25 23:49:27
Subject: Re: inserting blob data
Previous:From: Dave PageDate: 2002-11-25 19:41:28
Subject: Re: inserting blob data

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