OOT Windows 2008 and ISAM

[SylRob]

Good Morning all Fivewin user,

This is a little out of topic of fivewin but it may be of interest for a lot of people here. Since Windows NT to avoid File corruption on ISAM files you must disable the Opportunistic Locking to obtain a stable software(no file corruption)

Now the problem:

Windows 2008 server (Windows vista Sp1 Windows 7) are now using a new version of the SMB called SMB2 in SMB2 you CAN'T disable OPLOCK, you mut first disable SMB2 and after being back on SMB1 you can disable oplocks !

I just want to know if there is some people here who have DBF files on a Windows 2008 server (Windows 7 or Windows vista sp1) and using it in a network environnment ?. If so did you experiment any file corruption ?. Any though or experience to share ?.All my reading regarding SMB2 make me understand that file corruption caused by OPLOCK are still present in the SMB2 system !

I have no need to konw how to disable SMB2 and OPLOCK I already know how to do it, I just want to share information with people who are using that kind of files on those OS !

If you are using RDBMS you are not affected by this bad behaviour !

Berst Regards,

Sylvain

[Otto]

Hello Sylvian,

Very interesting. Thank you very much for sharing.
I had a database problem the other night I can’t reproduce. The dbf-files are located on a 2008 SERVER.
Would you be so kind to share how to disable the Opportunistic Locking to obtain a stable software.



Thanks in advance
Otto

[Otto]

I found this link:
http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html#Disabling%20Opportunistic%20Locking%20on%20Windows%20Servers
Best regards,
Otto

[SylRob]

Hi Otto !

Just follow the instruction on that link and you'll be ok !. First you disable SMB2 and after taht disable OPLOCK on the server with the additionnal reg key in lanmanserver

Best Regards,

Sylvain

[HunterEC]

Sylvain:

Very good post ! Anyone using dbf files, like me , will benefit from your post. Thank you.

Gustavo