A connection pooling error has occurred

[SABhatti]

Hi everyone, I have class to connect to sql database, this class has some public functions which return datatable, dataset, executeScalar and executeNonQuery. I am using this class in multiple location/functions in the main page. If I initialize (new) this class in page load and does not set to nothing it creates the error (refere to subject for error). And if I initialize it in every function and set it to nothing everytime, it works fine. Can someone tell me the best way to use it, should I initialize and destroy in every calling function or initialize in page load, use it everywhere and let Finalize() to destroy it automatically...:(:-D Salim Akbar

[Andy Marshall]

This can be caused by one of two issues; 1 - Your maximum connections have been passed programatically, this is not very common. 2 - The more normal reason is that your close connection + dispose is not being called, this leads to the same sort of error. IMO the best way to handle this is to keep the scope local and ensure correct handling of errors etc guaraantees that your connection is always closed and disposed of when it is no longer needed and then the connections goes out of scope as your function or sub is released to the garbage collector.