Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Write Caching, Opportunist Locking.. DISABLE HELP!!!
We have a large app on a winNT4 server that is read/write from many pc's of these OS's... 95/98/NT/2K/XP.
We have a lot of table locking issues. errors 1, 13, 1705, 111, 41, 3, 1104, etc.
Based on reading here and on the net, we have found that disabling OPLOCK setting in the registry of the winNT4 server has greatly reduced these errors!!! But they have not disappeared.
Based on more reading, it seems like the next step is to disable WRITE CACHING/OPLOCK settings on the CLIENTS. The fun thing mentioned is we have 95/98/NT/2K/XP clients.
DOES anyone know if disabling these settings on the client helps prevent these table locking issues?
NEXT.. HOW do I do this!! Exact registry lines would be perfect. I just can't find any 'one answer solution' on this stuff.
THANK YOU!
Suivant
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