Home > IT Answers > Development > DOT NET SQL CONNECTION TIME OUT PROBLEM
KonguKarna
5 pts.
 DOT NET SQL CONNECTION TIME OUT PROBLEM
.NET, SQL connection, SQL Connection Timeout
IN MY SQL CONNECTION STRING I WAS MENTION CONNECTION TIME OUT IS 500. MY SQL PROCEDURE WAS RUNNING 45 SECONDS ONLY IN QUERY ANALYZER. ITS RUN ON DOT NET PROGRAM THEN CONNETION TIME OUT ERROR WAS COMMING.

Software/Hardware used:
DOT NET 2005 WITH SQL SERVER 2000
ASKED: April 21, 2010  4:53 AM
UPDATED: April 21, 2010  4:41 PM
RELATED QUESTIONS
Answer Wiki:
The timeout in the connection string is the connection timeout, not the command runtime timeout. Within your .NET code on the object which executes the stored procedure you should be able to set a timeout parameter. This will change the runtime timeout for that command.
Last Wiki Answer Submitted:  April 21, 2010  4:41 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Is this error occurring when executing the stored procedure, or when connecting to the database ?

The connection timeout property defines the time to wait when establishing the database connection, and it does not affect the execution of commands when the connection is already open.

BTW, 500 seconds are more than 8 minutes, and that is too much time to wait for a database connection.

carlosdl
 63,580 pts.