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

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.