Good job I have a cup of coffee in front of me. That’s a lot to take in. Thanks for the ideas though I may well look at that. In fact it makes sense to have the work done on the computer with the data. Thanks Now all I need is a dark rainy day. Its sunny out today :) so maybe later Allen
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sietse Wijnker Sent: 29 August 2007 11:36 To: [EMAIL PROTECTED] Subject: RE: More web services Hi Al, I've got a possible solution for you, if you're using COM+. It's kind of a stretch if you've never used COM+ but it has some huge benefits. Try installing the COM-component IN COM+ on the DATA/File-server using local pathing. Then export the class from COM+ as an Application proxy Install this export on your web server. Now when calling the COM-object from ASP, the call is automagically routed through DCOM to the DATA-server where the actual code is run locally. Then the result is ported back through DCOM to the webserver/ASP-page. The benefit here is that the VFP COM object doesn't need to retrieve all the indexes/data over the network cable but is run locally. There's a slight overhead on the network for the call marshalling but in my experience this is far less thn retrieving all the indexes/data over the network for execution on the web-server. There's still a security issue because the settings for execution on the COM+ application are all done on the data-server. Most of the settings COM+ are disabled on the COM+proxy application on the web server. Maybe it's a trick to investigate on a dark rainy day...;) Regards, Sietse Wijnker No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.12.10/977 - Release Date: 28/08/2007 16:29 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
