Главная страница | назад





Article #19560: "lock timeout" error, TIMEOUT and MAX QUERY TIME parameters.

 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