File corruption when multiple users are reading and writing to the shared DBF flat files with win7 work stations & 2012 server

[fern4all]

Hi,
I have an issue with running a Visual Fox Pro 9 application on windows 7 64bit and the database flat file dbfs reside on server 2012. There are multiple users accessing and reading and writing to those flat file DBFs however i get random corruption in index files and dbfs also intermittent connectivity. I had the same issue with windows 7 and server 2008 but they released hotfixes for SMB2 but server 2012 uses SMB3 and there is no hotfix. Can anyone help with this please?

 

[fern4all]

Found that you can disable SMB3 and SMB2 on both the server and workstations so that they are all on SMB1 and that works also there is a hotfix for SMB2 that can be applied to windows 7 and server 2008. KB article 2618096

also take into consideration the oplocks in windows by default they are on when using SMB2 and SMB3 and no way to disable oplocks in those to protocols so for those of you running a legacy flat file system like VFP9 the best option is to disable SMB3 and SMB2.