Print Page | Close Window

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.
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.

 



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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net