we developed .net web application with mysql data base which runs in intranet. It causes server error once or twice in day.. but when we rebild it it again work fine for few hours..
"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." I have seen this warning in eventlog not always but some times. But when it crashes I can connect database throgh my local machine by using same connection string.
actually application uses layers. In data layer i opened connection closed it and also disposed. Also I written backgroud process which kill all sleeping connection which runs every ten minutes and kills conection in sleep mode more than 200 sec... Earliear this problem was not there from last month it suddenly started...