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

Re: Problem with the read only clause for read only cursors

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Tom Goodman <TomGoodman(at)MHProEZ(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Problem with the read only clause for read only cursors
Date: 2009-08-23 09:41:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Tom Goodman wrote:
> Hi,
> I just loaded the 08.04 psqlodbc drivers on a new machine, but ran into 
> a problem where this version is improperly marking ALL fields in 
> recordsets as read-only. I presume that this is related to the recent 
> change that restored the "read only clause for read only cursors".
> The final line in the procedure below fails with an ADO error message: 
> (80040e21) "Multiple-step operation generated errors. Check each status 
> value."
> When comparing psqlodbc 08.04 and 08.03 I see that in 08.03 all of the 
> fields of the recordset have the adFldUpdatable flag set in each field's 
> .Attributes. In 08.04 none of the fields have this flag set.
> Since this code runs without error when connecting to non-postgresql 
> databases, I believe that psqlodbc is not properly setting the 
> adFldUpdatable for the values of CursorLocation, CursorType, and LockType.
> Is this a bug? Can it be addressed?

Could please try the drivers on testing for 8.4.0101 at

Hiroshi Inoue

In response to


pgsql-odbc by date

Next:From: Adnan DURSUNDate: 2009-08-23 23:47:51
Subject: Re: ODBC driver & connection limit
Previous:From: Hiroshi InoueDate: 2009-08-23 09:29:10
Subject: Re: ODBC driver & connection limit

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