ASP.NET 2.0, VB, SQLServer: The connection was not closed.

[Steve Kiss]

Hello. I have a asp.net 2.0 website that uses SqlServer as a database. I use the basic provider architecture for a custom module. For some reason I get the following error:

Exception Details: System.InvalidOperationException: The connection was not closed. The connection's current state is open.

Unfortunately, this isn't very descriptive. Does someone know what this means?

Thank you

[TRScheel]

Hello. I have a asp.net 2.0 website that uses SqlServer as a database. I use the basic provider architecture for a custom module. For some reason I get the following error:

Exception Details: System.InvalidOperationException: The connection was not closed. The connection's current state is open.

Unfortunately, this isn't very descriptive. Does someone know what this means?

Thank you

Well, i doubt this is going to be of much help, but it literally means one of your sql connections was not closed.

The object has a .Close() function that should be called.

[Steve Kiss]

Well, i doubt this is going to be of much help, but it literally means one of your sql connections was not closed.

The object has a .Close() function that should be called.

Thank. That was the problem. I assumed the following would close the connection automatically:

returnReader = command.ExecuteReader( _
CommandBehavior.CloseConnection)

It doesn't! I had to explicitly close it.

Thank you