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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | murillomarco | 2010-10-23 00:48:26 | ODBC Problem |
Previous Message | Nirgal | 2010-10-20 15:57:20 | ShowOidColumn |