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

Re: psqlODBC 09.00.0101 issue with adodb and adLockOptimistic

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

I tried the unicode-binary from your site and replaced the corresponding 
files within my current 8.4.0200 folder with the new 9.0.0102 dlls. The 
broken ADODB code works now as far as I see in a hurry.    :)

Will you build a new msi-distribution?


Thanks for the fast response.
:)


Am 23.10.2010 15:46, schrieb Hiroshi Inoue:
> 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

pgsql-odbc by date

Next:From: AndreasDate: 2010-10-24 03:35:00
Subject: Re: psqlODBC 09.00.0101 issue with adodb and adLockOptimistic
Previous:From: Hiroshi InoueDate: 2010-10-23 13:46:29
Subject: Re: psqlODBC 09.00.0101 issue with adodb and adLockOptimistic

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