Run a Stored Proc. and return the results at the end 1

[topmac]

Hi everyone,
I have a ASP page that triggers a db-side stored procedure. At the end of the procedure, it spits out a log file, that this ASP page reads and displays for the users.

But the problem is that the database-stored Proc could take anything between 10 secs - to - 10 mins. I dont want the page to time out [But I dont want to increase the time out in the IIS webserver]. Is there a way, like the airlines websites do, where I can just show an animated gif while the procedure runs and redirect the page to results at the end of the procedure run.

ex: like orbitz or hotwire.... or anything like that, but not as complicated as them.

Hope I made my question clear,

any ideas are truely appreciated,
_Mac

 

[DotNetGnat]

try this link:

http://www.aspfaq.com/show.asp?id=2498

-DNG

 

[topmac]

thanks DotNetGnat...
I'll try that first thing tomorrow morning...and post the result.

 

[topmac]

Works just about good for most of the cases.... but sometimes, when the import process takes longer the process TimesOut. Is there a solution to it other than changing value in IIS admin tools.

PMP Import Process Summary 
Active Server Pages error 'ASP 0113' 

Script timed out 

/PMP-TEST/RunImport.asp 

The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.

 

[DotNetGnat]

i would suggest you to look into paging your results...

-DNG

 

[topmac]

The process I have here is a batch that triggers a bunch of ".exe" files on the server. [In a certain way, each step is linked with the prior step.] So this batch file must be executed as a single batch-run.
If there is a way to just let the process run on the server and just once in a minute, check if there is a log file created.
If yes, display it
If not, wait for another min [just show animated GIF]

I dont know what I am getting into... I dont know if it is easy to do or takes a lot of coding...!!
So just looking for ideas and I really appreciate your time DotNetGnat for your ideas. I might tweak the idea presented in the URL you gave me earlier and see if I can figure out a way.
thanks again,

 

[DotNetGnat]

no problem...glad to assist...post back if you have any more problems...

-DNG