Classic ASP Discussion - Help : System resource exceeded

Print Page | Close Window

Help : System resource exceeded

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=10056
Printed Date: 31 March 2026 at 1:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Help : System resource exceeded

Posted By: worldwide1504
Subject: Help : System resource exceeded
Date Posted: 19 April 2004 at 4:59pm

Microsoft OLE DB Provider for ODBC Drivers error '8007000e'

[Microsoft][ODBC Microsoft Access Driver] System resource exceeded.
/worldwide1504/Default.asp, line 13

I got that error today. I didnt change anything in the code and it worked fine earlier. What does that mean?

Replies:

Posted By: MadDog
Date Posted: 19 April 2004 at 5:16pm

That error means that your server ran out of memory.

The following reasons could be why:

You (or someone else on your servers) do not close the database connections
You (or someone else on your servers) are creating objects and not setting them to Nothing

-------------
http://www.iportalx.net" rel="nofollow">

Posted By: worldwide1504
Date Posted: 19 April 2004 at 6:39pm

What if by fixing those two, it still doesnt work?

Posted By: MadDog
Date Posted: 19 April 2004 at 6:44pm

Yes. Or it could be your code.

-------------
http://www.iportalx.net" rel="nofollow">

Posted By: worldwide1504
Date Posted: 19 April 2004 at 6:48pm

Turns out I am getting HTTP/1.1 500 Server Error on all of my pages that dont have ASP code.

Posted By: pmormr
Date Posted: 19 April 2004 at 8:59pm

restart IIS

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/

Posted By: Semikolon
Date Posted: 20 April 2004 at 1:37pm

if the memory is filled up, the best solution is to restart the whole server..

if you are on a shared server, you will ALWAYS (with the current technologies) get problems like that

Posted By: pmormr
Date Posted: 20 April 2004 at 10:10pm

i just remembered something... i'm pretty sure that once your application terminates it drops all resources used by objects. It was in a book i was reading somewhere... still it's always a really really good idea to free up the memory at the end of your program (or for that matter, MS wrote some ASP tips and tricks... it says to close and set your object to nothing as soon as your done using it... and that makes perfect sense) Anyway, it's not a good idea for a server running windows to be on all the time... it still has memory leaks and needs to be restarted every once and awhile

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/

Posted By: Semikolon
Date Posted: 21 April 2004 at 9:42am

ya it closes all objects and set them to nothing automatcally IN MOST CASES.. at least that's what I have heard..

but it's anyways good coding practice to close connections to databases, texfiles etc and set the objects to nothing at the end.. and before every single response redirect