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-24 03:35:00
Message-ID: 4CC3A964.3030300@gmx.net (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,
me again.

I've found an issue with 09.00.0102.
Access shows just 101 records from linked tables and stored passthrough 
queries.
After exchanging the 09.00.0102 dlls back to the old 8.4.200 it was all 
again as expected.
So there is some interference of Access with the odbc driver that 
introduce those limits.

I use dsn-less connections by the way.
Every tabledef-object stores the whole connection string.

Maybe tha helps.
Have a nice sunday.   :)



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

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2010-10-24 11:05:50
Subject: Re: psqlODBC 09.00.0101 issue with adodb and adLockOptimistic
Previous:From: AndreasDate: 2010-10-23 17:03:45
Subject: Re: psqlODBC 09.00.0101 issue with adodb and adLockOptimistic

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