Re: "Recordset is read-only" with wine and unixodbc

On 04/24/2014 09:41 AM, Pierre Couderc wrote:
> Thank you, but it changes nothing.

Please do not top post.

>
>
> On 04/24/2014 03:28 PM, Adrian Klaver wrote:
>> On 04/24/2014 02:12 AM, Pierre Couderc wrote:
>>> I am trying to excute under wine an application (MFC VC6++) which works
>>> fine under Windows (XP,7...), using ODBC and window pgsqlodbc. I try to
>>> use it under unix pgsqlodbc and unixodbx (under debian jessie amd64).
>>> I hade some difficults to connect under i386 architecture but now it
>>> works fine, except when I try to modify a record of the table with a
>>> Crecordset.
>>>
>>> I get the a "Recordset is read only" message on an application that
>>> works fine under windows.

A little searching found this:

http://support.microsoft.com/kb/109218/EN-US

So are you using a dynaset which is updateble or a snapshot which is
read only?

Assuming you are using the exact same application in both cases and it
is working in the Windows case with psqlodbc, would seem to rule out
psqlodbc as the culprit. My suspicion would be an issue in Wine, it is
after all an emulation layer.

>>> I use for odbc.ini :
>>>
>>> [Mydatabase]
>>> Description=PostgreSQL
>>> Driver=PostgreSQL ANSI
>>> Trace=Yes
>>> TraceFile=/tmp/psqlodbc.log
>>> Database=mydatabase
>>> Servername=10.8.0.1
>>> UserName=uuuu
>>> Password=pppp
>>> Port=5432
>>> ReadOnly=No
>>> RowVersioning=No
>>> ShowSystemTables=No
>>> ShowOidColumn=No
>>> FakeOidIndex=No
>>> ConnSettings=
>>
>> Try setting:
>>
>> RowVersioning=Yes
>>
>>>
>>> Thank you for your help.
>>> I can modify the source of the application if it is needed. I have tried
>>> to use dynamic cursor but I got the result that it is not supported by
>>> the driver.
>>>
>>> PC
>>>
>>>
>>
>>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com