| Author |
 Topic Search  Topic Options
|
iSec 
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Recordset does not support updating
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
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
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
|
|
Acidcat
Newbie
Joined: 13 October 2006
Status: Offline
Points: 1
|
Post Options
Thanks(0)
Quote Reply
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
|
|
