The timeout period elapsed prior to obtaining a connection from the pool.

[anumsajeel]

Hi,

Error Message:-
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.
Target Site:-
MySql.Data.MySqlClient.Driver GetConnection()
Error Source:-
MySql.Data
Error Full:-
MySql.DataMySql.Data.MySqlClient.MySqlException: 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.
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at SM.Quiz.Questions.Collection.StoreQuestionsCollect ion.GetQuestionsGenericCollection()
in C:\Working\QuizEngine\BusinessLibrary\SM.Quiz.Ques tions\Collection\StoreQuestionsCollection.cs:line
20

Life in the UK Test Online, British Citizenship Test, UK Citizenship Test

[PRR]

"Error Message:-
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."
You need to increase the connection pool size...like in your connection string you could specify....
"Database = Northwind;Min Pool Size = 25;Max Pool Size=150";

[anumsajeel]

@DeepBlue
Thanks, I am going to change the connection string as you explained.. and will let you know later on.

Thanks,
Life in the uk test