Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Recordset error
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Recordset error
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post Topic: Recordset error
    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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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?
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post Posted: 10 May 2006 at 12:22pm
Is it okay for the db to be transferred from SQL Server Express to SQL Server 2000Question 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
zac1 View Drop Down
Newbie
Newbie


Joined: 19 April 2006
Status: Offline
Points: 6 		Post Options Post Options   Thanks (0) Thanks(0)   Quote zac1 Quote  Post ReplyReply Direct Link To This Post 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 ? Embarrassed 


Edited by zac1 - 10 May 2006 at 8:55pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.