Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Having problems with 10.03 in Ms Access
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Having problems with 10.03 in Ms Access
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
the.rebel.agent View Drop Down
Newbie
Newbie


Joined: 29 February 2012
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote the.rebel.agent Quote  Post ReplyReply Direct Link To This Post Topic: Having problems with 10.03 in Ms Access
    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?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
the.rebel.agent View Drop Down
Newbie
Newbie


Joined: 29 February 2012
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote the.rebel.agent Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
the.rebel.agent View Drop Down
Newbie
Newbie


Joined: 29 February 2012
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote the.rebel.agent Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.