471,306 Members | 838 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,306 software developers and data experts.

C# Web Service in IIS Stops Connecting to Oracle (via ADO.NET) Over Time

C# Web Service in IIS Stops Connecting to Oracle (via ADO.NET) Over Time

I have a Web Service, written in C#, published on
a Windows XT Web Server under IIS, which
repeatedly connects to an Oracle 9x database via
ADO, processes, disconnects from the database, and
exits.

The Web Service is triggered by our Tibco
messaging system; in our test environment, it is
invoked every ten minutes. The trouble is, it will
run for hours -- Connect, Process, Disconnect,
Exit -- then, eventually it will fail on the
Connect: it will throw an exception while trying
to execute the OracleConnection.Open method (if I
remember correctly, I don't have the output with
me at the moment), and I am not yet getting any
specific Oracle error message or number. All
connection attempts after that point fail
immediately.

If we restart IIS, it returns to normal running
(for a while, that is.)

Also, another Web service, which runs serially after
the failing one and has been running successfully all
this time, will also start failing in its connections
to Oracle (once the other Web Service has failed.)

There have been instances where the 2nd Web Service
has been the one to initiate the failures, seeming
to eliminate one specific Service as the problem.

My question: assuming that the Web Services'
Connects (Opens) are all paired with associated
Disconnect (Closes), is there something (some
resource, perhaps) in IIS or Oracle which can be
consumed over time, or iterations? It seems as if
the Web Service, although it exits, is running out
of something or corrupting something, which can
only be repaired by restarting IIS. And the effect
appears to be IIS-wide -- at least within the default
application space -- since the other process
fails (database connects) after the one failure.

Would anyone have any ideas?

Thanks,

GHuston
Nov 8 '07 #1
0 3036

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Terry Olsen | last post: by
dmjpro
3 posts views Thread by dmjpro | last post: by
8 posts views Thread by =?Utf-8?B?RGF2aWQrKw==?= | last post: by
8 posts views Thread by DF Dev | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.