SqlConnection.ConnectionTimeout Property

Question

I tried to set ConnectionTimeout of SqlConnection object (C#). But it is read-only property. Default timeout to establish connection is specified as 15 seconds. I want to increase the timeout to 60 seconds.

Is there any other way to set ConnectionTimeout property?

The timeout is specified by the connection string used to initialize the SqlConnection object. See the example on msdn.microsoft.com/en-us/library/… — IllusiveBrian
– IllusiveBrian, Commented Jun 6, 2014 at 5:05
@Namfuak Actually I referred the link before ask question... I didn't see the example as it was collapsed.. Thanks.. — Jesuraja
– Jesuraja, Commented Jun 6, 2014 at 5:28

nvoigt · Accepted Answer · 2014-06-06 05:07:19Z

2

You can set the connection timeout in the connection string your pass to the SqlConnection instance.

"Connection Timeout=60"

answered Jun 6, 2014 at 5:07

nvoigt

77.8k28 gold badges103 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dhaval Patel · Accepted Answer · 2014-06-06 05:07:09Z

0

if it's for one or two query probs then you can set the CommandTimeout property.

cmd.CommandTimeout = Convert.ToInt16(ConfigurationManager.AppSettings["CommandTimeout"].ToString());

answered Jun 6, 2014 at 5:07

Dhaval Patel

7,6116 gold badges43 silver badges72 bronze badges

2 Comments

Dirk Over a year ago

CommandTimeout and ConnectionTimeout are not identical. Take a look at this answer for an explanation of it.

Dhaval Patel Over a year ago

yes that's y I have writen in my answer if one or two query exceution take more time then set the CommandTimeout

Collectives™ on Stack Overflow

SqlConnection.ConnectionTimeout Property

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related