Question and Answer Database FAQ: FAQ4560B — "lock timeout" error, TIMEOUT and MAX QUERY TIME parameters. Category: Database (MSSQL) Platform: All-32Bit Product: All-CBuilder, BC++5.x, C++Builder1.0, C++Builder3.x, C++Builder4.x, Delphi2.x, Delphi3.x, Delphi4.x, VdBase7.x, Question: What does the lock timeout error mean and what can I do to change the timeout? Answer: "lock timeout" error, TIMEOUT and MAX QUERY TIME parameters. By default, SQL statements sent to MS SQL and Sybase servers using DB-Lib are sent using the synchronous query submission API. Earlier versions of SQL Links used the asynchronous query submission API. To use the asynchronous query submission API, add 2048 to the current value of DRIVER FLAGS or set it to 2048 if it's blank. To control the time-out for synchronous query submission use the MSSQL and Sybase driver TIMEOUT param. To control the time-out for Asynchronous query submission use the MSSQL and Sybase driver and ALIAS MAX QUERY TIME param. 7/13/99 11:01:08 AM
Last Modified: 01-SEP-99