C#+Mysql Runs out of Connections. I am using 'using' and closing all connections immediately.
- by Cyril Gupta
In the application that I am making right now, I am getting this error:
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.
Evidently I am touching max-count in the connection pool. I am dutifully using 'using' with all connection objects and freeing them up immediately when the function is done with them.
This is on C#, and I am using the MySql Data Dll.
Is there something wrong with the dotnet connector for MySql? Is there a workaround?