Delphi32.com - Home!
| Home/News | Downloads | Forums | D32 Magazine | Resources | Info and Facts |  
 
 lock timeout error, TIMEOUT and MAX QUERY TIME parameters.


What does the lock timeout error mean and what can I do to change the timeout?   

    "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/ 3/99 :0 :08 AM

     



  << Previous Faq     Complete List     Next Faq >>  



 
 Hits/month  2,500,000+ 
 Downloads
 (Since May 2000)
 7,393,709 
 Total Files  6,023 
 Forum msgs  7,670 
 Articles/FAQs  70+/900+ 
Kylix
Tips n Tricks
FAQs
Knowledge Base
Bug Listings
Articles
Books
Newsgroups
Links
Submissions
Testimonials
Advertising
Contact Us
About Us
Search Amazon:
Top Selling Software at Amazon

| Home/News | Downloads | Forums | Resources | Info and Facts | Testimonials |
  Site Search:
 


Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use