469,883 Members | 1,119 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,883 developers. It's quick & easy.

Timeout error

J
How can I prevent the error of...

Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.

The program is returning a quite hefty amount of data, which takes about 40
seconds to retrieve. My session timeouts are set to 900 seconds, but I've
been told I can programatically change it via asp.net.

Any ideas?

TIA
Nov 17 '05 #1
3 2034
This is SQL timeout - not an asp.net session timeout. The 2 are not related.

Set the CommandTimeout property on your SqlCommand object.

"J" <nospam> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
How can I prevent the error of...

Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

The program is returning a quite hefty amount of data, which takes about 40 seconds to retrieve. My session timeouts are set to 900 seconds, but I've
been told I can programatically change it via asp.net.

Any ideas?

TIA

Nov 17 '05 #2
J
Thank you.
"Marina" <zl*******@nospam.hotmail.com> wrote in message
news:e6**************@TK2MSFTNGP09.phx.gbl...
This is SQL timeout - not an asp.net session timeout. The 2 are not related.
Set the CommandTimeout property on your SqlCommand object.

"J" <nospam> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
How can I prevent the error of...

Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.

The program is returning a quite hefty amount of data, which takes about

40
seconds to retrieve. My session timeouts are set to 900 seconds, but

I've been told I can programatically change it via asp.net.

Any ideas?

TIA


Nov 17 '05 #3
"J" <nospam> wrote in message news:<#$**************@TK2MSFTNGP10.phx.gbl>...
How can I prevent the error of...

Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.

The program is returning a quite hefty amount of data, which takes about 40
seconds to retrieve. My session timeouts are set to 900 seconds, but I've
been told I can programatically change it via asp.net.

Any ideas?

TIA


Set your CommandTimeout to a few hundred seconds. Setting it to 0
should be infinite but there is a bug in .Net and this functionality
doesn't work. Bump your timeout up to say 100 (its in seconds).
Browsers (clients) don't timeout once they have a connection
established, ignore the fools on the rest of this thread.
Nov 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

17 posts views Thread by Achim Domma | last post: by
4 posts views Thread by Cath B | last post: by
5 posts views Thread by Jason | last post: by
9 posts views Thread by tshad | last post: by
5 posts views Thread by supercooper | last post: by
2 posts views Thread by Robin Becker | last post: by
1 post views Thread by Scorpion657 | last post: by
2 posts views Thread by Andrew Cooper | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.