aspnet_wp.exe not killed in Oracle connection session

[Steve Foo]

I have been posting this question in google group, EE, and Oracle OTN forum and still no cannot find a suitable solution for it.

I have contacted Singapore Microsoft support regarding the problem .Unfortunately they are not able to help me and eventually direct me here

i'm not 100% sure if this problem is due to ODP.net provider or asp.net IIS setting

Hopefully Microsoft Experts here can help me up. Thx

Introduction
=================================================
We are using ODP.net (version 9.2.0.4.01) as data provider for Oracle
in our dotnet app. Currently we are using Microsoft.NET Framework 1.1
(VS.net IDE 2003) in our C# project.

Problem Description
=================================================
One thing I feel strange is that every time the ASPX application ended
(closed and disposed the connection object), the Oracle session
connection never killed.

These eventually bring us to oracle connections used up situation :(

Based on my experiment, The problem will not occur while running
Window app or ASPX app using IIS 6 (w3wp.exe) in Window 2003.

Since we r using the same data access base classes for Window and
Web apps, there is not possible for the error to happen alone in web App.
We did close and dispose the connection object as shown in oracle ODP.net
samples(in ' Using block ').

They do happen in WinXP pro and Win2k Pro for IIS 5.X (haven't tried
in win2k server).

I have checked the Oracle Enterprise Management Console which showing
that the aspnet_wp processes are running even closing up any ASPX web app
browser window and VS.net IDE 2003.

Some Temporary Solutions
==================================================

By referring to the Google forum, in order to kill this "Never ended"
oracle connections, what I need to do is to restart the WWW service in
Window Component Services.

But I do not think this is a practical solution in order to solve the
problem in real time.

By refering to discussion in Oracle OTN forum, some of the guys said
turning off the connnection pool will solve the problem. but again do u
think this is pratical in operating environment ?

I suspect this are some configuration errors in asp.net state
management or IIS settings. I tried to turn off the session in web.config
but the problem is still there. i wonder if i should do anything in the
processmodel setting in machine.config .

Finally
=======

Can any expert provide me a suggestion regarding the problem?
I strongly believe that there sure have a solution for it since many ppl have inplemented .Net framework project in win2k server for the past few years.

Hopefully my description is clear enough to well shape the problem.

Have a nice day. Thanks.

Best Regards,

Steve FOO

[John Oakes]

Are you specifically disabling connection pooling in your connection string?
Make sure you specifically disable pooling in the string if you want them to
not stick around (pooling = false.)

-John

"Steve Foo" <fo*********************@yahoo.com> wrote in message
news:36**********************************@microsof t.com...

I have been posting this question in google group, EE, and Oracle OTN forum and still no cannot find a suitable solution for it.
I have contacted Singapore Microsoft support regarding the problem ..Unfortunately they are not able to help me and eventually direct me here.
i'm not 100% sure if this problem is due to ODP.net provider or asp.net IIS setting .
Hopefully Microsoft Experts here can help me up. Thx

Introduction
=================================================
We are using ODP.net (version 9.2.0.4.01) as data provider for Oracle
in our dotnet app. Currently we are using Microsoft.NET Framework 1.1
(VS.net IDE 2003) in our C# project.

Problem Description
=================================================
One thing I feel strange is that every time the ASPX application ended
(closed and disposed the connection object), the Oracle session
connection never killed.

These eventually bring us to oracle connections used up situation :(

Based on my experiment, The problem will not occur while running
Window app or ASPX app using IIS 6 (w3wp.exe) in Window 2003.

Since we r using the same data access base classes for Window and
Web apps, there is not possible for the error to happen alone in web App.
We did close and dispose the connection object as shown in oracle ODP.net
samples(in ' Using block ').

They do happen in WinXP pro and Win2k Pro for IIS 5.X (haven't tried
in win2k server).

I have checked the Oracle Enterprise Management Console which showing
that the aspnet_wp processes are running even closing up any ASPX web app
browser window and VS.net IDE 2003.
Some Temporary Solutions
==================================================

By referring to the Google forum, in order to kill this "Never ended"
oracle connections, what I need to do is to restart the WWW service in
Window Component Services.

But I do not think this is a practical solution in order to solve the
problem in real time.

By refering to discussion in Oracle OTN forum, some of the guys said
turning off the connnection pool will solve the problem. but again do u
think this is pratical in operating environment ?

I suspect this are some configuration errors in asp.net state
management or IIS settings. I tried to turn off the session in web.config
but the problem is still there. i wonder if i should do anything in the
processmodel setting in machine.config .

Finally
=======

Can any expert provide me a suggestion regarding the problem?
I strongly believe that there sure have a solution for it since many ppl have inplemented .Net framework project in win2k server for the past few
years.
Hopefully my description is clear enough to well shape the problem.

Have a nice day. Thanks.
Best Regards,
Steve FOO

[Kevin Spencer]

ODP.Net is an Oracle product. As such, your best information would have to
come from Oracle. Microsoft manufactures database drivers that can connect
to Oracle, but that isn't one of them.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Steve Foo" <fo*********************@yahoo.com> wrote in message
news:36**********************************@microsof t.com...

I have been posting this question in google group, EE, and Oracle OTN forum and still no cannot find a suitable solution for it.
I have contacted Singapore Microsoft support regarding the problem ..Unfortunately they are not able to help me and eventually direct me here.
i'm not 100% sure if this problem is due to ODP.net provider or asp.net IIS setting .
Hopefully Microsoft Experts here can help me up. Thx

Introduction
=================================================
We are using ODP.net (version 9.2.0.4.01) as data provider for Oracle
in our dotnet app. Currently we are using Microsoft.NET Framework 1.1
(VS.net IDE 2003) in our C# project.

Problem Description
=================================================
One thing I feel strange is that every time the ASPX application ended
(closed and disposed the connection object), the Oracle session
connection never killed.

These eventually bring us to oracle connections used up situation :(

Based on my experiment, The problem will not occur while running
Window app or ASPX app using IIS 6 (w3wp.exe) in Window 2003.

Since we r using the same data access base classes for Window and
Web apps, there is not possible for the error to happen alone in web App.
We did close and dispose the connection object as shown in oracle ODP.net
samples(in ' Using block ').

They do happen in WinXP pro and Win2k Pro for IIS 5.X (haven't tried
in win2k server).

I have checked the Oracle Enterprise Management Console which showing
that the aspnet_wp processes are running even closing up any ASPX web app
browser window and VS.net IDE 2003.
Some Temporary Solutions
==================================================

By referring to the Google forum, in order to kill this "Never ended"
oracle connections, what I need to do is to restart the WWW service in
Window Component Services.

But I do not think this is a practical solution in order to solve the
problem in real time.

By refering to discussion in Oracle OTN forum, some of the guys said
turning off the connnection pool will solve the problem. but again do u
think this is pratical in operating environment ?

I suspect this are some configuration errors in asp.net state
management or IIS settings. I tried to turn off the session in web.config
but the problem is still there. i wonder if i should do anything in the
processmodel setting in machine.config .

Finally
=======

Can any expert provide me a suggestion regarding the problem?
I strongly believe that there sure have a solution for it since many ppl have inplemented .Net framework project in win2k server for the past few
years.
Hopefully my description is clear enough to well shape the problem.

Have a nice day. Thanks.
Best Regards,
Steve FOO