sreenathk
New Member
Hi All,
We are connecting to the Progress Database from ASP.NET web application using the Progress ODBC Driver.
The isolation Level is set to READ COMMITTED IN THE Driver Properties.
We are trying to retreive the data based on certain conditions from one of the web pages.
However, if the record is locked in Progress by some other application we are not able to retreive any data and it gives the following error
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Failure getting record lock on a record from table.
what are the different options or solutions where we can read the data from the progress database.
If I change it to "READ UNCOMMITTED" then the select query works because there is no lock defined on the tables, but the insertion or updation fails for this instance.
Thanks,
Sreenath
We are connecting to the Progress Database from ASP.NET web application using the Progress ODBC Driver.
The isolation Level is set to READ COMMITTED IN THE Driver Properties.
We are trying to retreive the data based on certain conditions from one of the web pages.
However, if the record is locked in Progress by some other application we are not able to retreive any data and it gives the following error
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Failure getting record lock on a record from table.
what are the different options or solutions where we can read the data from the progress database.
If I change it to "READ UNCOMMITTED" then the select query works because there is no lock defined on the tables, but the insertion or updation fails for this instance.
Thanks,
Sreenath