Hello All

having a problem in sign-in page, where i am using the best
of the sql server and recommanded connection string for sql 2000
(default) in vs.net 2003 1.1 as framework

here is the message...
========================================
Timeout expired. The timeout period
elapsed prior to obtain a connection
from the pool. This may have occurred
because all pooled connection were
in use and max pool size was reached.
========================================

when i click on signin button, i have created a dll which is has
a DBConnection class which is called to connect to the SQL
there i am using SP which takes 2 params UN and PWD.
conn string is written in web.config of the app.

I using the basic conn string like server, User Id, Inital Catalog and pwd. just these 4 properties. when i got this error only 4 person
were logging in at the same time.

so, let me know how to fix this ang get over ride of this problem.
hope to see your response as soon.

With Regards,
Raghavendra Mudugal

__________________
With Regards,
Raghavendra Mudugal

Hi,

I was getting the same error message. My particular problem was created because I was not closing a connection in a repeater. Closing the connection resolved the problem immediately. You can actually view the open connections while running the sign-in page by typing the following code into Query Analyzer:

EXEC sp_who

Hope this helps.

Hello,

Closing the connection, this is my first step I am doing after DB work is finished. As we all now OPEN connection as lately as possible and CLOSE connection as early as it can be. This is taken care by me in the early
stage itsself.

Well, I have know idea how to get rid of this. If you have any alternate.
Let me know

And, Thank you for replying me back.


With Regards,
Raghavendra Mudugal