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

On 04/24/2014 11:07 PM, Pierre Couderc wrote:
>
> On 04/25/2014 04:24 AM, Adrian Klaver wrote:
>> On 04/24/2014 09:41 AM, Pierre Couderc wrote:

>>
>> 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

In the page is this link that explains the recordsets:

http://msdn.microsoft.com/en-us/library/5sbfs6f1.aspx

which in turn has the link below with information on testing whether a
recordset is updateable:

http://msdn.microsoft.com/en-us/library/z5139kz6.aspx

>>
> 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.

And you are using MFC which is a MS product, which is why I figured that
the problem lay there, not in psqlodbc.

> I shall try dynaset now.
> Thank you for the idea.
> But I am surprised to be alone to have this problem.

Happily, it did.

>
>
>

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