how to set connection timeout to infinity(till command completes)

Question

0.00/5 (No votes)

See more:

i have written a connection string to be used in a Windows appliation, to which i need to set connection timeout property. it should be infinte or till the command completes.
here is the code of connection string...

string strCon = "Database=inventory;UserID=root;Password=root;server=localhost;Connection Timeout=900";//60 second * 15 minutes

but its not working. Gives exception ... "Server timed out."
plz help me out.

Posted 29-Sep-13 22:47pm

Member 9822231

Add a Solution

Comments

Member 11651318 22-May-17 2:02am

how can give the max connection time out value in c#

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Soumitra Mithu · Answer 1 · 2013-09-29T23:27:00

Solution 2

Most accepted method of doing this is through the
CommandTimeout property of the SqlCommand object.
Set it to 0 for an infinite timeout.
For More Information click here.

Posted 29-Sep-13 23:27pm

Soumitra Mithu

Updated 29-Sep-13 23:30pm

v2

londhess · Answer 2 · 2013-09-29T23:05:00

Solution 1

Put Connection timeout to 0. A value of 0 indicates no limit (an attempt to execute a command will wait indefinitely).
But do not set connection timeout in connection string. Because an attempt to connect waits indefinitely. So you can use in your command like SqlCommand.CommandTimeout=0;This is the good practice.

Posted 29-Sep-13 23:05pm

londhess

Updated 29-Sep-13 23:14pm

v2

Comments

Member 12181406 12-Aug-16 10:35am

Do not ever set the timeout to 0. This will suspend the SPID indefinitely. If you cannot connect to the DB and get connected in 15-30 seconds, then there is an issue. Maybe there is too much activity and the pool is exhausted - fix this - do not wait indefinitely - ever.