sql server connection pool

i got this error

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.


i made theconnection time out 6000 insteade of 600 (default ) from  sql server management studio
and still getting the same error
LVL 4
AhmedHindyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arsaifCommented:
On your SQL connection string, there is an option (Max Pool Size) that you can specify to increase the size of your connection pool. The default is 100 if you don't specify any other value. The default value should be sufficient in most cases. If you determine that you need more, you can specify a higher value in your connection.

0
batchakamalCommented:
I hope the default 100 is enough....

Any how, make sure that you use Connection.close to clear the pool..

Most often the problem is because database connections are being opened but never closed. Eventually they will time out and the problem will go away for a while, but will soon return. If you are opening a connection inside a loop, try moving the open/close connections outside the loop or call .close() on the connection at the end of the loop. Examine your code and make sure that you close all of your database connections as soon as you are done with them, this will return your connection to the pool so it can be used by the next database operation. If you don't explicitly close the connection when you are done, it will stay open and out of the pool until it times out, which may be several minutes.

Source: http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/c57c0432-c27b-45ab-81ca-b2df76c911ef
0
Anthony PerkinsCommented:
>>i made theconnection time out 6000 insteade of 600 (default ) from  sql server management studio<<
The timeout is set at the client and not at the server.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
I suggest enabling MARS for more effective pooling.. Does the trick sometimes with little effort...Read below...

http://msdn.microsoft.com/en-us/library/h32h3abf.aspx
0
deightonprogCommented:
I would first investigate whether or not you are failing to close and dispose a connection once it has been finished with.


You can run stored procedure sp_who on your server to see how many connections your application has, if during usage the number of open connections is building up, you are quite likely to be failing to close one somewhere.

normally you should utilise the USING command when declaring a connection, that guarantees it will be closed when you leave that routine.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.