> How do you get the data from the COM objects back to the desktop?
I've actually written my own VFP class that chops up the data and uses http to move the data back and forth between the desktop app and web com. It's been in production for a number of years now and works really well.
The other thing we are looking at is LINQ. It looks like we could create a middle tier COM with this that VFP could instantiate and call. Then this LINQ COM would use ADO.NET to talk to SQL instead of ODBC....