Error

Post Reply

Page 12 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
wolfguardian Members Profile Find Members Posts Newbie Joined: 19 November 2006 Location: Australia Status: Offline Points: 11	Post Options Post Reply Quote wolfguardian Report Post Thanks(0) Quote Reply Topic: Error 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 ?

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply 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

guardian Members Profile Find Members Posts Newbie Joined: 22 November 2006 Status: Offline Points: 2	Post Options Post Reply Quote guardian Report Post Thanks(0) Quote Reply 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 ?

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply 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

guardian Members Profile Find Members Posts Newbie Joined: 22 November 2006 Status: Offline Points: 2	Post Options Post Reply Quote guardian Report Post Thanks(0) Quote Reply 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 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.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

wolfguardian Members Profile Find Members Posts Newbie Joined: 19 November 2006 Location: Australia Status: Offline Points: 11	Post Options Post Reply Quote wolfguardian Report Post Thanks(0) Quote Reply 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 Edited by wolfguardian - 28 November 2006 at 7:42pm

wolfguardian Members Profile Find Members Posts Newbie Joined: 19 November 2006 Location: Australia Status: Offline Points: 11	Post Options Post Reply Quote wolfguardian Report Post Thanks(0) Quote Reply 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 ?

Post Reply	Page 12 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum