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

ERROR: There is no data for the field at position 20

This error is displaying in the log file just prior to this entry:
ERROR: Internal error: System.Web.HttpException: Cannot redirect after HTTP
headers have been sent.
The report is being called and displayed using the out of the box Report
Manager with all current updates. It is a periodic problem with the
user-facing error displaying smack dab in the middle of the page in a middle
column of the report.
Can anyone provide any help in resolving this intermittent issue?I had the same problem.
We are using an alias for our server name and the following file was causing
it to redirect in the background to the real server name which was causing
authentication to fail especially through the proxies.
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\rswebapplication.config
hth
Dave
"ToxicDice" wrote:
> This error is displaying in the log file just prior to this entry:
> ERROR: Internal error: System.Web.HttpException: Cannot redirect after HTTP
> headers have been sent.
> The report is being called and displayed using the out of the box Report
> Manager with all current updates. It is a periodic problem with the
> user-facing error displaying smack dab in the middle of the page in a middle
> column of the report.
> Can anyone provide any help in resolving this intermittent issue?|||Thanks Dave. We in fact are aliasing the site and that config file does have
the real name. I'll change it to the alias and see if we still encounter the
problem. Thanks for the help!