How to call a stored proc asynchronously

[Dennis]

Is it possible to call a stored procedure asynchronously from an ASP page?
We would like to be able to execute a proc and have the page continue to
process without having to wait for the proc to finish. I know you can make
a dll and call it from there, but we'd rather just be able to keep it simple
and call it from the page if we can.

[Aaron Bertrand - MVP]

This is what the adAsyncExecute flag is for.
http://www.aspfaq.com/2194

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Dennis" <db********@yahoo.com> wrote in message
news:u1**************@TK2MSFTNGP09.phx.gbl...

Is it possible to call a stored procedure asynchronously from an ASP page?
We would like to be able to execute a proc and have the page continue to
process without having to wait for the proc to finish. I know you can make a dll and call it from there, but we'd rather just be able to keep it simple and call it from the page if we can.

[dlbjr]

An easy way is to have two asp pages. One is the page with an XMLHTTP call to the other.
This will allow the main page to process at the same time the asynchronous XMLHTTP call processes
the data on the other asp and places the result in the main page.

'from dlbjr

'Unambit from meager knowledge of inane others,engender uncharted sagacity.