> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Dave Page
> Sent: 07 November 2005 10:55
> To: tc@geosys.com; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Bug with version 08.01.0100 ?
>
>
> I've tried your connection string (modified for my local server of
> course) and rs.Open (but with pg_class), and it does seem that only
> adOpenForwardOnly and adOpenDynamic work as expected :-(. I'll open a
> tracker about this.
Sorry - that's not quite right - it seems that adLockOptimistic or
adLockBatchOptimistic are the culprits. They will only work with
adOpenForwardOnly. adLockPessimistic or adLockReadOnly seem to work OK
with any cursor type.
Regards, Dave