Timeout

[Guest]

Hello

I have a SQL Server 2000 database query that takes a long time (about 1.5 min in SQL Query Analyser) that I am running from a web page. I keep getting a Timeout error regardless of how long I set the Timeout property i

Server.ScriptTimeout = 5000

in the asp.net page o

Connect Timeout=500

in the DB conn string. I still get a System.Data.SqlClient.SqlException error from asp.net

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not respondin

The server is there because the same conn string is used in other queries that work. What is the problem?

 

[Marina]

ScriptTimeout is the timeout for the asp.net page - meaning how long it has
to be working for before it times out. Unrelated to database timeouts.

The connect timeout in the connection string, is how long you should try to
connect for, before giving up if not able to connect.

Again, unrelated to actually running a query - just talking about the
timeout to connect to the database (hence, connecttimeout).

You need to set the CommandTimeout property of the SqlCommand object - this
is the timeout that defines how long a query can run before it is deemed a
problem.

Hello,

I have a SQL Server 2000 database query that takes a long time (about 1.5

min in SQL Query Analyser) that I am running from a web page. I keep
getting a Timeout error regardless of how long I set the Timeout property in

Server.ScriptTimeout = 5000;

in the asp.net page or

Connect Timeout=5000

in the DB conn string. I still get a System.Data.SqlClient.SqlException error from asp.net:

Timeout expired. The timeout period elapsed prior to completion of the

operation or the server is not responding

The server is there because the same conn string is used in other queries

that work. What is the problem?

 

[Guest]

Marina

Thank you so much. That did it! And thank you for the explanation of the different timeout properties.