constantly getting SQL Server Timeout error

[jkat]

Hello, Im using ASP and sometimes randomly when my ASP tried to OPEN a connection with my SQL server, i get the following error:

[Microsoft][ODBC SQL Server Driver] Timeout expired

I am using a DSN on my webserver that is connecting to another SQL server.

Any help on this would be greatly appreciated!!!

Thanks alot!!!

-Jason

 

[tlbroadbent]

"Timeout expired" means your query has exceeded the query time limit for your connection. There are at least two approaches to solving the problem.
[ol][li]Set a higher query timeout limit for the connection.
[li]Make the query run faster.[/ol]obviously, the 2nd approch is best. For web pages you want quick response. Try to analyze the query - check the query execution plan and analyze indexes - to see if the query performance can be improved. Then as a last resort increase the timeout value. Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot