force reload of application from asp.net

From: matt (groups_NOSPAM__at_hitscricket.com)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 14:58:13 -0000

Hi,

We have an ASP.net application that sporadically fails with a strange
problem regarding the Max number of pooled connections being reached for the
database. I am currently in the process of tracking down the root cause of
this problem, although this is proving very difficult, I am as sure as I can
be (99.99%) that all my connections are closed as I have extensively
debugged this and now have all db connections managed internally to ensure
there are no connections which are not closed and thus cause this problem.
This problem has only occurred since we moved to a new dedicated server for
this application, although maybe it has only been highlighted now. Also
strange is that the requests that seem to occur at the same time as this
error are generally using the IP address of our site (which is not setup to
serve pages in our system, although will produce an asp.net generated
message), not for the domain name which we would expect all valid requests
to come in on. Any ideas on this appreciated, but my main question is.....

The problem I have currently is that when this error occurs it means no
connections to the database can be made, and as such no pages can be served,
all content is database generated. When the error occurs, we have
notifications setup so that we can restart the application, usually just
resaving web.config. What I would like to be able to until I can actually
trace the real cause of the problem, is be able to restart the asp.net
application when this error is detected. I have tried using
application.Dispose() which doesn't do what I am looking for. At the moment
the only approach I can see is "touching" the web.config file from my
asp.net application, which should ensure the application reloads, however
this seems a rather ugly way of achieving the result I am looking for.

Any help much appreciated.

Thanks,

Matt

Relevant Pages

  • Re: How can I open an SQL database and be the only one who has access to it?
    ... you can determine how SS permits access to your server. ... SINGLE_USER allows one user at a time to connect to the database. ... controlled by the termination clause of the ALTER DATABASE statement. ... To allow multiple connections, the database must be changed to ...
    (microsoft.public.data.ado)
  • Re: ORA-12518, 04030 errors after 9i-10G upgrade.
    ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... This did not solve problems so bounced database and decreased SGA to ... out of process memory errors. ...
    (comp.databases.oracle.server)
  • Re: ORA-12518, 04030 errors after 9i-10G upgrade.
    ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... out of process memory errors. ... that Oracle is having issues with OS resources. ...
    (comp.databases.oracle.server)
  • Re: ORA-12518, 04030 errors after 9i-10G upgrade.
    ... New server has 6GB ram. ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... This did not solve problems so bounced database and decreased SGA to ...
    (comp.databases.oracle.server)
  • Re: Proper Database Connection Cleanup
    ... but I think two of them have a database query in them. ... Public Sub ConnectToDB2(byref XCmd, byref YRS, byRef Conn) ... Set ObjRS = ObjCmd.Execute ... from DB connections in my code or from something else? ...
    (microsoft.public.scripting.vbscript)