Web Wiz Support and Community Forums : Intermittent SQL problems https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 12:19:27 +0000 Fri, 15 Dec 2006 19:32:53 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22209 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Intermittent SQL problems : There are no other scripts or...]]> https://forums.webwiz.net/intermittent-sql-problems_topic22209_post118329.html#118329 Author: Beren
Subject: 22209
Posted: 15 December 2006 at 7:32pm

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

Beren

]]> Fri, 15 Dec 2006 19:32:53 +0000 https://forums.webwiz.net/intermittent-sql-problems_topic22209_post118329.html#118329 <![CDATA[Intermittent SQL problems : A connection to a database will...]]> https://forums.webwiz.net/intermittent-sql-problems_topic22209_post118298.html#118298 Author: WebWiz-Bruce
Subject: 22209
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.
]]> Fri, 15 Dec 2006 09:07:11 +0000 https://forums.webwiz.net/intermittent-sql-problems_topic22209_post118298.html#118298 <![CDATA[Intermittent SQL problems : I am having the following problem: Every...]]> https://forums.webwiz.net/intermittent-sql-problems_topic22209_post118290.html#118290 Author: Beren
Subject: 22209
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
]]> Fri, 15 Dec 2006 00:44:43 +0000 https://forums.webwiz.net/intermittent-sql-problems_topic22209_post118290.html#118290