I have previously migrated 3 small websites that I use through our intranet into one directory with a shared web.config file because they all connect to the one database. So there are 3 folders under the website with the ASP.net files for each "mini-website" and 1 web.config file shared between them. They also each use a different dataset to connect to and update the database.
The site also has it's own app pool and doesn't use the default app pool on IIS.
Since moving them all to a shared website with 1 web.config file I have have been getting the following error after users complete around 10 inserts into the database (most of the screens are data entry screens);
"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."
This error is occuring at the line - Me.adapter.Fill(dataTable)