Database Driven Web Pages hang due to loss of Connection O..

It happens to everyone who is running ASP... Quick fix:

I have had a similar problem in the past and a very quick fix that works for
this is:

Using "Scheduled Tasks" I created 3 entries that "Reset" IIS every 8 Hours.
You will find IISReset here: C:\WINNT\system32 and run "iisreset.exe" It
takes about 35 to 45 seconds each time it resets IIS but it works and it's
Free. Just create a "New Task" for each time you want it to run.

One other thing you may want to consider is RamBooster
(http://www.sci.fi/~borg/rambooster/download.htm), I have it set to optimize
my Ram when ever it runs below 125 megabytes of free ram. It refreshes your
ram and releases ram that is no longer in use... it works and it's also
Free.

--


Thank you for your time and have a great day,

Carroll P. MacDonald
<a style='text-decoration: underline;' href="http://www.pegusisfreeware.com/" target="_blank">http://www.pegusisfreeware.com/</a>


"This is Lynnette" <anonymous DeleteThis @discussions.microsoft.com> wrote in message
news:0A19D5D5-A084-470A-A6F4-6D7097356F8D@microsoft.com...
 > Hello!
 >
 > I support an intranet which runs on IIS and has many .asp pages whose data
comes from various Access Databases.
 >
 > Every now and then (used to be every few days, but today it's happened
three times already), all the pages using the databases hang. Not all the
pages use the same database, but all the databases are Access 2000.
 >
 > I think this might be happening because some of these web sites don't
close all their connection objects. When I recycle the server, everything
works fine for awhile.
 >
 > Does this sound reasonable?
 > Is there any way I can tell for sure?
 >
 > I plan to try and go through each page and correct the problem, but in the
meanwhile I'm trying to find a short term solution - besides recycleing the
server. Is there any way to return the connections to the pool other than
turning off the power?
 >
 > Thanks so much for the help!
 > Lynnette<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database Driven Web Pages hang due to loss of Connection O.. 

A scheduled task to fix the problem? How is that a fix? I
don't think anybody would want to recycle a production
webserver every 8 hours.

I would try and get to the root of the problem. Look at
the code...close the objects. Are there errors in the
event log? Do you have the latest Jet drivers? Have you
tried running IISSTATE when it happens? Are you opeing
the databases directly from the server in Access when the
website is trying to access them?

iisfaq.com/iisstate next time it happens.

doug
 >-----Original Message-----
 >It happens to everyone who is running ASP... Quick fix:
 >
 >I have had a similar problem in the past and a very
quick fix that works for
 >this is:
 >
 >Using "Scheduled Tasks" I created 3 entries that "Reset"
IIS every 8 Hours.
 >You will find IISReset here: C:\WINNT\system32 and
run "iisreset.exe" It
 >takes about 35 to 45 seconds each time it resets IIS but
it works and it's
 >Free. Just create a "New Task" for each time you want
it to run.
 >
 >One other thing you may want to consider is RamBooster
 >(http://www.sci.fi/~borg/rambooster/download.htm), I
have it set to optimize
 >my Ram when ever it runs below 125 megabytes of free
ram. It refreshes your
 >ram and releases ram that is no longer in use... it
works and it's also
 >Free.
 >
 >--
 >
 >
 >Thank you for your time and have a great day,
 >
 >Carroll P. MacDonald
 >http://www.pegusisfreeware.com/
 >
 >
 >"This is Lynnette" <anonymous.DeleteThis@discussions.microsoft.com>
wrote in message
 >news:0A19D5D5-A084-470A-A6F4-
6D7097356F8D.DeleteThis@microsoft.com...
  >> Hello!
  >>
  >> I support an intranet which runs on IIS and has
many .asp pages whose data
 >comes from various Access Databases.
  >>
  >> Every now and then (used to be every few days, but
today it's happened
 >three times already), all the pages using the databases
hang. Not all the
 >pages use the same database, but all the databases are
Access 2000.
  >>
  >> I think this might be happening because some of these
web sites don't
 >close all their connection objects. When I recycle the
server, everything
 >works fine for awhile.
  >>
  >> Does this sound reasonable?
  >> Is there any way I can tell for sure?
  >>
  >> I plan to try and go through each page and correct the
problem, but in the
 >meanwhile I'm trying to find a short term solution -
besides recycleing the
 >server. Is there any way to return the connections to
the pool other than
 >turning off the power?
  >>
  >> Thanks so much for the help!
  >> Lynnette
 >
 >
 >.
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database Driven Web Pages hang due to loss of Connection O..