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

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