Ryze business networking

Buy Ethereum and Bitcoin
Get started with Cryptocurrency investing

Home

Apply for Membership

About Ryze

Pune Entrepreneurs Network

[This Network is not currently active and cannot accept new posts] | | Topics

"Too many Connectionn" Error

May 06, 2008 5:31 pm

re: "Too many Connectionn" Error

Jitesh Patil

Rishi,

First of all there is no .Net 2008. The latest version of .Net is 3.5. You probably mean you are using Visual Studio 2008.

Now to your issue, what are you using to connect to the mysql database? .Net System.Data DataAccess classes, linq, or an ORM like subsonic?

My guess is you are using System.Data DataAccess classes. Now ehen ever you are accesing database make sure you are doing the following.

try
{
1. open DB connection here.
2. do your DB related stuff.
}
catch (Exception ex)
{
1. Exception handling stuff here.
}
finally
{
1. Close your connection here.
}

The most important thing here is closing the connection in finally, if you were closing the connection in the try block and for some reason the statements above connection close threw an exception, your connection was never closed.

Let me know if you have any questions.

Private Reply to Jitesh Patil (new win)

Ryze Admin - Support | About Ryze