c# SQL max pool size was reached

Question

I have a simple while loop that checks the database for inserts. If its in the loop too long my try catch gets "max pool size was reached" error. So at the bottom of loop I have a connectionclearallpools(); But that still doesn't solve it.

while (!quit)
{
connection to database strings timeout=400

read from database


connection.clearallpools();
}

Answer 1

You most probably keep opening new connections in the loop.

Above the loop open the connection is a using statement and then use it in the loop. Also note the removal of the clearallpools:

using(create new connection)
{
    while (!quit)
    {
    connection to database strings timeout=400

    read from database


    // connection.clearallpools(); REMOVE THIS!!!!
    }
}