I have an application with 8 installations on a WAN. I have written a "head office" application that needs to collect & collate data from each of the sites.

Each site is a separate VFP6 application (shortly to move to VFP7) with it's own set of DBF's.

I have written the head office app in VFP7 using DCOM objects located in each of the sites, however both the network and DCOM are proving unreliable. Lost connection, slowing the site servers (taking 100% CPU!)
I think the bottom line is that persistent objects across a WAN are a No-No.

I now need to (very quickly) re-write my app to avoid DCOM so far I have two ideas/theories;

1. Create an HTTP service for head office and host in each site (disadvantage is that each site needs to become a web server)
2. Create an IP Socket application that "listens" at each server and replies to IP requests.
(Disadvantage non-standard and little knowledge)

Can anyone with any ideas/thoughts ??

Gary Williams