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]

Re: How to call a stored proc asynchronously

This is what the adAsyncExecute flag is for.

http://www.aspfaq.com/2194

--
Aaron Bertrand
SQL Server MVP

http://www.aspfaq.com/

"Dennis" <dbronstein@yah oo.com> wrote in message
news:u1dY7q1QEH A.3748@TK2MSFTN GP09.phx.gbl...[color=blue]
> 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[/color]
make[color=blue]
> a dll and call it from there, but we'd rather just be able to keep it[/color]
simple[color=blue]
> and call it from the page if we can.
>
>[/color]

[dlbjr]

Re: How to call a stored proc asynchronously

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.