Web Wiz Support and Community Forums : Recordset does not support updating https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 20:55:57 +0000 Fri, 13 Oct 2006 15:55:09 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=21001 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Recordset does not support updating : I use Acidcat&#039;s procedure...]]> https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post115466.html#115466 Author: dpyers
Subject: 21001
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.]]> Fri, 13 Oct 2006 15:55:09 +0000 https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post115466.html#115466 <![CDATA[Recordset does not support updating : My steps for successfully transferring...]]> https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post115439.html#115439 Author: Acidcat
Subject: 21001
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.
2. Choose the source database.
3. Select your database name from the dropdown list.
4. On the next screen, "Choose a Destination," select the target server (using server authentication if it is on a remote server) and the database.
5. To move all of our database objects, (tables, views, stored procs, UDFs, etc), select "Copy objects and data between SQL Server databases" from the "Specify Table Copy" or Query screen, then click next.
6. Uncheck "Use default options" and then click on "Options".
7. Unselect "Copy database users and database roles" and then click OK.
8. Click Next.
9. Run immediately and the database will be transferred.

 



Edited by Acidcat - 13 October 2006 at 4:28am]]> Fri, 13 Oct 2006 04:27:56 +0000 https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post115439.html#115439 <![CDATA[Recordset does not support updating : Borg!!!!!!!! I did it....... I&#039;m...]]> https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post112611.html#112611 Author: iSec
Subject: 21001
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.
]]> Mon, 14 Aug 2006 09:30:35 +0000 https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post112611.html#112611 <![CDATA[Recordset does not support updating : I don&#039;t have enterprise...]]> https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post112571.html#112571 Author: WebWiz-Bruce
Subject: 21001
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.


Edited by -boRg- - 13 August 2006 at 3:27pm]]> Sun, 13 Aug 2006 15:27:03 +0000 https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post112571.html#112571 <![CDATA[Recordset does not support updating : When you say except &#039;roles&#039;,...]]> https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post112547.html#112547 Author: iSec
Subject: 21001
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.]]> Sun, 13 Aug 2006 11:07:53 +0000 https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post112547.html#112547 <![CDATA[Recordset does not support updating : I&#039;ve have transferred SQL...]]> https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post112542.html#112542 Author: WebWiz-Bruce
Subject: 21001
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.


]]> Sun, 13 Aug 2006 08:07:48 +0000 https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post112542.html#112542 <![CDATA[Recordset does not support updating : Well I&#039;m transferring from...]]> https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post112531.html#112531 Author: iSec
Subject: 21001
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!
]]> Sat, 12 Aug 2006 22:09:22 +0000 https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post112531.html#112531 <![CDATA[Recordset does not support updating : This issue does seem to happen...]]> https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post112507.html#112507 Author: WebWiz-Bruce
Subject: 21001
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.
]]> Sat, 12 Aug 2006 09:18:47 +0000 https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post112507.html#112507 <![CDATA[Recordset does not support updating : This problem seems to be very...]]> https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post112503.html#112503 Author: iSec
Subject: 21001
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...
]]> Sat, 12 Aug 2006 07:52:13 +0000 https://forums.webwiz.net/recordset-does-not-support-updating_topic21001_post112503.html#112503