Which portion are you trying to automate here? Checking for the resources will require polling no matter what you do. For that I would create some sort of service based front end application that does this. If you already have something like this, then you can also immediately send off a message, or fire a COM object (to isolate the process which can be meta driven) or use any of the COM+ services such as COM+ events/Queued Components.
However I think if you already have this first process running to check for the resources, you can bypass any middleware and just fire your code. Overall, though it seems to me a table driven approach would be much easier than trying to overcomplicate things with all of these COM technologies.
There are a few things that might be useful: Queued Components are useful here, because you can basically run a COM object asynchronously without waiting for completion. If needed the components can then send a COM+ event to notify the original caller of completion. It's some work to make this happen though. The benefit is that you don't have to keep everything running all the time. Each of the operations using COM+ events/queued components, fires when needed and goes away so you can defer any work that needs to be done when the data is picked up.
+++ Rick ---
and then this application can fire off either a message, call a COM component (so you can isolate the processes) or
There are a number of ways to do this, but from what you say I don't think MSMQ is the right choice because it won't necessarily be a FIFO arrangement.
>Hi, I have a question regarding connecting to and using Windows 2000 message queues from with VFP7.0.
>I am trying to develop a system that responds to requests for information from several sources (some FTP, VPN, text files etc) without polling a table or directory. When a request arrives route the request (via a VFP message router into a queue) and have a VFP processor that reacts to the message's arrival, processes and returns the respons (via a reply queue). The router collects the response and sends in on to the recepient. Can you help or do you know where I could obtain some sample foxcode for establishing a connection to a queue, placing messages into a queue, reading from and releasing a queue? As much help as you could please?
>
>Many thanks,
>Buddha Baker