Mega Code Archive

 

Categories / Delphi / ADO Database

 

Paradox errors when using sql servers and cached updates

Question: 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)? Answer: 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)