Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply


Post by Andrew » Fri 13 Jan 2006 15:33

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.

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Mon 16 Jan 2006 13:33

No, this is MS SQL limitation. You can read more about it in SDAC help.

Post Reply