>WebServer needs to pull data from SQL Server into dbf's for use at a printing company. Works fine, well it works toooooo wellllllll. Seems that my VFP app that I call never ends. The processing is completed, but it never goes out of scope? It may take 1 to 2 min to pull the data.
>
>Any ideas?
Try calling
Marshal.ReleaseComObject();
explicitly to release COM references.
This is required if you have outstanding references to your COM object internally as the RefCount may not go to 0 and .NET is less agressive about cleaning up objects.
The other issue (which is 'normal') is that COM objects get released by the garbage collector, which may not imiediately clear the reference. So calling the above is often a good idea in general to ensure objects get released immediately.
+++ Rick ---