Web Wiz Support and Community Forums : Locktype error

Web Wiz Support and Community Forums : Locktype error https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 19:30:03 +0000 Sat, 18 Dec 2004 09:51:41 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=13029 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Locktype error : Yes - I asked him to test everything....]]> https://forums.webwiz.net/locktype-error_topic13029_post72129.html#72129 Author: Corey Bryant
Subject: 13029
Posted: 18 December 2004 at 9:51am

Yes - I asked him to test everything. And he said it all worked

]]> Sat, 18 Dec 2004 09:51:41 +0000 https://forums.webwiz.net/locktype-error_topic13029_post72129.html#72129 <![CDATA[Locktype error : Are you sure it worked on your...]]> https://forums.webwiz.net/locktype-error_topic13029_post72125.html#72125 Author: WebWiz-Bruce
Subject: 13029
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 dataacross to prevent this error, if you upsize from MS Acess to SQL Serveryou get the error you mention.
]]> Sat, 18 Dec 2004 09:31:34 +0000 https://forums.webwiz.net/locktype-error_topic13029_post72125.html#72125 <![CDATA[Locktype error : Yes he moved from Access to SQL....]]> https://forums.webwiz.net/locktype-error_topic13029_post72124.html#72124 Author: Corey Bryant
Subject: 13029
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?

]]> Sat, 18 Dec 2004 09:24:33 +0000 https://forums.webwiz.net/locktype-error_topic13029_post72124.html#72124 <![CDATA[Locktype error : Have you upgraded from Access...]]> https://forums.webwiz.net/locktype-error_topic13029_post72121.html#72121 Author: WebWiz-Bruce
Subject: 13029
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]]> Sat, 18 Dec 2004 08:00:45 +0000 https://forums.webwiz.net/locktype-error_topic13029_post72121.html#72121 <![CDATA[Locktype error : I get that error, when I post...]]> https://forums.webwiz.net/locktype-error_topic13029_post72120.html#72120 Author: ukakht
Subject: 13029
Posted: 18 December 2004 at 7:53am

I get that error, when I post message or Send pm

]]> Sat, 18 Dec 2004 07:53:49 +0000 https://forums.webwiz.net/locktype-error_topic13029_post72120.html#72120 <![CDATA[Locktype error : I'm not getting any of these...]]> https://forums.webwiz.net/locktype-error_topic13029_post72116.html#72116 Author: WebWiz-Bruce
Subject: 13029
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 ontoyour web host about them, as it looks like your forum is wellestablished 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 detailfrom 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.
]]> Sat, 18 Dec 2004 07:37:53 +0000 https://forums.webwiz.net/locktype-error_topic13029_post72116.html#72116 <![CDATA[Locktype error : Here is the forum http://www.batkhelaforum.com Powered...]]> https://forums.webwiz.net/locktype-error_topic13029_post72115.html#72115 Author: ukakht
Subject: 13029
Posted: 18 December 2004 at 6:30am

Here is the forum http://www.batkhelaforum.com

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

]]> Sat, 18 Dec 2004 06:30:28 +0000 https://forums.webwiz.net/locktype-error_topic13029_post72115.html#72115 <![CDATA[Locktype error : This is a bit difficult to workout...]]> https://forums.webwiz.net/locktype-error_topic13029_post72100.html#72100 Author: WebWiz-Bruce
Subject: 13029
Posted: 18 December 2004 at 5:03am

This is a bit difficult to workout the problem as you haven't followedthe guidelines for posting in the support forum so really need somemore details:-

What version are you running?
What database type?
Is this an upgrade?
Have you tried reuploading files?
]]> Sat, 18 Dec 2004 05:03:14 +0000 https://forums.webwiz.net/locktype-error_topic13029_post72100.html#72100 <![CDATA[Locktype error : ADODB.Recordset error '800a0cb3'...]]> https://forums.webwiz.net/locktype-error_topic13029_post72099.html#72099 Author: ukakht
Subject: 13029
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 ?

]]> Sat, 18 Dec 2004 04:46:20 +0000 https://forums.webwiz.net/locktype-error_topic13029_post72099.html#72099