Error: Timeout expired.

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 am using window 2000 server and MS SQL 2K DEVELOPER.
i am doing .NET to connect to the server.

This error occur when there are too many ppl connect to the server.
May i noe how to solve/configure it.

thx in advance

As the error message states,your connection pool is full. YOu can either:

1. Increase the pool size, but I guess this will just solve the problem short-term :)
2. Do not use connection pool (not a good option)
3. See if you somehow leave connections open and don′t close it explicitly (which should be done within the scope thei are opened) Normally the garbage collector should and collect open connections, as far as I remember this is defined in the IDisposable Interface, but doing that explicitly will let you sleep better :)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||3. See if you somehow leave connections open and don′t close it explicitly (which should be done within the scope thei are opened) Normally the garbage collector should and collect open connections, as far as I remember this is defined in the IDisposable Interface, but doing that explicitly will let you sleep better :)

hmmm i cant IDisposable Interface. Can explain?
are there any sample web site where i can reseach about it? i have browse through google and yahoo but i cant find any information about this error.

thx