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

Re: psqlODBC 09.00.0101 issue with adodb and adLockOptimistic

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: psqlODBC 09.00.0101 issue with adodb and adLockOptimistic
Date: 2010-10-23 13:46:29
Message-ID: 4CC2E735.6070101@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi Andreas,

(2010/10/23 4:41), Andreas wrote:
> Hi,
>
> PG 8.4.4 on WinXP
>
> I recently installed psqlODBC 09.00.0101 and now a piece of access-vba
> doesn't work anymore.
> It's just those few lines that open recordsets for writing within my
> application.

Thanks for the report.
Could you please try the drivers on testing for 9.0.0102 at
  http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/
?

regards,
Hiroshi Inoue

> Dim rst As New ADODB.Recordset
>
> With rst
> .CursorLocation = adUseServer
> .CursorType = adOpenDynamic
> .LockType = adLockOptimistic
> .Open strSQL, gpgconn.objConn, , , adCmdText
> end with
>
> It apeares there is an issue with adodb and adLockOptimistic now.
> When I switch to adLockPessimistic it works a bit better.
> Now I can add a new record as well as write some values then close the
> recordset.
> Shortly after I need to change some data in this record so I select the
> previously new created record with it's primary key and now I can write
> to it again.
> As soon I call rst.update an error rises "not enough data in message left"
>
> After downgrading to psqlODBC 08.04.0200 the stuff works again.
>
> Is this a bug or a new feature ?
>
>
> Regards
> Andreas


In response to

Responses

pgsql-odbc by date

Next:From: AndreasDate: 2010-10-23 17:03:45
Subject: Re: psqlODBC 09.00.0101 issue with adodb and adLockOptimistic
Previous:From: Richard BroersmaDate: 2010-10-23 03:03:17
Subject: Re: ODBC Problem

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