Web Wiz Forums - Having problems with 10.03 in Ms Access

Print Page | Close Window

Having problems with 10.03 in Ms Access

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=30198
Printed Date: 31 March 2026 at 1:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Having problems with 10.03 in Ms Access

Posted By: the.rebel.agent
Subject: Having problems with 10.03 in Ms Access
Date Posted: 29 February 2012 at 7:13pm

I have been using free edition since 2009 at the domain www.starfans.com.ar under /boards url. It was great and a very reliable product, but after I updated to version 10.03 we are experiencing serious problems. From time to time, the forum hangs up and froze.

2012-02-29 18:59:42 W3SVC2379 WINDOWS01 74.52.21.74 GET /boards/Default.asp |-|ASP_0113|Script_timed_out 80 - 200.123.109.100 HTTP/1.1 Mozilla/5.0+(Windows+NT+5.1;+rv:10.0.2)+Gecko/20100101+Firefox/10.0.2 wwf10lVisit=LV=2011%2D11%2D07+09%3A51%3A40;+wwfsf10lVisit=LV=2012%2D02%2D29+13%3A49%3A40;+wwfsf10sLID=UID=Darth%5FLeBeau%2D4BAE%2DB82%2D25D7%2D9BA7&NS=0;+ASPSESSIONIDCQCDRTRQ=PIMLCNMBAJBPPELGIJECJHOM;+ASPSESSIONIDCQDBQSQR=PBPJNJJCOAFCPMABFECLGJIP;+wwfsf10sID=SID=31091002d8cdbac9b82585ea958fz6133101852;+fb920a5565797ebb1277af63d409f039=rvkp7b9vcdm2p3klvm04fg13s0 http://www.starfans.com.ar/index.php www.starfans.com.ar 500 0 0 665 781 762250

2012-02-29 18:59:42 W3SVC2379 WINDOWS01 74.52.21.74 GET /boards/Default.asp |-|ASP_0113|Script_timed_out 80 - 186.111.232.70 HTTP/1.1 Mozilla/5.0+(Windows+NT+6.1)+AppleWebKit/535.11+(KHTML,+like+Gecko)+Chrome/17.0.963.56+Safari/535.11 ASPSESSIONIDCQDBQSQR=LGEKNJJCFGMAKBPBACAELELM;+fb920a5565797ebb1277af63d409f039=h5td7cjhg7h3mfe325575hlc97 - www.starfans.com.ar 500 0 22 0 522 666796

2012-02-29 18:59:43 W3SVC2379 WINDOWS01 74.52.21.74 GET /boards/Default.asp |-|ASP_0113|Script_timed_out 80 - 109.230.246.149 HTTP/1.0 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1)+Netscape/8.0.4 ASPSESSIONIDCQDBQSQR=CGEKNJJCIBEGPOBPIGNNHCDA;+fb920a5565797ebb1277af63d409f039=utkhd56kno0vb6jd2qv1pskke2 http://www.starfans.com.ar/boards/ www.starfans.com.ar 500 0 64 0 556 1374890

2012-02-29 18:59:44 W3SVC2379 WINDOWS01 74.52.21.74 GET /boards/Default.asp |-|ASP_0113|Script_timed_out 80 - 200.41.237.69 HTTP/1.0 Mozilla/5.0+(Windows+NT+5.1)+AppleWebKit/535.2+(KHTML,+like+Gecko)+Chrome/15.0.874.120+Safari/535.2 ASPSESSIONIDCQDBQSQR=PDDKNJJCLGLGKMDJFEOMHNNL;+fb920a5565797ebb1277af63d409f039=uh76dupsbuogfukvkuqdns6466;+wwfsf10sLID=UID=Gabywan%2DD28D%2D57F%2DB427%2D3977;+wwfsf10sID=SID=1270014cd719b8b9adz1cae4z6ab5975;+wwfsf10lVisit=LV=2012%2D02%2D29+14%3A20%3A24 http://www.starfans.com.ar/index.php www.starfans.com.ar 500 0 0 689 810 97906

2012-02-29 18:59:44 W3SVC2379 WINDOWS01 74.52.21.74 GET /boards/Default.asp |-|ASP_0115|Unexpected_error 80 - 186.111.232.70 HTTP/1.1 Mozilla/5.0+(Windows+NT+6.1)+AppleWebKit/535.11+(KHTML,+like+Gecko)+Chrome/17.0.963.56+Safari/535.11 ASPSESSIONIDCQDBQSQR=LGEKNJJCFGMAKBPBACAELELM;+fb920a5565797ebb1277af63d409f039=h5td7cjhg7h3mfe325575hlc97 - www.starfans.com.ar 500 0 0 549 522 178953

It resolves or fix it If we restart the webserver, but I have to contact web hosting admin to do that and It is a pain in the neck. Someone having the same problem?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 01 March 2012 at 8:58am

Access databases are desktop databases, while fine for very light web usage are totally no good for a large forum like your own.

Access also shares 20 database connections shared with all websites on the same server who share the same App Pool Process.

Either your forum has outgrown Access or someone else on the same server sharing the same application pool is using up the small resource pool that you share for Access database connections, causing this error.

You could talk to your web host to try and resolve this issue, but my recommendation would be to upsize the Access database to SQL Server.

-------------
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: the.rebel.agent
Date Posted: 01 March 2012 at 11:22am

While I understand this, which have sense for me, why did not happen with the previous version? 9.56a? I know that there are running app on that server using access, but in a different app pool. Could be possible that 10.03 is doing something more or forgetting to release the database connection at some point?

Posted By: WebWiz-Bruce
Date Posted: 01 March 2012 at 12:03pm

All database connections are closed. however,from version 9.6x onwards sessions are stored in the database, which Access may not be able to cope with on a busy forum.

In the admin area on the configuration page you can change this so that Web Wiz Forums stores sessions in the servers memory instead of the database. This is not as good as it does mean that when the app pool recycles all sessions are dropped, but if you want to keep using Access you may need to do this.

Posted By: the.rebel.agent
Date Posted: 03 March 2012 at 4:26pm

did change that configuration and today we got this error:

Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the Forum Administrator.

Support Error Code:- err_Access_db_connection
File Name:- database_connection.asp
Forum Version:- 10.03

Error details:-
Microsoft JET Database Engine
Unspecified error

Posted By: WebWiz-Bruce
Date Posted: 05 March 2012 at 11:43am

If this error keeps coming and going it points to a resource issue with the server you are using and you should contact your web hosting company or move 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