>Maybe you all can help me out here. I just joined a new company that is shipping an international VFP application worldwide. They are keeping the data on a server in New York as well as the middle tier (COM objects). The interface is VFP.
>
>My challenge is to create COM objects to talk to the backend (SQL Server and VFP), convert the data to XML and send the data to the client (VFP) over the internet. How would private data sessions be handled? For that matter, since the client can't talk to the data directly because the middleware will exist as stateless components, what's the best way to handle updates? Any ideas would be greatly appreciated.

See Rick Strahl's site www.west-wind.com for his white papers and examples on doing this.