Re: Corruption with VFP 8

Hi Jay:

Directing the temp files locally simply reduces the burden on your network.
It is probably not the issue here; but I was just passing it along.

The operating system caching could be a problem. I was specifically
talking about the write caching on the workstations and possibly the
server. Here are the steps to disable the Disk Write Caching on Windows
2003 Server:
1. Right-click My Computer, and then click Properties.
2. Click the Hardware tab.
3. Click Device Manager.
4. Click the plus sign (+) next to the Disk Drives branch to expand it.
5. Right-click the drive on which you want to enable or disable disk write
caching, and then click Properties.
6. Click the Policies tab.
7. Click to clear the "Enable write cashing on the disk" check box.
8. Click OK.

Here are two articles on disabling Write Caching using the interface:
324805 HOW TO: Manually Turn Disk Write Caching On or Off
http://support.microsoft.com/default.aspx?scid=kb;EN-US;324805
259716 HOW TO: Manually Enable/Disable Disk Write Caching
http://support.microsoft.com/default.aspx?scid=kb;EN-US;259716

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003



i am not using tmpfiles= in the config.fpw
i thought that was to direct it to other than the "c:\documents and
settings\..." location.
each user has a shortcut to a network folder that contains
config.fpw and program.exe
the config.fpw only contains a line that turns off the resource file.

thanks for the link re symantec, i will have to check that out.

i'm not sure what caching you are referring to specifically.
the server is a straight win2003 server enterprise ed, with non-raid
sata drives. i dont think there is any caching turned on unless it is
built into the server OS.

what's unique to this project from my other projects is win2003 server
and also vfp8.

let me know if you have any other thoughts.
thanks for your help.
Jay


Lee Mitchell wrote:

Hi Jay:

Make sure you are directing your temp files locally with a
tmpfiles=c:\folder_name in the Config.fpw file. This will decrease
network
traffic. If you are using any anti virus software on the clients or the
server, exclude the VFP data files from the AV scan:

321550 How to optimize Visual FoxPro applications while using Norton
AntiVirus 2002
http://support.microsoft.com/default.aspx?scid=kb;EN-US;321550

If you have any caching enabled on the workstations or the servers, I
would
disable the caching.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no
rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:

http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003



What error messages are you getting?


What is your SET("TABLEVALIDATE") setting? If anything other than SET
TABLEVALIDATE TO 0, you may be seeing multiuser contention that is
improperly reported as table corruption.


Dan



Jay B wrote:
I have been using VFP 8 for the last few years and since i rolled out
this current accounting application, I am getting random instances of
DBF corruption.
I applied SP1 and all 20 users are running either winXP or win2k.
only 3 computers are pentium III class.

I can't seem to find who or what is causing the corruption, my error
loggers only pick up the next command where an operation fails, and
this usually has nothing to do with what the person was doing
previously. The corruption could have been caused by a different
person.

I checked over network issues and graphic card issues and find nothing
out of the norm.

I have developed many apps over the years since Fox2.5 and never had
data corrption at all. The client is starting to wonder if his choice
of using Foxpro is smart.
This is my first major app using vfp8. all my other running apps are
still in vers 6 or 7.

Can it be that VFP 8 has known issues that easily cause dbf's to get
corrupted??

I have vfp9 waiting in the sidelines, but didnt want to inject another
set of variables unless i had no other options.

Any ideas would be appreciated.
Jay



.

Relevant Pages

  • Re: Corruption with VFP 8
    ... The operating system caching could be a problem. ... 2003 Server: ... each user has a shortcut to a network folder that contains ... 321550 How to optimize Visual FoxPro applications while using Norton ...
    (microsoft.public.fox.helpwanted)
  • Re: Corruption with VFP 8
    ... the server is a straight win2003 server enterprise ed, ... i dont think there is any caching turned on unless it is built into the server OS. ... improperly reported as table corruption. ... I have developed many apps over the years since Fox2.5 and never had ...
    (microsoft.public.fox.helpwanted)
  • Re: netstat - negative number of queues free
    ... This is the integrated Broadcom gigabit Ethernet card. ... come from EFS 5.58a (I intially set up the server using something ... $What happens to the server if you pull and reconnect the network ... possibly be involved in causing corruption). ...
    (comp.unix.sco.misc)
  • Re: Terminal server performance
    ... I am seeing some performance bottlenecks on my single server when more ... There are a lot of network reads and writes to a file server within ... How big is the database? ... Access is famous for table corruption issues. ...
    (microsoft.public.windows.terminal_services)
  • Re: Terminal server performance
    ... I am seeing some performance bottlenecks on my single server when more ... There are a lot of network reads and writes to a file server within ... application instead of MS Access for serious business use. ... Access is famous for table corruption issues. ...
    (microsoft.public.windows.terminal_services)
Loading