Asynchronous Stored Procedure Call - Issues!

[Guest_imported]

I'm using vbScript to call a stored procedure, which takes several hours to complete. If I use cmd.Execute synchronously, the Web browser obviously times out - waiting for the stored procedure to return control to the script. I need to do this asynchronously, but I'm not able to come up with the right combination of option constants that will A) successfully run the stored procedure, and B) restore control to the browser. A snippit of my code (which accomplishes B but not A) is below - thanks in advance for any assistance.

Set cmd = Server.CreateObject("ADODB.Command&quot
With cmd
Set .ActiveConnection = cn
.CommandText = "gd.GET_DEPLETIONS"
.CommandType = adCmdStoredProc
.Execute , , adAsyncExecute + adExecuteNoRecords
End With

 

[NickBulka]

You'll want to use the recordset object to execute the proc. If you declare your recordset object withevents, you'll be able to get progress events.
Here's a code snippet to get you going:

cmd.CommandType = adCmdStoredProc
cmd.CommandText = "gd.GET_DEPLETIONS"


With rsRecordset
.CursorLocation = adUseClient
.Open cmd, , adOpenStatic, adLockBatchOptimistic, adCmdStoredProc + adAsyncExecute
End With

Do While rsRecordset.State = adStateExecuting
doevents
loop

nick bulka