DAAB ( sqlhelper ) Problem

Hi,

i am using sql 2000 and VS2005 ASP.NET 2.0

i have a problem using sqlhelper although i didn't notice it before (i've use it a lot)

the problem summarize as increasing of the connection (mayb 50+ for one user) which results in an pool size "Overflow"

i navigated the net i found many people speaking of an alternative from microsoft.

- i would like to know more information about the problem and

- is it the best alternative or not?

- and what is the best alternative?

thanx in advance

i would be pleased if you provide me with information

When using the DAAB to create datareaders, the default behavior is that the DAAB will create the connection from a connectionsting and when you have fully iterated over the datareader, the connection will automatically close. this occurs because the daab uses the commandbehavior of: CloseConnection

http://msdn2.microsoft.com/en-us/library/system.data.commandbehavior.aspx

Since you're leaking connections, you must be doing something to open these connections yourself and you will need to make sure that you close the connections when you are done with them.

TheEnterprise Library supercedes the DAAB, but switching to it will likely not solve your problem as you have a connection leak somewhere that you will really need to find in your code.