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





Article #19291: Paradox errors when using SQL servers and cached updates

 Question and Answer Database

FAQ4291D.txt   :Paradox errors when using SQL servers and cached updates
Category   :Database/VCL
Platform    :Win32
Product    :All32Bit,   

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)



3/10/99 10:22:25 AM
 

Last Modified: 01-SEP-99