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.
<
add name="DBConnection" connectionString="Persist Security Info=False;database=TestBD;server=WIRECOM;Connect Timeout=30;user id=TestUser; pwd=Test;Pooling=true;Max Pool Size=20"/>
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,