Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database object in use.
Message
De
26/10/2001 18:03:34
 
 
À
24/10/2001 18:48:45
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00572951
Message ID:
00574048
Vues:
18
Hi Frank.

>I have this problem that is driving me crazy. I have an app that dustrubuted at 8 different locations.(8 different servers). Both novell and NT. 1 nt server and 1 novell server keeps comming up with "database in use by another"

Does this happen when a form is being opened? Are you using views? If the answer to both of these is "yes" (as I suspect is the case), you're running into DBC contention. What's happening is that when the form opens the view, VFP temporarily locks the view's records in the DBC. If another user opens the form at exactly the same time, VFP can't lock the view's records because they're already locked, and gives this error.

There are several solutions to this, but the cleanest is to have a local rather than shared copy of the DBC. You move all your views to their own DBC, then at app startup, copy the views DBC, DCX, and DCT files to the local drive and open that copy. That way, there's no contention for DBC locking.

Doug
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform