This post originated from an RSS feed registered with .NET Buzz by Paschal. Original Post: DAL rest in peace Feed Title: help.net Feed URL: http://www.asp.net/err404.htm?aspxerrorpath=/pleloup/Rss.aspx Feed Description: .Net for mankind ! Latest .NET Buzz Posts Latest .NET Buzz Posts by Paschal Latest Posts From help.net

I wrote some posts regarding the General Network error and I am still not sure to find a right answer to this important issue.

OK the only solution which seems to work pretty well is to set pooling to false in the connection string.

Yes, damn right but his has some performances consequences. So after some quick investigations, I realized that most of my projects are built using DAL (Microsoft Data Application Block v2).

This is an impressive SQL helper and I really dream to have something like that embedded in Whidbey.

After some tests it seems for me to be the culprit for all the General Network errors I can have. The weird problem here is the error show itself only in production environment with SQL server independent from the Web server.

Everything is ok on my local machine with all software required in one place.

Microsoft If I am right decided to not support anymore the DAL as it is. I know that a version 3 exist here (I think it's in GDN).

I have a look at the code and it's quite complex, as expected from MS.

So sadly I will have to abandon the joy of using the DAL, having no time to fuss with errors on production servers.

I will probably anyway writes a (basic) SQL helper for my needs based on the experience I got with the DAL. Well the not-so funny part will be to change all current DAL plumbing to the new helper.

So DAL rest in peace unless someone volunteer to debug you.