Delphi32.com - Home!
| Home/News | Downloads | Forums | D32 Magazine | Resources | Info and Facts |  
 
 Paradox errors when using SQL servers and cached updates


Why am I getting a paradox lock or table busy error when I'm accessing data on a SQL server in my application (not paradox)?   

    You are probably using Cached Updates in you project. When the BDE caches your data it is stored inside a paradox table. This happens when an application is being run off a server and there is more then one user executing the application. It is easily fixed by setting the paradox NetFile Directory and Private Directory to a temp directory such as " C:\ " (see the documentation for TSession for PrivateDir and NetFileDir properties)

    3/ 0/99 0:22:25 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