MTS and Oracle --Sessions at oracle not being killed

[Guest_imported]

Hi,
I am developing a COM+ application using VB which speaks to an oracle stored procedure running on a system(win 2000 server) where i have my MTS.I have installed oracle server 7.3 on a different system.The COM+ application Transaction property is not enabled and the application is working fine.
But the Oracle session is not being killed after each call that i make , even after i kill the Connection in my application.I am using Microsoft ODBC driver for oracle.
Can anybody help me.

Thanks in advance

Regards
Khan

 

[SemperFiDownUnda]

When a component under the control of a Connection Pool Manager (CPM) like MTS asks for a connection then releases it the connection is not really released. The CPM hold on to the connection incase another object requests a connection with the same profile (Same UserID,Password, Database, etc) and hands them the already connected connection thus speeding up database access. Normally this is just fine. MTS will slowly drop connections if no objects are requesting them or if it is getting more requests for connections with a different profile where it might then purposely close down a connection to open it back up with a the new profile.

Hope this helps

 

[SemperFiDownUnda]

When a component under the control of a Connection Pool Manager (CPM) like MTS asks for a connection then releases it the connection is not really released. The CPM hold on to the connection incase another object requests a connection with the same profile (Same UserID,Password, Database, etc) and hands them the already connected connection thus speeding up database access. Normally this is just fine. MTS will slowly drop connections if no objects are requesting them or if it is getting more requests for connections with a different profile where it might then purposely close down a connection to open it back up with a the new profile.

Hope this helps

Oh look here to see a similar explantion I've given

thread330-327996