desactivar

[edgar Fernando]

Desactivar el oportunistic locking (Oplocks).

en que parte se desactivar ya lo busque pero no lo encontre,, yo tenia el mismo problema usando los tps en forma directa ahora tube que hacer por queue para no tener problema

[fvalencia]

Edgar:

Te envío esta página donde explica como desactivarlo usando el editor de Registro (Regedit.exe o Regedt32.exe).


http://www.dataaccess.com/whitepapers/o ... ching.html


All computers running Windows operating systems that host or access embedded database tables accessed by other Windows PCs need to have oplocks disabled in order to minimize the chances of database corruption.

Oplocks can be disabled on either (or both) of these:
•the client side (a Windows PC that accesses an embedded database table hosted on another PC)
•the server side (a Windows PC that hosts an embedded database table accessed from another PC)

The Windows operating system list that we currently support for our products includes Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 and Windows Server 2008.


Disabling Oplocks on Windows Client PCs

To disable oplocks on a Windows client PC (a Windows PC that accesses an embedded database table hosted on another PC), change or add the following Registry values:

•HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MRXSmb\Parameters OplocksDisabled = 1



Disabling Oplocks on Windows Servers

To disable oplocks on a Windows server (a Windows PC that hosts an embedded database table accessed from another PC), change or add the following Registry values:

• HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters EnableOplocks = 0

[carlin]

Hola:
aca envio una utilidad para evitar el bloqueo oportunista de windows
espero que les sea de utilidad.
Author: Davor Maric, davor.maric@inet.hr


carlos