SQL Server LockMode
Posted: Mon 15 Mar 2010 20:38
when I try to open a table in SQL Server that is being edited by another User, the following error occurs: "Lock request timeout period exceeded".
UniTable Configuration:
LockMode = lmPessimistic
RefreshOptions = [roBeforeEdit]
In PostgreSQL, it's not happen.
I can open the table, but I can't edit the same record. It's right, but in SQL Server, an error occurs when I try to open the table.
Whats happening?
UniTable Configuration:
LockMode = lmPessimistic
RefreshOptions = [roBeforeEdit]
In PostgreSQL, it's not happen.
I can open the table, but I can't edit the same record. It's right, but in SQL Server, an error occurs when I try to open the table.
Whats happening?