MySQL Timeout Expired

See more:

SQL

String strcon = @"server=localhost;user id=root;password=root;database=mdagree;persistsecurityinfo=True;Connect Timeout=500";
                con = new MySqlConnection(strcon);
                if (con.State == ConnectionState.Open)
                {
                    con.Close();
                    con.Open();
                }
                else
                    con.Open();

Hi,i'm working in c# windows application with mysql database for small Automation(Automatic MySQL database insertion)application.

To do this task i need a MySQL Connection. i'm using the above code for MySQL connection this works well but most of the time it produces error like

Quote:

" Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.; "

when this error occured my MySQL connection get disconnected.