Larry,

Craig's articles were first class. I tried out his examples and they seem to work fine. I think that will solve the problem.

Steven


>Steven,
>A good place to start on COM+ (IMO) is at Craig Berntson's site (http://www.craigberntson.com/articles.htm ). He wrote a few articles for FoxTalk on the subject. You can also handle this via a WebService. Check out the following article found in MSDN.
>
>http://msdn.microsoft.com/library/en-us/dnfoxgen7/html/vfpws.asp
>
>HTH.
>
>>Hi,
>>
>>I keep my web server running West-Wind WebConnection in a demilitarized zone outside the internal network where the accounts server is located. The accounts are using FoxPro tables and not SQL Server.
>>
>>The web server therefore has to query data that is on the accounts server behind the firewall. Now, to query the data it will improve performance if the process is done on the accounts server, and that the accounts server just returns the results to the web server. (As the amount of data is very big, the queries might otherwise download hundreds of thousands of records over the network.)
>>
>>What is the best way to do this? I could create a COM exe on the accounts server and call it from the web server. That would insure that the process is run on the accounts server. However, I understand (correct me if I am wrong) that the exe file is not multithreaded, which means a separate version of FoxPro will load for every call to the exe file. If there are many calls simultaneously, this could bring down the server.
>>
>>On the other hand, if I use a multithreaded DDL, won't that one acutally run in the process of the program that called it, in this case the WebConnection situated on the web server? If that is the case, I will still be back to having lots of data pulled through the firewall and the network.
>>
>>Maybe COM+ can solve this, but my problem is that I don't really know that much about COM+. I think COM+ would allow me to run a DLL in the a separate process, just like Transaction Server used to do? Is that possible? How would I do that?
>>
>>If there is anyone who understands these issues and can give me some advice I would appreciate it.
>>
>>Steven