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

  New Posts New Posts RSS Feed - Locktype error
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Locktype error
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
ukakht View Drop Down
Newbie
Newbie


Joined: 09 December 2004
Location: Scotland
Status: Offline
Points: 14 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ukakht Quote  Post ReplyReply Direct Link To This Post Topic: Locktype error
    Posted: 18 December 2004 at 4:46am
 ADODB.Recordset error '800a0cb3'

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

/pm_post_message.asp, line 306

Any idea what that problem is ?
 
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 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 18 December 2004 at 5:03am
This is a bit difficult to workout the problem as you haven't followed the guidelines for posting in the support forum so really need some more details:-

What version are you running?
What database type?
Is this an upgrade?
Have you tried reuploading files?
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
ukakht View Drop Down
Newbie
Newbie


Joined: 09 December 2004
Location: Scotland
Status: Offline
Points: 14 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ukakht Quote  Post ReplyReply Direct Link To This Post Posted: 18 December 2004 at 6:30am
Here is the forum http://www.batkhelaforum.com
Powered by Web Wiz Forums version 7.9
Copyright ©2001-2004 Web Wiz Guide
 
I am getting another error when I click on any topic
 
Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name 'tblEmailNotify'.

/forum_posts.asp, line 587

Cry
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 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 18 December 2004 at 7:37am
I'm not getting any of these errors on your forum.

Are they intermitent errors?

They are certainly database errors, so it could be worth getting onto your web host about them, as it looks like your forum is well established so it's not the normal getting started type problem.

Have you recently changed anything in your forum or on the MS SQL server? Maybe even changed hosts?

As you have given two different errors certainly need allot more detail from you to try a workout what could be coursing the problems.

But a first guess is that it looks like problems with the MS SQL Server you are using.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
ukakht View Drop Down
Newbie
Newbie


Joined: 09 December 2004
Location: Scotland
Status: Offline
Points: 14 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ukakht Quote  Post ReplyReply Direct Link To This Post Posted: 18 December 2004 at 7:53am
I get that error,  when I post message or  Send pm
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 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 18 December 2004 at 8:00am
Have you upgraded from Access version? (you still haven't said!!)

This error is apparently common if you don't move across from Access to MS SQL Server in a particular way.

I made a post sticky the other day about how to move from Acess to MS SQL Server, maybe worth you reading through it.


Edited by -boRg- - 18 December 2004 at 8:01am
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Corey Bryant View Drop Down
Newbie
Newbie


Joined: 14 December 2004
Status: Offline
Points: 18 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Corey Bryant Quote  Post ReplyReply Direct Link To This Post Posted: 18 December 2004 at 9:24am
Yes he moved from Access to SQL.  Actually this worked flawlessly on my SQL server.  So I imported everything from my SQL server to JdoHost.  Three hours later (since JodoHost could not set up the transaction logs properly) we finally got the data over. 
 
Now since this was working on my SQL server but not Jodo Host, it makes me beleive that it is the permissions on Jodo host?
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 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 18 December 2004 at 9:31am
Are you sure it worked on your server??

Have you been through the following sticky topic that I mentioned in my previous posts that gives the same error??

http://forums.webwiz.net/forum_posts.asp?TID=12 975&PN=1

Apparently you need to create the database before you move the data across to prevent this error, if you upsize from MS Acess to SQL Server you get the error you mention.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply Page  12>

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.