Every database is having some number of connection limits which you can increase up to an extend.
But database can support up to an number of connections.
This error occurs when we open a connection and forget to close that. Verify each line of your code and make sure you had closed the connection after completing your database operations.
I had faced this error in C# My sql application. I had crossed verify my code and find a code where I am not closing my connection after completing my operations. I had simply write connection.Close(); and it had worked.
C# too many database connections error
An IT Solution is a purpose and value-driven organization where everyone is empowered to take decisions in line with our culture. We provide a unique environment of freedom, flexibility & trust that allows an individuals potentials to flower; this results in tremendous growth opportunities.Such a culture, naturally, appeals to everyone. We listen, we think and we act. The IT field is all about thought leadership. We invest in thought for you as customers
1 comment:
This does not seem to make a clarification whether there is a using() pattern used or try catch finally used.
My recommendation would be to put the connection close and connection set to null in the finally block.
Post a Comment