Connection Timeout property in SqlServer Connection string not Working

Question

I have been trying to Check if the Database is reachable and do custom actions according to the Connection state. My code is as follows

string connectionString = "Data Source =" + textBox1.Text + ";Initial Catalog=master;Integrated Security=true;Connect Timeout=1";

        SqlConnection connection = new SqlConnection(connectionString);
        try
        {
            connection.Open();
             //do some action
            connection.Close();
        }
        catch (SqlException)
        {
            connection.Close();
            //do some action
        }

I provide the Target machine name through a TextBox. In the above code whenever a connection is successfully made, the code within the try block executes within seconds. But if the connection can't be made, it ignores the Connect Timeout property and waits for 30 seconds before moving to the catch block.

I tried the following link connection timeout property in connection string ignored and found no success. I have tried for a Connect Timeout value of 5,10,15 and 20 seconds and nothing seems to work.

Help me out if something is wrong with my approach.

Thanks!

Dan Guzman · Accepted Answer · 2016-10-23 13:58:48Z

1

You need to specify the correct connection string keyword Connection Timeout=1.

In my experience, the actual time before the exception is raised may a couple of seconds longer than specified when the error is due to the server being unreachable rather than a full connection pool, which results in an InvalidOperationException rather than a SqlException. I suggest a using block to ensure to test connection is immediately disposed:

try
{
    using (var connection = new SqlConnection(connectionString))
    {
        connection.Open();
    }
}
catch (SqlException ex)
{
    //do some action
}
catch (InvalidOperationException ex)
{
    //do some action
}

Consider using the SqlConnectionStringBuilder class to avoid injection vulnerability.

edited Oct 23, 2016 at 13:58

answered Oct 23, 2016 at 13:35

Dan Guzman

46.8k3 gold badges52 silver badges77 bronze badges

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

Collectives™ on Stack Overflow

Connection Timeout property in SqlServer Connection string not Working

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related