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

psqlODBC 09.00.0101 issue with adodb and adLockOptimistic

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: psqlODBC 09.00.0101 issue with adodb and adLockOptimistic
Date: 2010-10-22 19:41:47
Message-ID: 4CC1E8FB.6040506@gmx.net (view raw or flat)
Thread:
Lists: pgsql-odbc
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.

     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

Responses

pgsql-odbc by date

Next:From: murillomarcoDate: 2010-10-23 00:48:26
Subject: ODBC Problem
Previous:From: NirgalDate: 2010-10-20 15:57:20
Subject: ShowOidColumn

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