Internal .Net Framework Data Provider error 1

[Andrew]

Win2k3
IIS6
..NET 2.0

In my ASP.NET 2.0 app I create an open an SQL connection in the page's
constructor and call objSQL.Dispose( ) in the destructor. The SQLConnection
object is a class member of the page. Here's the destructor code:

/// Destructor
~Officer()
{
if( m_objConn != null )
m_objConn.Dispo se();
}
/// End Destructor
When running this particular page through some testing I get the following
exception in the destructor at the "m_objConn.Disp ose();" line:

System.InvalidO perationExcepti on was unhandled
Message="Intern al .Net Framework Data Provider error 1."
Source="System. Data"
StackTrace:
at System.Data.Pro viderBase.DbCon nectionInternal .PrePush(Object
expectedOwner)
at
System.Data.Pro viderBase.DbCon nectionPool.Put Object(DbConnec tionInternal
obj, Object owningObject)
at
System.Data.Pro viderBase.DbCon nectionInternal .CloseConnectio n(DbConnection
owningObject, DbConnectionFac tory connectionFacto ry)
at System.Data.Sql Client.SqlConne ction.Close()
at System.Data.Sql Client.SqlConne ction.Dispose(B oolean disposing)
at System.Componen tModel.Componen t.Dispose()
at Officer.Finaliz e() in c:\sys\projects \AddOfficer.asp x.cs:line 46

When I stop debugging VS2k5 pops up the JIT debugging dialog stating an
unhandled exception occurred in w3wp.exe.

1) Is this a bug?
2) Do I need a try/catch in a destructor? Is it good programming practice?
3) Why is this happening?
4) What is the meaning of life?
Any help is appreciated. TIA

Andrew

[Jeff Dillon]

You should never hold onto a connection for the life of a page. Open and
close the connection each time you need to. Let Connection Pooling work for
you.

Jeff

"Andrew" <andrew_test(do nt spam its not cool)@hotmail.c om> wrote in message
news:%2******** *******@TK2MSFT NGP05.phx.gbl.. .

Win2k3
IIS6
.NET 2.0

In my ASP.NET 2.0 app I create an open an SQL connection in the page's
constructor and call objSQL.Dispose( ) in the destructor. The
SQLConnection object is a class member of the page. Here's the destructor
code:

/// Destructor
~Officer()
{
if( m_objConn != null )
m_objConn.Dispo se();
}
/// End Destructor
When running this particular page through some testing I get the following
exception in the destructor at the "m_objConn.Disp ose();" line:

System.InvalidO perationExcepti on was unhandled
Message="Intern al .Net Framework Data Provider error 1."
Source="System. Data"
StackTrace:
at System.Data.Pro viderBase.DbCon nectionInternal .PrePush(Object
expectedOwner)
at
System.Data.Pro viderBase.DbCon nectionPool.Put Object(DbConnec tionInternal
obj, Object owningObject)
at
System.Data.Pro viderBase.DbCon nectionInternal .CloseConnectio n(DbConnection
owningObject, DbConnectionFac tory connectionFacto ry)
at System.Data.Sql Client.SqlConne ction.Close()
at System.Data.Sql Client.SqlConne ction.Dispose(B oolean disposing)
at System.Componen tModel.Componen t.Dispose()
at Officer.Finaliz e() in c:\sys\projects \AddOfficer.asp x.cs:line 46

When I stop debugging VS2k5 pops up the JIT debugging dialog stating an
unhandled exception occurred in w3wp.exe.

1) Is this a bug?
2) Do I need a try/catch in a destructor? Is it good programming
practice?
3) Why is this happening?
4) What is the meaning of life?
Any help is appreciated. TIA

Andrew

[Andrew]

Thanks for the connection pooling tip. However in this case I'm not sure
how it's relevant. More detail on the cause of the error and whether
destructors should have exception handling code would be helpful.

Thanks,
Andrew

"Jeff Dillon" <je********@hot mail.com> wrote in message
news:eK******** ******@TK2MSFTN GP02.phx.gbl...

You should never hold onto a connection for the life of a page. Open and
close the connection each time you need to. Let Connection Pooling work
for you.

Jeff

"Andrew" <andrew_test(do nt spam its not cool)@hotmail.c om> wrote in
message news:%2******** *******@TK2MSFT NGP05.phx.gbl.. .

Win2k3
IIS6
.NET 2.0

In my ASP.NET 2.0 app I create an open an SQL connection in the page's
constructor and call objSQL.Dispose( ) in the destructor. The
SQLConnection object is a class member of the page. Here's the
destructor code:

/// Destructor
~Officer()
{
if( m_objConn != null )
m_objConn.Dispo se();
}
/// End Destructor
When running this particular page through some testing I get the
following exception in the destructor at the "m_objConn.Disp ose();" line:

System.InvalidO perationExcepti on was unhandled
Message="Intern al .Net Framework Data Provider error 1."
Source="System. Data"
StackTrace:
at System.Data.Pro viderBase.DbCon nectionInternal .PrePush(Object
expectedOwner)
at
System.Data.Pro viderBase.DbCon nectionPool.Put Object(DbConnec tionInternal
obj, Object owningObject)
at
System.Data.Pro viderBase.DbCon nectionInternal .CloseConnectio n(DbConnection
owningObject, DbConnectionFac tory connectionFacto ry)
at System.Data.Sql Client.SqlConne ction.Close()
at System.Data.Sql Client.SqlConne ction.Dispose(B oolean disposing)
at System.Componen tModel.Componen t.Dispose()
at Officer.Finaliz e() in c:\sys\projects \AddOfficer.asp x.cs:line 46

When I stop debugging VS2k5 pops up the JIT debugging dialog stating an
unhandled exception occurred in w3wp.exe.

1) Is this a bug?
2) Do I need a try/catch in a destructor? Is it good programming
practice?
3) Why is this happening?
4) What is the meaning of life?
Any help is appreciated. TIA

Andrew