Re: Calling ASP function asynchronously

From: J. Baute (WUPYRDEDAWJD_at_spammotel.com)
Date: 03/12/04


Date: Fri, 12 Mar 2004 12:15:34 +0100


AFAIK there is no way to make an asynchronous call to a VBScript function,
since you can't define events in ASP, and that's something you need to be
able to know you results have return properly,

but, since you managed to work async with a stored procedure through ADO,
maybe there's a way to call the COM object from an stored proc which is
perfectly possible if you are using MS SQL server as your DB.

Btw, I'm curious how that async stored-procedure magic works in ASP though,
would you mind sharing a snippet of code? :)

"Bob Murdoch" <ram_re_move_5@erols.com> wrote in message
news:e1btxV4BEHA.2380@TK2MSFTNGP10.phx.gbl...
> I have an ASP application that calls a COM function to create a custom
> report as an Excel file. This works in a synchronous fashion, as long as
> the report does not take too long to create. If that happens, the session
> times out and we run into other kinds of problems.
>
> I have, in other cases, executed a stored procedure asynchronously (thanks
> to a tip from this group) thru ADO.
>
> I'm wondering if ASP provides some way of executing a function (an ASP
> function, not ADO) asynchronously? I could then make the call to the COM
> function from within this async thread, and implement the same refresh
logic
> on the client that we used in the ADO solution.
>
> tia,
>
> Bob M..
>
>



Relevant Pages