Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tables with Memos getting corrupted
Message
From
20/01/2015 15:10:51
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
 
 
To
20/01/2015 12:52:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Novell 6.x
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01613967
Message ID:
01613980
Views:
92
>Hi Kevin:
>
>If your tables are on a network, then your problem is the same as thousands of people, so you probably have found a ton of messages on the web and on forums about table corruption, specially memo fields.
>
>Reason is this:
>http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html
>
>The best solution is to upsize the DBFs to a SQL Database (SQLServer, MariaDB, MySQL, etc), because they have not this problem.

Interesting article, but in case SMB2.x or 3.x is being used, it recommends completely disabling those protocols. Server admins will be very reluctant to do so, given that some features depend on those newer protocols: http://blogs.technet.com/b/josebda/archive/2013/10/02/windows-server-2012-r2-which-version-of-the-smb-protocol-smb-1-0-smb-2-0-smb-2-1-smb-3-0-or-smb-3-02-you-are-using.aspx (section 5)

Alaska Software claims to know the details of the problem and offers a patch that changes some SMB2/3 parameters without disabling the protocols entirely: http://www.alaska-software.com/fixes/smb2/overview.shtm

In a perfect world yes, we would all be running against an RDBMS backend. However, if VFP tables are still being used I believe the Alaska Software patch is a good place to start.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform