Re: Database Driven Web Pages hang due to loss of Connection Objects
From: Carroll P. MacDonald (!0000_at_!00.000)
Date: 02/17/04
- Next message: joe: "Web Server for Remote Desktop Web Connection"
- Previous message: AiPing: "Installing SQL Reporting Services on IIS6 machine with Sharepoint"
- In reply to: This is Lynnette: "Database Driven Web Pages hang due to loss of Connection Objects"
- Next in thread: doug: "Re: Database Driven Web Pages hang due to loss of Connection Objects"
- Reply: doug: "Re: Database Driven Web Pages hang due to loss of Connection Objects"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 17 Feb 2004 00:58:15 -0400
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@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
- Next message: joe: "Web Server for Remote Desktop Web Connection"
- Previous message: AiPing: "Installing SQL Reporting Services on IIS6 machine with Sharepoint"
- In reply to: This is Lynnette: "Database Driven Web Pages hang due to loss of Connection Objects"
- Next in thread: doug: "Re: Database Driven Web Pages hang due to loss of Connection Objects"
- Reply: doug: "Re: Database Driven Web Pages hang due to loss of Connection Objects"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
