Recordset does not support updating
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21001
Printed Date: 08 April 2026 at 8:53pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Recordset does not support updating
Posted By: iSec
Subject: Recordset does not support updating
Date Posted: 12 August 2006 at 7:52am
|
This problem seems to be very common and as much as I search on google I get no answers but many suggestions much of which don't give an ultimate solution. I've had this problem in the past... and it never got solved... but I'm hoping to get an answer this time
 I recently ordered a dedicated server and installed SQL server on it which works fine.
I decided to transfer my forums databases on two different website to my new server, the forum tables get transferred successfully without any problem... however whenever I try to post a new message on the forum I get this error:
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_topic_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. What I tried is:-
setting the locktype to 2 - didn't work
setting the cursor type to 1 - didn't work either... ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 12 August 2006 at 9:18am
|
This issue does seem to happen sometimes when a database is used that is upsized from Access. As to why this error occurs has never been established as there is nothing in the code that could course this problem, so it must be some bug in SQL Server or the database drivers that is coursing the issue. When the database is upsized from Access something in the underlying database must be altered to course this problem. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: iSec
Date Posted: 12 August 2006 at 10:09pm
|
Well I'm transferring from SQL 2000 to SQL 2000. I have total access to the new SQL server because it is my own. If there is anything I need to do I'll be able to... and Borg, if you think that there is something I'm not doing right, then I'm willing to provide you with the details for both servers and you can try it yourself... Currently it isn't a big database and it takes about 30 seconds to be transferred.
It sounds like SQL 2000 databases are pain in the neck when it comes to transfering to a new server... which means that I'll either have to lose all my members and all my forum threads or stay with the current hosting porovider forever! ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: WebWiz-Bruce
Date Posted: 13 August 2006 at 8:07am
|
I've have transferred SQL Server databases between servers quite a few times, the forum on this site has moved about 5 times. I generally use the DTS Tools to transfer the database, selecting to transfer everything accept roles as permissions are generally different. However, if you want to try a different method and have access to both servers, I have recently been detaching the databases in SQL Server 2005 and moving the .mdf, and .ldf file for the database then reattaching the database to the new SQL Server. Also if you are running your own server try the free SQL 2005 Express. It has no limitations that would effect the running of Web Wiz Forums. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: iSec
Date Posted: 13 August 2006 at 11:07am
|
When you say except 'roles', how do you exclude "roles" ...I use the DTS tool and I don't see roles anywhere with the tables...how do you exclude roles from being transferred? because this might be causing the problem I have. ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: WebWiz-Bruce
Date Posted: 13 August 2006 at 3:27pm
|
I don't have enterprise manager anymore as I now only use SQL Server 2005 with SQL Studio Manager which no-longer uses DTS like you have in the old Enterprise Manager. However, from what I recall, I use to select Import/Export then from the DTS Tool select the option that gave you the most options so you could then select what to import/export. You may need to go into this and just experiment with different options till you get it right. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: iSec
Date Posted: 14 August 2006 at 9:30am
|
Borg!!!!!!!! I did it....... I'm so happy!
I will do a tutorial just for anyone that uses webwiz forum with SQL version and need to transfer their database... man this is so easy and I just had to exclude roles................ Thanks so much Borg. ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: Acidcat
Date Posted: 13 October 2006 at 4:27am
|
My steps for successfully transferring the databse were as follows: 1. Start by running DTS Import/Export Wizard.
|
Posted By: dpyers
Date Posted: 13 October 2006 at 3:55pm
|
I use Acidcat's procedure for copying any MSSQL db but I usually do it twice - once to my local SQL Server instance and then from there to the new location. Gives me a backup.
------------- 
Lead me not into temptation... I know the short cut, follow me. |