Re: Problem with the read only clause for read only cursors - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Problem with the read only clause for read only cursors
Date
Msg-id 4A910EB0.4060904@tpf.co.jp
Whole thread Raw
In response to Problem with the read only clause for read only cursors  (Tom Goodman <TomGoodman@MHProEZ.com>)
Responses Re: Problem with the read only clause for read only cursors  (Tom Goodman <TomGoodman@MHProEZ.com>)
List 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
  http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: ODBC driver & connection limit
Next
From: "Adnan DURSUN"
Date:
Subject: Re: ODBC driver & connection limit