Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement