Hi all,
i am using Sql Connection with SqlHelper class;
it is working fine with windows xp and MSDE; when i developed the
application and tried it with Sql server200+ windows 2003 it gives Error
message
"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 have given the MAX pool size =75
i have no clue to this problem , i want to know what is the possible
resoultions
with regards!
Anupam

Is it possible that you are not closing connections?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Anupam" <(E-Mail Removed)> wrote in message
news:3A780F7E-8B67-4596-A69E-(E-Mail Removed)...
> Hi all,
> i am using Sql Connection with SqlHelper class;
> it is working fine with windows xp and MSDE; when i developed the
> application and tried it with Sql server200+ windows 2003 it gives Error
> message
> "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 have given the MAX pool size =75
> i have no clue to this problem , i want to know what is the possible
> resoultions
> with regards!
> Anupam
>

This has been discussed many (many) times on this list. I suggest searching
the archives (google groups) or my web site for an article I wrote on
handling the connection pool.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Anupam" <(E-Mail Removed)> wrote in message
news:3A780F7E-8B67-4596-A69E-(E-Mail Removed)...
> Hi all,
> i am using Sql Connection with SqlHelper class;
> it is working fine with windows xp and MSDE; when i developed the
> application and tried it with Sql server200+ windows 2003 it gives Error
> message
> "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 have given the MAX pool size =75
> i have no clue to this problem , i want to know what is the possible
> resoultions
> with regards!
> Anupam
>

Bad conn. pooling architecture.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
__________________________________________________________


"Anupam" <(E-Mail Removed)> wrote in message
news:3A780F7E-8B67-4596-A69E-(E-Mail Removed)...
> Hi all,
> i am using Sql Connection with SqlHelper class;
> it is working fine with windows xp and MSDE; when i developed the
> application and tried it with Sql server200+ windows 2003 it gives Error
> message
> "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 have given the MAX pool size =75
> i have no clue to this problem , i want to know what is the possible
> resoultions
> with regards!
> Anupam
>

Hello Anupam:

Ensure that no codepaths in the application are leaking connections.
You would have to explicitly call the conn.Close() method.
Reduce the 'Connection LifeTime' paramter in your connection string.
Also check the number of the connections that your application is
using, probable increasing the Max Pool Size may be the answer.

HTH!
Skanda