FYI same here as greg, past two weeks or so. Usually only a few seconds

when was the last time anyone had the above error?

our webserver has aparently changed ip and is now on a 2003 box, just wondering if theres been any change in performance?

Here's my "discussion" with them so far...

-----Original Message-----
From: Alex Galbraith
Sent: 26 October 2006 15:06
To: 'Fasthosts Xtreme Support Team'
Subject: RE: 997372#LEUQNC Reply to your Enquiry (PLEASE DO NOT CHANGE SUBJECT)

-----Original Message-----
From: Alex Galbraith
Sent: 23 October 2006 15:31
To: 'Fasthosts Xtreme Support Team'
Subject: RE: 997372#LEUQNC Reply to your Enquiry (PLEASE DO NOT CHANGE SUBJECT)

Thank you for the prompt response. I understand the limitations, however is

it not possible for our site to be moved to a server with less ASP enabled

websites, therefore resolving or at least reducing the issue for us? We are

a non-profit organisation and cannot justify the cost of MSSQL for a site

with this level of traffic (relatively small). Anything you could do would

be VERY much appreciated?

Cheers

Alex

-----Original Message-----

From: Fasthosts Xtreme Support Team [mailto:Support@fasthosts.co.uk]

Sent: 23 October 2006 15:15

Subject: 997372#LEUQNC Reply to your Enquiry (PLEASE DO NOT CHANGE SUBJECT)

Dear Alex,

Thanks for contacting us with your support enquiry. I am afraid that this is

a limitation of the Access database driver, and not our system. Access was

never originally intended for use on the internet, and because of the way

the database engine is built, only a limited number of connections can be

made to the database driver on the server at any one time. Unfortunately,

because you are on a shared server, you are sharing the driver with every

other website on the server. During busy periods it is possible that various

other sites on the server are using the driver, which will result in the

"system resources exceeded" error. There is no way around this, so if this

is a major problem, I would recommend upgrading to a database designed to be

used on the internet, such as MySQL or MSSQL.

--

Matthew Gorton

Customer Support

Fasthosts Internet Ltd.

Fasthosts Support: http://www.fasthosts.co.uk/support

Your Fasthosts control panel: http://www.fasthosts.co.uk/login

From: Alex Galbraith
Sent: 23 October 2006 14:05
To: support@fasthosts.co.uk
Subject: www.sentfromhell.co.uk - JET Database Errors

A/C: n285513

Pin: 1831

Site: www.sentfromhell.co.uk

Hi,

I would like to raise a support ticket for an ongoing fault we have had with our site over the past few months. We are running a simple asp site with an ms access backend (this database is not large – currently 31mb. Regularly, sometimes for several minutes at a time, the entire site goes down with the following fault:

Microsoft JET Database Engine error '80004005'

System resource exceeded.

I have checked through all of my code to confirm that there are no instances where I do not close down result sets and connections at the end of a query. I have not found any. I can therefore only assume that this issue is being caused by another site on the same box. Can you please investigate the current setup on our server (which as I understand has recently been upgraded to 2003) and determine if there are any sites using an unreasonable amount of resources, or leaving large numbers of database connections open. If so can either they or we be moved to another physical box?

Many thanks

Alex Galbraith

nice.

Got the good old message twice today =[