Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automation Server
Message
From
14/11/2001 10:15:48
 
 
To
14/11/2001 09:04:05
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00581097
Message ID:
00581495
Views:
15
Hi!

>Hi Vlad!
>
>Dujhe vdyachen za vidpovid'. Yak tam sparvy na Ukrayini?
>

Jak sprava, tak i zliva ;)

>The situation is such. I am doing the way you suggested. And point is not that it is not working at all. It's works, but every other time. Every second run it's hangs up in about a minute. After your pationate wait, it returns you a result and the next time works very fast, but next ... and so on.
>I run RPC server on my server box and my object(EXE/COM) is configured as the one who has Remote acces. May be you know what my be a possible couse in such abnormal an odd behavior.
>

I do not know for sure, but try following:
1. Run your objet not as COM object, but as usual VFP object. Run it on that server in debugging mode in VFP environment. This way you will be able to see if it hanging up by the same way. This way you will know for sure where hanging up comes from: from SQL Server, ADO or RDS.
2. If hanging up comes from ADo or SQL, probably it is because a way of running SP by ADO. As far as I know, ADO tries to get a list of all parameters for SP into the command object's paremeters collection. There were some reports for Oracle OLE DB that this operation cause significant delay (similar to yours). Try to run SP another way: specify it as a T-SQL command text and run a command text, not SP. In the command text, to run SP, you can use "EXEC {sp}". See if this helps.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform