Web Wiz Support and Community Forums : Recordset error https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 22:36:43 +0000 Thu, 11 May 2006 09:46:19 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19790 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Recordset error : Sorry but what does this have...]]> https://forums.webwiz.net/recordset-error_topic19790_post106733.html#106733 Author: WebWiz-Bruce
Subject: 19790
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.
]]> Thu, 11 May 2006 09:46:19 +0000 https://forums.webwiz.net/recordset-error_topic19790_post106733.html#106733 <![CDATA[Recordset error : I have ttried to run mysql 8.01...]]> https://forums.webwiz.net/recordset-error_topic19790_post106696.html#106696 Author: zac1
Subject: 19790
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]]> Wed, 10 May 2006 20:54:22 +0000 https://forums.webwiz.net/recordset-error_topic19790_post106696.html#106696 <![CDATA[Recordset error : I&#039;ve never tried going back...]]> https://forums.webwiz.net/recordset-error_topic19790_post106678.html#106678 Author: WebWiz-Bruce
Subject: 19790
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.
]]> Wed, 10 May 2006 12:29:55 +0000 https://forums.webwiz.net/recordset-error_topic19790_post106678.html#106678 <![CDATA[Recordset error : Is it okay for the db to be transferred...]]> https://forums.webwiz.net/recordset-error_topic19790_post106674.html#106674 Author: iSec
Subject: 19790
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.]]> Wed, 10 May 2006 12:22:49 +0000 https://forums.webwiz.net/recordset-error_topic19790_post106674.html#106674 <![CDATA[Recordset error : I usually use the DTS import/export...]]> https://forums.webwiz.net/recordset-error_topic19790_post106666.html#106666 Author: WebWiz-Bruce
Subject: 19790
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]]> Wed, 10 May 2006 10:30:04 +0000 https://forums.webwiz.net/recordset-error_topic19790_post106666.html#106666 <![CDATA[Recordset error : Didn&#039;t work. Is there an...]]> https://forums.webwiz.net/recordset-error_topic19790_post106664.html#106664 Author: iSec
Subject: 19790
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? ]]> Wed, 10 May 2006 09:41:19 +0000 https://forums.webwiz.net/recordset-error_topic19790_post106664.html#106664 <![CDATA[Recordset error : The database has not moved across...]]> https://forums.webwiz.net/recordset-error_topic19790_post106657.html#106657 Author: WebWiz-Bruce
Subject: 19790
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?
]]> Wed, 10 May 2006 09:15:16 +0000 https://forums.webwiz.net/recordset-error_topic19790_post106657.html#106657 <![CDATA[Recordset error : I transferred the forum database...]]> https://forums.webwiz.net/recordset-error_topic19790_post106637.html#106637 Author: iSec
Subject: 19790
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?
]]> Wed, 10 May 2006 02:38:07 +0000 https://forums.webwiz.net/recordset-error_topic19790_post106637.html#106637