Error
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=21991
Printed Date: 08 April 2026 at 1:53pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Error
Posted By: wolfguardian
Subject: Error
Date Posted: 22 November 2006 at 9:40am
|
I'm trying out the forum and my host keeps getting this error they suggest changing from Jet to another DB connection this is the error Active Server Pages error 'ASP 0240' Script Engine Exception /Forum/default.asp
A ScriptEngine threw exception 'C0000005' in 'IActiveScriptParse::ParseScriptText()' from 'CActiveScriptEngine::AddScriptlet()'. and when I re-fresh page get this Microsoft VBScript compilation error '800a03e9' Out of memory /Forum/default.asp, line 0 My host is running windows server 2003 I reccon there is a fault with there IIS server or Jet Drivers but thats another story. can/do you have another Connection string for access DB ?
|
Replies:
Posted By: dj air
Date Posted: 22 November 2006 at 11:47am
|
i belive WWF uses the jet engine which is better than the access default one.
out of memory looks like a Over loaded server.
or sites using alot of ram/memory.
if you edit the database/database_connection.asp file you can change the Aceess JET Driver.
also if possible change from access to My OR MS SQL servers
|
Posted By: guardian
Date Posted: 22 November 2006 at 12:05pm
| without changing DB is there a different connection string that could be used even if NOT DNS-less ? |
Posted By: dj air
Date Posted: 22 November 2006 at 12:57pm
| there is a different driver access default in the file you can use, but is not as stable as JET 4 |
Posted By: guardian
Date Posted: 23 November 2006 at 1:03am
|
Thought you guys might like to read this artical from MS there are known bugs with the forum based on the SQL strings.. I got this from my host who has been trying to help with the error I get from time to time.. http://support.microsoft.com/kb/174634 - http://support.microsoft.com/kb/174634 Possible cause of the error. Both
forums have quite large SQL statements in them (over 10 lines), so using some of
the methods described in this support article may help resolve the issue you’re
seeing on Windows Server 2003. |
Posted By: WebWiz-Bruce
Date Posted: 23 November 2006 at 7:30am
|
Got to say that your web host is trying to pull the wool over your eyes here. Over 400,000 people have downloaded the Access version over the years and the only time that this error has ever occurred is when the user has been using a server which is overloaded. As the page in question doesn't use an SQL query that is over 10 lines, more like 3 lines, however, it does use several joins which require more memory than a standard SQL query, without it the forum will not run. This should never be an issue unless you are on a very overloaded server that has no memory left for processing. I would suggest switching web hosts as your web host doesn't sound very good maximising profit at the expense of users by overloading their web servers. ------------- 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: wolfguardian
Date Posted: 23 November 2006 at 8:48pm
Just tolet you know my host moved our site to a dedicated poole, anyway we have NOT had the error in over 12 hrs now new record so Borg guess you was right money before service seems to be the norm as usual 
|
Posted By: wolfguardian
Date Posted: 28 November 2006 at 7:45pm
| Here is the lastest. My host has now found out what the problem is They believe is lies with the DB connection some where in the code there is a SQL query that do not close the connection properly can you confirm this at all ? |
Posted By: dpyers
Date Posted: 28 November 2006 at 8:24pm
|
All the db connections are closed in the released version - or else the high-volume access sites would be crashing all over the place. YMMV if you've added some mods to the base code. One of the problems with access in a shared hosting environment is that failure to close connections on another web site may cause your access site to crash. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: Mikey
Date Posted: 28 November 2006 at 9:05pm
|
I can also confirm that the vanilla code of WWF does close all DB connections.
------------- Handyman man? |
Posted By: wolfguardian
Date Posted: 28 November 2006 at 10:55pm
|
Well please guys, what is causing this problem, my host blames you - you blame host I'm the one stuck in the middle here I really need answers... As for connection open on another site, host said I'm in a poole all by myself if that makes sense. all I know is site keeps erroring everyone blames everyone else and all I want is an answer I'm looking at changing to mysql but I cant figure how to install and get that thing working either.. |