Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP remote view error - object in use
Message
From
31/03/1999 10:47:04
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
VFP remote view error - object in use
Miscellaneous
Thread ID:
00203890
Message ID:
00203890
Views:
47
When SQL Server remote views in our VFP application are accessed at the exact same time by two users, one user gets an 'object in use' error. Accessing by two users a couple of seconds apart is fine. The remote views are merely views at this point, and no updating is happening. The locks on the SQL Server should be shared, so I would not think this is the problem. The VFP views share connections and fetch all records (which is usually 1 or a small number) at once. On the VFP database we have synchronous execution and batch processing. Where is the problem?
Next
Reply
Map
View

Click here to load this message in the networking platform