Hi Geert here goes some points:
1. f you aren't using VFP7 then you should VFP 6 Build COM Objects but VFP 7 Build COM+ Objects.
2. on the initialization of your COM+ objects always include SYS(2335, 0) for vfp to run in unattended mode.
3. On your untraped error use COMRETURNERROR to populate the COM+ exception
4. always clear object references when they are no longer needed.
5. Take caution to cycle references with objects.
>Dear thread user,
>
>My problem is unfortunately pritty vague. It is related to writing solid COM+ methods in Visual FoxPro. My current 3 tier application is using:
>-asp (vbscript) on the ui-tier.
>-vfp (ado) on the business-tier.
>-vfp on the data-tier.
>
>My problem is, that my current application keeps randomly crashing component services after calling any spefic method. In component services the com-ponent just keeps on spinning. I'am not able to manualy shut down the component and sometimes even the whole component services crashes. This means I have to restart my computer.
>
>As you can see, this is not an ideal situation for a client working with my application. Any info on :
>- this specific problem;
>- writing stable com+ components using foxpro;
>- bypassing bugs in component services.
>Is very, very welcome.
>
>Kind regards,
>Walter Wisselo
Alexandre Palma
Senior Application Architect