sudharsan s

sudharsan s

  • NA
  • 279
  • 71.8k

mysql connection time out expired?

Jun 27 2012 1:57 AM

hi.


 I am Using .NET 3.5 with mysql db.

when i am run my application i got error in my sql connection string

    m.ConnectionString =
       "Host=localhost;" +
       "DataBase=dheelabs_remedies;" +
       "Protocol=TCP;" +
       "Port=3306;" +
       "Compress=false;" +
       "Pooling=true;" +
       "Min Pool Size=0;" +
       "Max Pool Size=100;" +
       "Connection Lifetime=0;" +
       "User id=root;" +
       "Password=root;";
        m.Open();
          

ERROR

m.open

Error description:

error connecting: 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.


help me to solve this.,....!

Answers (1)