Connecting to MySQL database with C#

Question

I am using:

        if (connection.State != ConnectionState.Open)
        {
            OpenConnection();
        }

and

private bool OpenConnection()
{
    try
    {
        connection.Open();
        return true;
    }
    catch (MySqlException ex)
    {
        //When handling errors, you can your application's response based 
        //on the error number.
        //The two most common error numbers when connecting are as follows:
        //0: Cannot connect to server.
        //1045: Invalid user name and/or password.
        switch (ex.Number)
        {
            case 0:
                Console.WriteLine("Cannot connect to server.  Contact administrator");
                Console.Read();
                break;

            case 1045:
                Console.WriteLine("Invalid username/password, please try again");
                Console.Read();
                break;
        }
        return false;
    }
}

I always get System.InvalidOperationException: The connection is already open. it doesn't make sense because I check if it's open already.

Thanks in advance.

McGarnagle · Accepted Answer · 2012-04-15 21:50:26Z

2

There are connection states other than open and closed: Broken, Closed, Connecting, Executing, Fetching. You should only try to open if it's "Closed". If anything else it needs to be handled differently.

answered Apr 15, 2012 at 21:50

McGarnagle

103k31 gold badges235 silver badges264 bronze badges

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

1 Comment

Sandeep Over a year ago

@user1335122 print the connection state before if statement. That may give you some info regarding the state.

Collectives™ on Stack Overflow

Connecting to MySQL database with C#

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related