ADODB.Recordset error '800a0cc1'
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=26149
Printed Date: 03 April 2026 at 9:48am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: ADODB.Recordset error '800a0cc1'
Posted By: pbanks
Subject: ADODB.Recordset error '800a0cc1'
Date Posted: 22 August 2008 at 1:24am
|
I've just upgraded my old 8.0o5 Access database to the latest release SQL (fully paid up) and have successfully upsized all my dtabases (nearly 200Mb). I am at this moment uploading all the 'uploads' files which are also another 200Mb. But, I am getting a horrid error when I try and view 'member profiles' - the error is as follows:
ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the requested name or ordinal. /Forum/member_profile.asp, line 174 I cannot even view my own profile as an admin? Is this because the upload haven't finished or is their something more here?
PS. I upgraded to the SQL version because 8.05 was creaking at the seams, but |I'm not sure that the page loading is any quicker and the real problem was ALWAYS people trying to upload images (as I and a tester have tried) which immediately shows Permissioning problems??!!
Otherwise, after five years of using this brilliant package I am a huge fan and want to continue using it (especially after I've forked out money for it).
|
Replies:
Posted By: 123Simples
Date Posted: 22 August 2008 at 6:26am
As a paid up subscriber you would do better to open a support ticket 
------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: WebWiz-Bruce
Date Posted: 22 August 2008 at 8:21am
|
pbanks, did you use the database upgrade tool to upgrade your 8.x database to a 9.x database. Seems that error message is looking for new database fields in the 9.x database. To upgrade your database from 8.x to 9.x there are database upgrade tools located in the Web Wiz Forums zip file that you download from this site. ------------- 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: pbanks
Date Posted: 22 August 2008 at 8:58am
|
Yes, I did the upgrade from 8.05 to 9.5 (though it did complain at the end that I already had the field 'Gender' in tbl.Author). Otherwise, the whole thing works perfectly OK.
As the whole upsizing process took a VERY long time I'm a little loathe to have to redo the whole process from the original Access mdb. Though if this is required I will do it again.
Is there perhaps an extra field in one of the tables that I might need to delete for this version to work correctly?
|
Posted By: pbanks
Date Posted: 22 August 2008 at 9:25am
|
I have checked through the SQL database and it DOES appear that there are a couple of fields missing because it failed to update. It is only in the tblAuthor that I can see that there has been an error:
'Update tblAuthor
strSQL = "ALTER TABLE [" & strDbTable & "Author] ADD " strSQL = strSQL & "[Gender] VARCHAR (10) NULL ," strSQL = strSQL & "[Photo] VARCHAR (100) NULL ," strSQL = strSQL & "[Newsletter] YESNO NOT NULL DEFAULT 1 " I already had the 'Gender' in there from a previous mod. However, it hasn't then added Photo and Newsletter. Is there any way that I could add these two fields (and, perhaps amend the Gender) using an SQL query so that |I don't have to re-run the upsize?
|
Posted By: pbanks
Date Posted: 22 August 2008 at 9:59am
|
I have fixed the above by adding the two fields to the table successfully, but am now getting a totally different problem when users are trying to post a new thread:
Server Error in Forum Application
An error has occurred 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. Ouch ... please help as my users are going mad!!
|
Posted By: WebWiz-Bruce
Date Posted: 22 August 2008 at 5:31pm
|
This error is common if the upsizing of the database didn't go correctly. Have upsized many Web Wiz Forums Access databases to SQL Server and found the best way is:- 1. Compact and repair the database in MS Access 2. Upgrade the database to the latest version 3. Compact and repair the database again (very important) 4. For best results use the upsize wizard in Access 2007 and have it create a new database on SQL Server 2005 (this can be the free Express Edition). If you then need to move the database do NOT use the import/export tools in SQL Management Studio as these are next to usless as they drop allot of the database schema. If you need to move the SQL Server database you should eiher create a backup of the database (a .bak file) or detach the database from the server and move the .mdf and .ldf files to the new SQL Server were you need to reattach the files. ------------- 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 |