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

  New Posts New Posts RSS Feed - SQL server errormessage
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic ClosedSQL server errormessage
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
absolo View Drop Down
Newbie
Newbie


Joined: 09 January 2004
Status: Offline
Points: 2 		Direct Link To This Post Topic: SQL server errormessage
    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

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 		Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
absolo View Drop Down
Newbie
Newbie


Joined: 09 January 2004
Status: Offline
Points: 2 		Direct Link To This Post 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://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
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 		Direct Link To This Post 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.
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.