Print Page | Close Window

SQL server errormessage

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=8707
Printed Date: 07 April 2026 at 9:39am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: SQL server errormessage
Posted By: absolo
Subject: SQL server errormessage
Date Posted: 09 January 2004 at 8:17am

Since i have installed the forum i have this error :

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt




Replies:
Posted By: WebWiz-Bruce
Date Posted: 09 January 2004 at 8:55am
You haven't really given enough info.

Does this only happen in teh forum?
Do other applications use the same database?

If other applications share the same database then these may use the default forward-only or read-only cursor. The server streams all of the results down to the client at once, so the network connection is busy with the results from the query. So youcan't process the results of another query until you finish the results from
the current query.

-------------
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: absolo
Date Posted: 09 January 2004 at 5:37pm

You haven't really given enough info.

Originally posted by -boRg- -boRg- wrote:

Does this only happen in teh forum?
  NO
Originally posted by -boRg- -boRg- wrote:

Do other applications use the same database?
YES

I have found this microsoft article :

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q182/9/29.asp&NoWebContent=1 - http://support.microsoft.com/default.aspx?scid=http://suppor t.microsoft.com:80/support/kb/articles/Q182/9/29.asp&NoW ebContent=1

My application don't use Stored procedure except the Webwiz forum and i can't foun wich Webwiz stored procedure cause error



Posted By: WebWiz-Bruce
Date Posted: 09 January 2004 at 7:53pm
Read my last post as this has your anwser and I don't wish to repeat myself.

The problem is within your other asp applications using the default cursors.


-------------
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



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