Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp7t.dll freezing
Message
 
To
15/11/2002 15:53:47
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00723420
Message ID:
00723982
Views:
8
This message has been marked as a message which has helped to the initial question of the thread.
Hi Trey

Vfp7t.dll is not to blame: You 've hit a limit placed into COM+ thread pool to prevent excesive resource consumption: only 8 "STA threaded" objects active at the same time in a single-processor machine (BTW, you get 1 object more for each additional processor). Both VFP and VB COM objects suffer the same limit, it's something about the threading model and not the language used.

You can find detailed information in: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q282490

Though there are certain ways to workaround that limit, the suggested solution is to avoid as much as possible blocking a COM method for a long time.

So you should see why are your methods taking too long: if there is just a "Sleep" API call -placed for testing purposes- remove it, its not a wise test. If it is the SQL data access which takes a long time, you should use asyncronous access -I can give you more details if needed-.

Regards,
Jose.

>We have an intranet database application with business logic in VFP7 under COM+ on Win2k Advanced Servers. (not using any .NET)
>When QA is testing, they will be frozen with only around 7 or 8 screens active. A dump of file locking shows that the vfp7t.dll is (or seems to be) the culprit, with the same number of locks as screens active (naturally).
>Across instances of freezing, there doesn't seem to be a common COM server involved.
>
>Any ideas?
>I've kept this question general at first to get a wider variety of narrowing down questions.
>TIA
------------------
Jose Marcenaro
Tercer Planeta - Argentina
http://www.tercerplaneta.com
Previous
Reply
Map
View

Click here to load this message in the networking platform