Extensive testing by Paul McNett seems to indicate that:
- VFP running under Wine locks tables and records properly,
- Multiple instances of VFP or other applications under the same instance of Wine respect each other’s locks,
- VFP clients on Windows can properly lock records and files on a Samba share or a native Windows share,
- VFP clients under Wine do respect locking when sharing files via NFS,
- VFP clients running under Wine will not see locks on SMB (Samba or Windows) shares because the outgoing SMBClient does not understand locks.
So, all is not lost, nor is it won, just yet. Wine is doing it’s thing properly. Samba needs to learn the Windows Way of locking. So, if you are looking at transitioning existing Windows systems to Linux:
- Consider moving to client-server, which eliminates all the locking issues, and gives you increased scalability, reliability and other – ilities, OR:
- Put the DBF files on a Samba share, and access them via SMB (the native networking) from Windows clients, and via NFS from the Linux clients.
With the rich assortment of data servers available for Linux, I’m inclined to strategy #1 for new systems, but strategy #2 for existing DBF-based systems, to simplify the transition. Once the existing systems were working without a hitch under plan #2, I’d propose plan #1 for the next major upgrade of the system.