Hi,
We have developed an Web application in ASP.NET with C#
and we r using SQL Server 2000. We get the Timeout expired
error, when more than 300 concurrent users hit the site.
I hagone thru the code, to check whether all the
Connections are closed. everything is perfect, and infact
the connections are closed in the finally block.
Please, help me out ASPAP.
Error Details:
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.
at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCon
nection(SqlConnectionString options, Boolean&
isInTransaction)
at System.Data.SqlClient.SqlConnection.Open() 3 11069
Hi Kamalanathan,
This might be a far shot, but check to see if you are disposing off the
connection object. I doubt if the connection object is returned to the pool
if you just close the connection. So long as you hold a reference to a
connection, it will remain out of the pool.
Furthermore, you would not need to use the sqlConnectionPoolManager as
connection pooling is inherent in ADO when you use SqlConnection object. If
I remember right, it creates a connection pool by default of 100 connection
objects.
Hope this helps,
Regds,
Diwakar
"Kamalanathan T." <vi*************@yahoo.com> wrote in message
news:01****************************@phx.gbl... Hi, We have developed an Web application in ASP.NET with C# and we r using SQL Server 2000. We get the Timeout expired error, when more than 300 concurrent users hit the site.
I hagone thru the code, to check whether all the Connections are closed. everything is perfect, and infact the connections are closed in the finally block.
Please, help me out ASPAP.
Error Details:
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. at System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCon nection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open()
Hi Diwakar,
Thanks for immediate reply.
If I call the Dispose() method, after the connection.Close
(), will the problem gets resolved?
Regards,
Kamalanathan T. -----Original Message----- Hi Kamalanathan, This might be a far shot, but check to see if you are
disposing off theconnection object. I doubt if the connection object is
returned to the poolif you just close the connection. So long as you hold a
reference to aconnection, it will remain out of the pool.
Furthermore, you would not need to use the
sqlConnectionPoolManager asconnection pooling is inherent in ADO when you use
SqlConnection object. IfI remember right, it creates a connection pool by default
of 100 connectionobjects.
Hope this helps,
Regds, Diwakar "Kamalanathan T." <vi*************@yahoo.com> wrote in
messagenews:01****************************@phx.gbl... Hi, We have developed an Web application in ASP.NET with
C# and we r using SQL Server 2000. We get the Timeout
expired error, when more than 300 concurrent users hit the site.
I hagone thru the code, to check whether all the Connections are closed. everything is perfect, and
infact the connections are closed in the finally block.
Please, help me out ASPAP.
Error Details:
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. at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCon nection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open()
.
Yes. This should solve the problem.
-Diwakar
"Kamalanathan T." <vi*************@yahoo.com> wrote in message
news:06****************************@phx.gbl... Hi Diwakar,
Thanks for immediate reply.
If I call the Dispose() method, after the connection.Close (), will the problem gets resolved?
Regards, Kamalanathan T.
-----Original Message----- Hi Kamalanathan, This might be a far shot, but check to see if you are disposing off theconnection object. I doubt if the connection object is returned to the poolif you just close the connection. So long as you hold a reference to aconnection, it will remain out of the pool.
Furthermore, you would not need to use the sqlConnectionPoolManager asconnection pooling is inherent in ADO when you use SqlConnection object. IfI remember right, it creates a connection pool by default of 100 connectionobjects.
Hope this helps,
Regds, Diwakar "Kamalanathan T." <vi*************@yahoo.com> wrote in messagenews:01****************************@phx.gbl... Hi, We have developed an Web application in ASP.NET with C# and we r using SQL Server 2000. We get the Timeout expired error, when more than 300 concurrent users hit the site.
I hagone thru the code, to check whether all the Connections are closed. everything is perfect, and infact the connections are closed in the finally block.
Please, help me out ASPAP.
Error Details:
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. at System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCon nection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open()
. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Silvia |
last post by:
I have a application web and when execute this for a long
time generated this error:
Server Error in '/RAIMServer' Application.
-----------------------------------------------------------...
|
by: Guoqi Zheng |
last post by:
Dear sir,
I keep getting the following errors on one of my sites after clicking for
many times.
Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This...
|
by: Chris Langston |
last post by:
I have a Web Server running IIS 5 or 6 on Windows 2K and Windows 2003 Server
that is experiencing strange shutdown problems. We are using ASP.NET v1.1
and our application is written in VB.NET
...
|
by: Nevyn Twyll |
last post by:
I've been working on an asp.net application and everything's been great.
But suddenly, whether I'm tyring to use a database on my own machine, or on
my server, I'm getting a timeout when trying to...
|
by: UJ |
last post by:
We have recently started getting the following error message:
Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occurred because all pooled...
|
by: Jake K |
last post by:
I have a system timer that elapses every 10 seconds and must execute every
ten seconds. Basically every 10 seconds I need to insert into a table. The
following code, however, causes a "Timeout...
|
by: =?Utf-8?B?Y2FzaGRlc2ttYWM=?= |
last post by:
Hi,
I have recieved the following error in an application:
"Timeout expired. The timeout period elapsed prior to obtaining a
connection from the pool. This may have occured because all...
|
by: =?Utf-8?B?Sm9obiBTdGFnZ3M=?= |
last post by:
Hello,
Please read this all before giving an answer :) I'm doing some
troubleshooting on a web application that my company wrote. It's written in
asp.net 1.1. The error that the Event viewer...
|
by: anumsajeel |
last post by:
Hi,
Error Message:-
error connecting: Timeout expired. The timeout period elapsed prior to
obtaining a connection from the pool. This may have occurred because all pooled
connections were...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
| |