Recordset error
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=19790
Printed Date: 11 April 2026 at 10:41pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Recordset error
Posted By: iSec
Subject: Recordset error
Date Posted: 10 May 2006 at 2:38am
|
I transferred the forum database from one server to another, and now when trying to make a new post, the following error occurs:
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 did I do wrong? ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 10 May 2006 at 9:15am
|
The database has not moved across correctly to the new server. Another option to try is try setting a different locktype for the database update at line 727 of new_post.asp:- .LockType = 2 By setting to 2 will give a worse performance, but shouldn't be noticable and should sort out the problem. Let me know if it works? ------------- 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: 10 May 2006 at 9:41am
|
Didn't work. Is there an order to transfer the tables one by one? or is it okay if all tables are transferred together at the same time? ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: WebWiz-Bruce
Date Posted: 10 May 2006 at 10:30am
|
I usually use the DTS import/export tools, and select to import/export everything except user roles and permissions
------------- 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: 10 May 2006 at 12:22pm
Is it okay for the db to be transferred from SQL Server Express to SQL Server 2000 Because that's how it is now..it is sitting on a express and I'm trying to transfer it to 2000.------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: WebWiz-Bruce
Date Posted: 10 May 2006 at 12:29pm
|
I've never tried going back to an old database version of SQL server, and may well be the problem. SQL Express does has limitations and one of them is in transferring databases. ------------- 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: zac1
Date Posted: 10 May 2006 at 8:54pm
|
I have ttried to run mysql 8.01 version ad when I want to post anything it show error :
Server Error in Forum Application
An error has occured while writing to the database. Please contact the forum administrator. Support Error Code:- err_mySQL_save_new_post_data File Name:- new_post.asp Error details:- Microsoft OLE DB Provider for ODBC Drivers [Microsoft][ODBC Driver Manager] Invalid string or buffer length can anybody help me to resolve this ?
 |
Posted By: WebWiz-Bruce
Date Posted: 11 May 2006 at 9:46am
|
Sorry but what does this have to do with a topic on a recordset problem with SQL Server upgrade? Please start a new topic if you have a totally unrelated question. ------------- 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 |