August 7, 2002 at 3:06 pm
Hi
Is there a way to call an stored procedure from an external application and not wait for it to complete?
I have an SP, that runs for about 2mins, that I need to call from Access. The SP does not return anything and I do not care (whithin Access application) when it finishes. Access times out on me while running it.
any ideas?
Thanks,
Jakub
August 7, 2002 at 4:02 pm
One way would be launch it as a job. Another would be to execute it in a timer event and then disable the timer (so it doesn't recurse). I think ADO does have some support for async execution, but have not tried it so far. If its just a time out issue, you can also consider tuning the proc or setting the timeout in the app to a longer period.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply