Deadlocks
Posted: Fri 13 Jan 2006 15:33
Hi,
I have a problem with using ctDefaultResultSet cursor type in TMSQuery. FetchAll - false. Usually I have about 100 opened connections on the SQL Server. And time from time tables' deadlocks appear on the Server. Other users can't work with the program because of an error "Timeout expired". Is there a solution for this problem? Thanks in advance.
I have a problem with using ctDefaultResultSet cursor type in TMSQuery. FetchAll - false. Usually I have about 100 opened connections on the SQL Server. And time from time tables' deadlocks appear on the Server. Other users can't work with the program because of an error "Timeout expired". Is there a solution for this problem? Thanks in advance.