System.InvalidOperationException Timeout expired.

[dan]

The following exception has been thrown by a VB.NET program:

"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".

I couldn't find the troubleshooting information in HELP.

Who could give me a hint?
Thanks,
Dan

 

[Marina]

Sounds like you are not closing your connections after you use them, and
there is a connection leak.

 

[Cor Ligthert]

Dan,

A lot options, the standard answer you will get in the ADONET newsgroup is
if you dispose your connections everytime you do not need anymore. Keeping
the connection open is bad use in Adonet.

"Dispose" in this case as one as the exceptions because that is as far as I
understand used in Net 1.x to do some handling related to pooling.

When this is not the problem, that newsgroup is
microsoft.public.dotnet.framework.adonet
by the way,

I hope this helps?

Cor

 

[dan]

You were right. Thank you very much Cor! Dan

Dan,

A lot options, the standard answer you will get in the ADONET newsgroup is
if you dispose your connections everytime you do not need anymore. Keeping
the connection open is bad use in Adonet.

"Dispose" in this case as one as the exceptions because that is as far as I
understand used in Net 1.x to do some handling related to pooling.

When this is not the problem, that newsgroup is
microsoft.public.dotnet.framework.adonet
by the way,

I hope this helps?

Cor

 

[dan]

You were right. Thank you very much Marina!
Dan