#100 Timeout expired
When I use the following Connection String:
"Data Source=MSS003;database=Midwest;user
ID=User;password=pass"
I receive the following error message after it runs awhile:
"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."
When I change the connection string to:
"Data Source=MSS003;database=Midwest;user
ID=User;password=pass;pooling=false"
I no longer receive the error message.
I would like to use the connection pooling as it is
expensive to create a new object everytime rather than
just pulling it from a pool. Is there a way I can
track this down here? Is there any other information
you require to look into this?
Brandon
