Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo File Corruption on VFP90 ONLY
Message
 
To
30/09/2005 21:34:46
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01055007
Message ID:
01055185
Views:
13
>Hi,
>Have disabled client file caching on the server.
>Also check this link out http://www.superbase.com/services_tech_support_net_fact_sheet.htm
>
>>I am just beginning work for a new client. This client wanted a VFP5 app upgraded to VFP9..they're using Novell (lastest version). After the conversion (very little changes needed to be made), they started getting file and memo corruption errors as well as indexing errors.
>>
>>I took a copy of the data and tried a recopy using SCATTER MEMO MEMVAR to a new fresh data file (using GATHER MEMO MEMVAR) in VFP90. I got the same errors. (Running XP Professsional)
>>
>>So, just to be sure (my version of VFP9 is new), I tried the same thing on VFP8. NO ERRORS! Then I took the new data file (8.0) and ran it through the same program only this time now in VFP9 and NO ERRORS.
>>
>>I don't understand why VFP version 9.0 would give me this problem.
>>
>>Since I converted my regular customers to VFP90 on another app, there have only been occasional memo corruption and numerous indexing errors on Novell networks only.
>>
>>This new customer is also running Novell.
>>
>>Is there some incompatability between Novell and VFP90?
>>
>>Thanks in advance.


After reading the article you linked, I'm considering making the recommended changes, but would like to get a confirmation of what I'm about to do:
(Note: All my computers are Windows XP)

1. On the computer that is acting as the data server (database residing computer)... enter a registry entry of: EnableOplocks value(REG_DWORD): 0
(under the key:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet
\Services\LanmanServer\Parameters)

2. On the client computers (and on the server, if it's also acting as a client of itself, correct?)... enter a registry entry of: UseLockReadUnlock value(REG_DWORD): 0
(under the key:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\
Services\LanmanWorkstation\Parameters)

3. On the client computers (and on the server, if it's also acting as a client of itself, correct?)... enter a registry entry of: UtilizeNtCaching
value(REG_DWORD): 0
(under the key:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\
Services\LanmanWorkstation\Parameters)

4. On the client computers (and on the server, if it's also acting as a client of itself, correct?)... enter a registry entry of: OplocksDisabled
value(REG_DWORD): 1
(under the key:HKEY_LOCAL_MACHINE\System\CurrentControlSet\
Services\MRXSmb\Parameters)

So that's what I've understood the article's instructions to be. Did I get that correct? And, is this really what many of you, who use VFP databases (as opposed to Sql Server) are doing?

Thanks for the help.
Allen
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform