Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Intermittent SQL problems
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Intermittent SQL problems

 Post Reply Post Reply
Author
Beren View Drop Down
Newbie
Newbie


Joined: 15 December 2006
Location: United States
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote Beren Quote  Post ReplyReply Direct Link To This Post Topic: Intermittent SQL problems
    Posted: 15 December 2006 at 12:44am
I am having the following problem:
 
Every few days, I have a situation where the forum throws errors when you click links to go to the forum_topics.asp, get_last_post.asp, or forum_posts.asp. The error is as follows:
 
"Server Error in Forum Application
An error has occured while executing SQL query on database.
Please contact the forum administrator.
Support Error Code:- err_SQLServer_get_sub_forum_data
File Name:- forum_topics.asp
Error details:-
Microsoft OLE DB Provider for SQL Server
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation."
 
I contacted my ISP (GoDaddy) and asked them to look at SQL and ASP to see what was going on, as the static parts of the site were working fine. They informed me that I had maxed out the connections (100) to the database, and that they would gladly upgrade my account to more connections. This is strange, as I have nowhere near the traffic it would take to have that many simultaneous connections.
 
Is there anything I can do to remedy this problem?
 
Thanks,
Beren Longstreet
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: 15 December 2006 at 9:07am
A connection to a database will only last a few seconds, this forum till recently with over 50 active users ran on a SQL Server database with only 6 connections without any real issues.

If your database has over 100 active connections to it then I would check any other scripts or applications that use the database correctly close and release their connections to the database.

Also GaDaddy do not have a good reputation, just look at the number of issues raised with them on this forum. If the issue continues I would highly recommend looking for a decent web host and moving away from GoDaddy.
Back to Top
Beren View Drop Down
Newbie
Newbie


Joined: 15 December 2006
Location: United States
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote Beren Quote  Post ReplyReply Direct Link To This Post Posted: 15 December 2006 at 7:32pm

There are no other scripts or applications that use the database. Just the forum.

Beren

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.