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

  New Posts New Posts RSS Feed - The dreaded ’800a0cb3’
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

The dreaded ’800a0cb3’

 Post Reply Post Reply
Author
jamesc122 View Drop Down
Newbie
Newbie


Joined: 27 January 2005
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote jamesc122 Quote  Post ReplyReply Direct Link To This Post Topic: The dreaded ’800a0cb3’
    Posted: 27 January 2005 at 6:32pm
Hello,
 
After reading through all the threads for the solution, I didn't find one that fit my particular situation.
 
There are two environments, one where it works, one where the error occurs.  Both environments are OS:Windows 2003, SQL2000 (no upsizing here, I started out with SQL)
 
Here is the error I get:
--------------------------
 ADODB.Recordset error '800a0cb3'

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

/onlinecommunity/admin/forum_configure.asp, line 143

---------------------------
it also happens when I try to change the email admin settings.
 
This was working on the "live" server because we couldn't have set it up without it.  I've been banging my head on what could have changed since the code is the same in both environments.
 
Any help is totally appreciated.
 
Thanks,
 
James
Back to Top
jamesc122 View Drop Down
Newbie
Newbie


Joined: 27 January 2005
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote jamesc122 Quote  Post ReplyReply Direct Link To This Post Posted: 28 January 2005 at 7:24pm
Well, I figured out what the problem is...when I was updating some of the stored procedures I put "set nocount on" in the statement...it didn't like that.
 
I hope this helps someone else.
 
Peace
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.