ASP: - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Other Development Tools

ASP:

Author

Topic

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-10-22 : 15:35:40

Hello ,
we are using a server side XML object to process some remote server requests/response of our clients.

However at times, a user request could take a while, so we set the server.timeout object to 600 to give it enough time to execute.

However we noticed in some instances, when the process takes too long, the server process continues the execution but the client times out

Is is possible, for an ASP page to redirect the client browser, with a status code, saying his request is being executed, while the server executes ?

I tried to put an response.redirect in the execution loop, when it exceeds a certain value, but the script just stops execution on the server

Any advice on this ?

Thanks
AFrika

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-10-22 : 15:57:21

you can put an async call in javascript with XMLhttp to another page that executes the sproc.
when the procedure completes a user gets a message in his window.

i can't find an example in asp.
this is in .net
http://www.15seconds.com/issue/050526.htm
but only thing you need to fix is the server side, which shouldn't be too hard.

Go with the flow & have fun! Else fight the flow

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-10-23 : 08:40:18

Amazing the things that can be done.

Have been battling with this for a while, I saw an article but it used a COM component, to get the state of the server, so it wasnt really helpful

Would check this out and let you know

Gracia mon ami

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-24 : 01:17:15

Refer this also
http://vyaskn.tripod.com/watch_your_timeouts.htm

Madhivanan

Failing to plan is Planning to fail

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-10-24 : 04:02:15

Thanks for the reference Madhivanan

Boy your posts are really going up :-)

Afrika

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-24 : 04:09:58

>>Boy your posts are really going up :-)

Just Little helps from me

Madhivanan

Failing to plan is Planning to fail

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-10-24 : 04:43:41

Best wishes mon ami

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-24 : 04:54:02

>>mon ami

What does it mean?

Madhivanan

Failing to plan is Planning to fail

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-10-24 : 05:05:38

mon ami = my friend

Its French

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-10-24 : 05:06:20

so is xmlhttp going to solve your problem?

Go with the flow & have fun! Else fight the flow

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-10-24 : 05:26:53

Hi Spirit1,
NO SIR, we are running ASP,a and the article is in .net

Although we have some .net apps inhouse, we dont run server side process in Jscript.

the article is quite interesting though and we are looking for a way to maneuver it to suit our needs. Cos AJAX is just want we need.

Its a very smart and userfriendly way of implementing things

Gracia Mon ami :-)

Afrika

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-10-24 : 05:33:03

yes... but what is your problem?
.net isn't an issue here.
the stuff that's done in .net in the article is your page that calls a sproc in old asp.
that's it.

Go with the flow & have fun! Else fight the flow

SamC
White Water Yakist

3467 Posts

Posted - 2005-10-24 : 08:37:53

I don't have details for you, but I Googled some fragments that indicated ASP applications solve this problem by presenting a progress bar of dots... with dots forwarded by the server application every few seconds. Sounds like a method to keep the client browser from timing out and doubles as an indicator of activity.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-10-24 : 09:28:24

hi Spirit1
Am looking at the article again.

Get back to you on this

SamC, well, we have a dundas upload component that allows you to get the state of the server.

But it works with a 3rd party COM component, which we cant install on our host at present

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-10-24 : 10:19:49

you could also put an iframe on your page and call the desired page to process in there...
the only thing limiting you is you can't go to any oter page

Go with the flow & have fun! Else fight the flow

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-10-24 : 10:30:31

iframes ?

I thought they only work with IE ?

Would prefer the above option, would prefer that, cos the frame would just be looping pending the results

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-10-24 : 10:48:22

Iframes are supported in HTML 4.0 and higher:

http://www.w3.org/TR/html4/present/frames.html

Firefox, Opera, Mozilla and most (if not all) other current browsers support them.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-10-24 : 15:09:59

hi robvolk,
Some post counts in this forum are intimidating.

Sounds like the bible, when they said they were giants in the land
ohla laaaa......

:-)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources