IIS
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsSystem AdministrationIIS

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old December 4th, 2004, 12:10 PM
keitht keitht is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Posts: 16 keitht User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 m 56 sec
Reputation Power: 0
Urgent! Site running on Access MDB's down

I have a storefront running on the latest IIS with an Access MDB using an ODBC DSN. It also hits some assorted other dsn-less MDB connections.

It has been running fine for a year. All of sudden last week, all pages related to any access DB, simply time out. They just load forever. ANY access data source, even a test one I uploaded to make sure I wasn't going crazy, just didn't respond.

I tried all types of corrective actions, such as disconnecting the DSN's, backup MDB'S repairing the MDB's etc. to no avail. Then it fixed itself.

Now, again today, the site is out, database-wise. No explanation. Does anyone have an answer to this problem other than 'use SQL' (we're working on it).

The only external factor thats changed is a heavy spike in traffic. I have not mucked with any settings lately. My ISP is not available on weekends and I am losing money, please help..!

Reply With Quote
  #2  
Old December 4th, 2004, 04:30 PM
Doug G Doug G is online now
Grumpier Old Moderator
Dev Shed God 12th Plane (10500 - 10999 posts)
 
Join Date: Jun 2003
Posts: 10,713 Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level) 
Time spent in forums: 1 Month 1 m 54 sec
Reputation Power: 688
Perhaps something was changed or updated on the web server. Any errors in the event logs?
__________________
======
Doug G
======
"Hide, hide witch! The good folk come to burn thee. Their keen enjoyment hid behind their gothic mask of duty." -Mark Clifton

Reply With Quote
  #3  
Old December 4th, 2004, 04:33 PM
gavwvin gavwvin is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Posts: 185 gavwvin User rank is Corporal (100 - 500 Reputation Level)gavwvin User rank is Corporal (100 - 500 Reputation Level)gavwvin User rank is Corporal (100 - 500 Reputation Level)gavwvin User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 7 h 26 m 5 sec
Reputation Power: 5
I had problems with access... I found the database was bloating in size rapidly everytime a query was run, is that happening to you (and might that be the cause)?

Reply With Quote
  #4  
Old December 4th, 2004, 04:50 PM
keitht keitht is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Posts: 16 keitht User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 m 56 sec
Reputation Power: 0
Yeah it's a turkey. I have to reset my stats package every few days to deal with DB bloat (read: slowdowns)

It's really strange what's going on with my server. I tried putting a static index.html test page, and even that just does an infinite load.

I have thousands of static sub-pages on the site and they are all working fine. So can I assume that someone is doing a DoS on the index page?

I really wish my ISP guy wasn't away for the weekend this is driving me nuts, an article about my site just came out in a big magazine this week and it is NOT the time for a broken site!

Quote:
Originally Posted by gavwvin
I had problems with access... I found the database was bloating in size rapidly everytime a query was run, is that happening to you (and might that be the cause)?

Reply With Quote
  #5  
Old December 4th, 2004, 04:51 PM
keitht keitht is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Posts: 16 keitht User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 m 56 sec
Reputation Power: 0
I've just been using a third party stats generator (which are also inaccessible currently). I haven't a clue how to meaningful process the raw logs.

Quote:
Originally Posted by Doug G
Perhaps something was changed or updated on the web server. Any errors in the event logs?

Reply With Quote
  #6  
Old December 4th, 2004, 09:01 PM
Doug G Doug G is online now
Grumpier Old Moderator
Dev Shed God 12th Plane (10500 - 10999 posts)
 
Join Date: Jun 2003
Posts: 10,713 Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level) 
Time spent in forums: 1 Month 1 m 54 sec
Reputation Power: 688
Quote:
Originally Posted by keitht
I've just been using a third party stats generator (which are also inaccessible currently). I haven't a clue how to meaningful process the raw logs.

I meant the windows server event logs, not the web logs.

Reply With Quote
  #7  
Old December 5th, 2004, 04:45 AM
keitht keitht is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Posts: 16 keitht User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 m 56 sec
Reputation Power: 0
Oh, no I don't have access to those. It is a hosted package at an ISP, and unfortunatly the trade off with them is that because it's a small ISP, their service is great on weekdays, but they don't have 24/7 support.

Meanwhile I've got hundreds of dollars out the door..



Quote:
Originally Posted by Doug G
I meant the windows server event logs, not the web logs.

Reply With Quote
  #8  
Old December 5th, 2004, 09:27 PM
Doug G Doug G is online now
Grumpier Old Moderator
Dev Shed God 12th Plane (10500 - 10999 posts)
 
Join Date: Jun 2003
Posts: 10,713 Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level) 
Time spent in forums: 1 Month 1 m 54 sec
Reputation Power: 688
If you didn't change any code it sure sounds like a server-side issue.

Maybe a host with 24/7 support would have been a better choice

Reply With Quote
Reply

Viewing: Dev Shed ForumsSystem AdministrationIIS > Urgent! Site running on Access MDB's down


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway