Insert and isolation level

sreenathk

New Member
Hi All,

I am inserting into a Progress Table using ODBCCommandText.Its a simple insert statement.

My Isolation level is set to "Read Committed". I am getting "02/11/2010 3:02:39 PM Test.aspx.cs : ExecuteInsert() ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Failure getting record lock on a record from table PUB.XYZ."

We tried inserting with 2 users submitting at the same time (Simultaneous Users) .

Does Progress Lock the table/record at the time of Inserting? What can be done to fix this error?

Thanks
Sree
 
Top