Print Page | Close Window

Intermittent SQL problems

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=22209
Printed Date: 08 April 2026 at 12:17pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Intermittent SQL problems
Posted By: Beren
Subject: Intermittent SQL problems
Date 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



Replies:
Posted By: WebWiz-Bruce
Date 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.


-------------
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: Beren
Date Posted: 15 December 2006 at 7:32pm

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

Beren




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net