Page 1 of 1

OOT Windows 2008 and ISAM

Posted: Thu Sep 10, 2009 11:42 am
by 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

Re: OOT Windows 2008 and ISAM

Posted: Thu Sep 10, 2009 3:09 pm
by 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

Re: OOT Windows 2008 and ISAM

Posted: Thu Sep 10, 2009 3:36 pm
by Otto
I found this link:
http://www.dataaccess.com/whitepapers/o ... %20Servers
Best regards,
Otto

Re: OOT Windows 2008 and ISAM

Posted: Sat Sep 12, 2009 3:02 pm
by 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

Re: OOT Windows 2008 and ISAM

Posted: Mon Sep 21, 2009 10:51 pm
by HunterEC
Sylvain:

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

Gustavo