Connection Timeout Error

Hi All,

I have created a Windows Service to process huge amount of data using Asynchronous Multi-threaded architecture using delegates. I have set the connection pool size in the connection string as follows.

In the service, I am creating 'n' number of threads and trying to process the data. It is processing the data initially and it will throuw the following error:

"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 in use and max pool size was reached"

I have checked the connection pool status and found the connections are in 'Sleep' status.

Please give your suggestions to solve this issue.

Thanks in Advance,