Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 589
  • Last Modified:

RunTime TimeOut Error in ASP.NET

I have created an invoice form which works fine for small orders... there is a high degree of customization in the form which takes processing time. WHen I try to print a large order I sometimes get a runtime with the following detail...
-------------------
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.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.InvalidOperationException: 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.
-----------------------
How can i fix this urgent problem?

Thank you.
0
prichar
Asked:
prichar
  • 3
1 Solution
 
YZlatCommented:
add "max pool size" property to your connection string

if that won't work, then add the following at the top of the page causing problems:
<% Server.ScriptTimeout = 600 %>
0
 
Ashley BryantSenior Software EngineerCommented:
Sounds like you're opening new connections for every recordset your calling from your database and not closing those connections.  Can you post any code samples for us to look at?
0
 
YZlatCommented:
try setting max pool size to 100
0
 
YZlatCommented:
This is actualy a bug in VS.NET 2003. Close VS.NET and restart IIS, then use the application from the browser. That should get rid of the problem
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now