Web Wiz Support and Community Forums : New Post Recordset Error https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 00:30:12 +0000 Tue, 02 May 2006 13:19:11 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19659 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[New Post Recordset Error : I would suggest going back to...]]> https://forums.webwiz.net/new-post-recordset-error_topic19659_post105980.html#105980 Author: WebWiz-Bruce
Subject: 19659
Posted: 02 May 2006 at 1:19pm

I would suggest going back to your old database on your previous server, and this time use the DTS tools to move your database and make sure you select to move the whole database including default values.]]> Tue, 02 May 2006 13:19:11 +0000 https://forums.webwiz.net/new-post-recordset-error_topic19659_post105980.html#105980 <![CDATA[New Post Recordset Error : Hi I&#039;ve recently copied...]]> https://forums.webwiz.net/new-post-recordset-error_topic19659_post105945.html#105945 Author: Ravage
Subject: 19659
Posted: 02 May 2006 at 12:05pm

Hi
 
I've recently copied my sql server databse for the forums to a new machine. SInce doing so, when someone tries too post a new post I get:
 
Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_save_new_post_data
File Name:- new_post.asp

Error details:-
ADODB.Recordset
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

I've searched the forums and seen that people get this when they migrate in from Access. I've also noted the comments have been to check that sql created the default values (which it didnt).
 
I've been through the database adding the default values but still get this error message.
 
ANy idea what I'm missing/what causes this?
 
Thanks in advance, Rav
]]> Tue, 02 May 2006 12:05:29 +0000 https://forums.webwiz.net/new-post-recordset-error_topic19659_post105945.html#105945