Any way to abort a query right away?

vortex · Post by **vortex** » Fri 09 Mar 2007 08:23

Hi, I have a problem with a query that calls a stored procedure which in turn calls a web page for some data. Sometimes the web server doesnt answer and the stored procedure waits for about 3-4 minutes before timing out. Normally they get an answer in maybe 15 sec at most and if it takes longer than that (maybe 30sec) I want to cancel the query and close the popup form that should show the result.

But, I can't seem to do this. I've tried BreakExec but that seems to wait until the SP returns and doesnt help at all. I've tried to just free it but that just gives an access violation later on and so on.

Any ideas on how to accomplish this?

Plash · Post by **Plash** » Mon 12 Mar 2007 10:19

ODAC cannot break execution of such stored procedures. Code that will break stored procedure execution should be added to this stored procedure. For example, if possible set the timeout for the web page call.