Help: I get an error and i don't have solution for it

[wdw]

Can someone give a solution for this problem.

Additional information: 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.


thanks

 

[Robby]

What are you doing that causes the timeout?

 

[wdw]

I get the timeout on my sql connection.
In my app i have a autocompletecombobox. On a indexchange the app is getting a description wich belongs to the code that is typed in the combobox. It happens when the index changes many times in a very short period.

I hope you can help me now.

thanks already

 

[dusans]

If you are using new connection each time, check if previous is closed. If you are using same connection each time, open it once and use it always. If this didt solved problem try adding " Pooling=false " at the end of the connection string.
Or maybe adding " Connection Lifetime = 0 " to connection string will solve the problem.

 

[wdw]

oke thanks for your solution