Timeout error

[Fawke101]

Hi there,

Is there any way i can ask a page -

if SQL Server timeout expired then
response.redirect("timout.asp")

I just want to be able to say - server busy - when the SQL server times out.
A bit fluffy i know, but the ppl im doing this for are fluffy.
Cheers

--
Thanks in advance

Fawke

Please remove ANTI and SPAM
from my email address before emailing me.

www.bradflack.com

 

[Bob Barrows [MVP]]

Hi there,

Is there any way i can ask a page -

if SQL Server timeout expired then
response.redirect("timout.asp")

I just want to be able to say - server busy - when the SQL server
times out. A bit fluffy i know, but the ppl im doing this for are
fluffy.
Cheers

No. You only get notified about a time out in the error raised by the
command that caused the time out.

 

[Fawke101]

yea, sounds good - do you have any example code i could take a look at?

--
Thanks in advance

Fawke

Please remove ANTI and SPAM
from my email address before emailing me.

www.bradflack.com

I use an if else statement and if there is a timeout; then I create a

message on the page that says to wait will loading; then I have the page
refresh between 3 to 10 seconds; This keeps happening until there is not
timeout. This makes the user think that the page is just taking a while to
load.

 

[Fawke101]

??

--
Thanks in advance

Fawke

Please remove ANTI and SPAM
from my email address before emailing me.

www.bradflack.com

I use an if else statement and if there is a timeout; then I create a

message on the page that says to wait will loading; then I have the page
refresh between 3 to 10 seconds; This keeps happening until there is not
timeout. This makes the user think that the page is just taking a while to
load.