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

On 04/25/2014 08:07 AM, Pierre Couderc wrote:
>
> On 04/25/2014 04:24 AM, Adrian Klaver wrote:
>> On 04/24/2014 09:41 AM, Pierre Couderc wrote:
>>> Thank you, but it changes nothing.
>>
>> Please do not top post.
> ok ;)
>>
>>>
>>>
>>> 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?
> Sorry, I am not a specialist of DB, and I had no idea of dynaset or
> snapshot...
> I have checked and my conclusion is that I have always used, with many
> MFC program under various Windows, snapshot recordsets "writeable".
> The doc which apply is
> http://msdn.microsoft.com/en-us/library/1hkkwdf0.aspx
>
>>
>> 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.
>>
> Yes, it is the same application.
> Mmm, it is difficult to incriminate wine : the circuit is very simple
> : wine sees nothing, and transmits to ODBC layer : unixodbc, whch may
> be the problem.
> Moreover ay my konwledge, recordset is not a ODBC concept, it is
> specific to MS.
> I shall try dynaset now.
> Thank you for the idea.
> But I am surprised to be alone to have this problem.
>
I have tried "dynaset", and it works ...
Thank you for your help !