We have a strange big problem these days. We have a dnn 435 site which hosted about 100 portals. When visited ,it display error messages:

"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 run sp_who2 in sql server 2000,it display about 200 connection process, most of these process are made by this dnn site ,and the status are all "sleeping".

     After I modified web.config ,add this line into connectstring :  max pool size= 300,  The site works,but a few hours it crashes again.

     We do have many customer modules in this site ,but all of them are using the same data access approach like other dnn modules. I think it may due to connection leak.  But I cann't find where it is .  Any sugguestion ?

      Thanks!

---

Over 20 + professional dnn modules for News Article, Store, Video Gallery, Photo Gallery, Ultra Flash Player,YouTube Video, Image Slide show, Skin Chameleon and much more from DnnModule.com

I add "Pooling=false" in web.config ,solve this problem.  But ,it's so awkwarded because I cann't use connection pool anymore.

---

Over 20 + professional dnn modules for News Article, Store, Video Gallery, Photo Gallery, Ultra Flash Player,YouTube Video, Image Slide show, Skin Chameleon and much more from DnnModule.com