Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - SQL Server Error on delete
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL Server Error on delete
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
bruce View Drop Down
Groupie
Groupie
Avatar

Joined: 16 April 2003
Location: United States
Status: Offline
Points: 102 		Post Options Post Options   Thanks (0) Thanks(0)   Quote bruce Quote  Post ReplyReply Direct Link To This Post Topic: SQL Server Error on delete
    Posted: 03 November 2005 at 4:53pm

I've been struggling with this problem for awhile now and I'm at my wits end.

Forum: WWF v7.95
DB: SQL
Host: JodoHost
 
Every time I delete a post from my forum I get the follow error:

Microsoft OLE DB Provider for SQL Server error '80040e14'

The query has been canceled because the estimated cost of this query (327) exceeds the configured threshold of 200. Contact the system administrator.

/gfboard/delete_post.asp, line 217

 
I thought I had it figured out.  The error used to say that I exceeded the estimated cost of the query (192) and that the server was only configured for (60), so I had jodohost configure the SQL server for 200.
 
So now the server is configured for 200 and now I get the above error in red.
Back to Top
JJLatWebWiz View Drop Down
Groupie
Groupie
Avatar

Joined: 02 March 2005
Location: United States
Status: Offline
Points: 136 		Post Options Post Options   Thanks (0) Thanks(0)   Quote JJLatWebWiz Quote  Post ReplyReply Direct Link To This Post Posted: 03 November 2005 at 5:46pm
I worked on a simple solution that the only other reporting user hasn't had a chance to test yet... Try adding "adoCon.CursorLocation = 3" immediately above "adoCon.open" in "common.asp".

I'm interested to hear if the suggestion solves the problem.
p.s. I'm not affiliated with Web Wiz Guide in any way. I'm just an average Web Wiz user repaying my debt for the use of their fine forum by trying to help other Web Wiz Guide users.
Back to Top
bruce View Drop Down
Groupie
Groupie
Avatar

Joined: 16 April 2003
Location: United States
Status: Offline
Points: 102 		Post Options Post Options   Thanks (0) Thanks(0)   Quote bruce Quote  Post ReplyReply Direct Link To This Post Posted: 03 November 2005 at 6:06pm
Turning off the query governor on the SQL Server resolved this problem.
Back to Top
JJLatWebWiz View Drop Down
Groupie
Groupie
Avatar

Joined: 02 March 2005
Location: United States
Status: Offline
Points: 136 		Post Options Post Options   Thanks (0) Thanks(0)   Quote JJLatWebWiz Quote  Post ReplyReply Direct Link To This Post Posted: 03 November 2005 at 8:15pm
Darn. I wanted to see if the client-side cursor worked. Oh well.

Keep in mind that the governor protects your SQL queries from other host clients that may hog the SQL server. The client-side cursor is much more efficient on the SQL server too.

I'm surprise a host would shut if off.
p.s. I'm not affiliated with Web Wiz Guide in any way. I'm just an average Web Wiz user repaying my debt for the use of their fine forum by trying to help other Web Wiz Guide users.
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.