Database Connections Version 7.7a
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=10158
Printed Date: 30 March 2026 at 1:50pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Database Connections Version 7.7a
Posted By: aysolaw5
Subject: Database Connections Version 7.7a
Date Posted: 26 April 2004 at 5:21pm
|
HI! My ISP provider READYHOSTING, had to take the following action so that it could unload my database connections, which allowed the forum to come up again. They segusseted that I should review my coding and make sure that my database connections are getting closed. So my question is... Where in the code can it be changed to make sure that the database connections are getting closed? Can a default timer can be added so that the DB closes when there is no activity? I'm using the the Access DB in this forum. Thanks in advance for your time and patience on this I'm a newbe to ASP. Cheers!!! aysolaw5
|
Replies:
Posted By: pmormr
Date Posted: 26 April 2004 at 5:30pm
|
this forum? as in WebWizForums? it probably isn't the forum, write them a letter and ask them if they're sure it's you ------------- Paul A Morgan http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/ |
Posted By: dpyers
Date Posted: 26 April 2004 at 6:09pm
|
There's no way to globally close all open connections, but they will time out eventually. Good programming practice dictates that you only open a db connection, or instantiate an object, just before you use it. Immediately upon finishing a task, you close the connection/set an object to "". Opening a connection or instantiating an object in the global.asa will also get you into trouble. Leaving connections/ojbects active tends to crash a well used site pretty quickly. I think if WWF was leaving connections open, we'd have heard about it before this. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: WebWiz-Bruce
Date Posted: 27 April 2004 at 4:52am
|
Web Wiz Forums closes all connections and drops all objects once they are used. This has been checked many, many, times and if someone does find any that aren't then let me know and I'll correct it for the next version. But I'm 99% sure that I haven't missed any. I often find that many of the mods available are badly written and often leave connections, recordsets, and objects open, which does course problems. If you have installed any mods on yoru forum check the coding in these mods. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: aysolaw5
Date Posted: 28 April 2004 at 2:07am
|
HI! This is a generic, plain install of Web Wiz Forums. The ONLY MOD I did was to the default_stlye.css. Plus, I changed the web_wiz_forums.gif, to the Website LOGO keeping the same web_wiz_forums.gif name. Thats about it. Is there any specfic questions you like for me to ask my ISP, to help resolve this? This is link to the Forum... http://www.kenaston.org/forum/default.asp - http://www.kenaston.org/forum/default.asp Again, Thanks & Cheers!!! aysolaw5
|
Posted By: WebWiz-Bruce
Date Posted: 28 April 2004 at 3:06am
|
It's not just the forum that can effect this, others files on your site
not closing objects and connections can effect the running of your
entire site. Also as you are on a shared hosting web server, other sites on the server can effect the running of your site, as often your memory allocation will be shared with a mutiple number of sites. Anyone of these sites not closing connections and releasing objects could effect your site. It's just one of those things you have to put up with in a shared hosting environment. The only solution would be to move your site to it's own dedicated server, but then you would be looking at paying many 100's each month. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Semikolon
Date Posted: 28 April 2004 at 12:50pm
|
WWF is definately NOT the problem.. I did a manual replace of resetting of objects before all redirects and processing stops and I found two occurences where the connection object were set to Nothing two times instead of closed one time and set to nothing one time. I don't remember what files it was in, but I think one of the was in the admin area This should be found easily by doing a simple search |
Posted By: aysolaw5
Date Posted: 23 June 2004 at 3:19am
|
I'm now getting this error...
Microsoft JET Database Engine error '80004005' Unspecified error /forum/common.asp, line 260 Any help would be greatfull! Thanks & Cheers!!! aysolaw5
|
Posted By: WebWiz-Bruce
Date Posted: 23 June 2004 at 4:20am
|
Does this error just happen ocasionally? If so then it is a server problem, probally coursed by the server being over loaded, readHosting often overload their servers so every once in a while as server resources run low and the server needs rebooting you get errors like the one you mention. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |