ODBC Error while inserting.

[sreenathk]

Hi,

We are trying to insert records into Progress DB from .NET application using ODBC Connection.

When we use the Insert into command it works fine within the Progress DB where as through ODBC , it gives the error below:

Err.Number = -2147467259
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Statement not allowed in readonly isolation level (7671)

Please help me on this .
Thanks in advance

Regards
Sreenath

 

[Casper]

Well it is what the error says: Your default isolation level is read uncomitted.
Change it to either read committed, repeatable read or serializable.

Casper.

 

[sreenathk]

Thanks for the reply !!
Changed that to READ Committed and there was also problem with Write Permissions to certain tables.