ADODB.Recordset error '800a0cc1'

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
pbanks Members Profile Find Members Posts Groupie Joined: 22 August 2008 Location: Ireland Status: Offline Points: 70	Post Options Post Reply Quote pbanks Report Post Thanks(0) Quote Reply Topic: ADODB.Recordset error '800a0cc1' 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).

123Simples Members Profile Find Members Posts Senior Member Joined: 08 July 2007 Location: United Kingdom Status: Offline Points: 1192	Post Options Post Reply Quote 123Simples Report Post Thanks(0) Quote Reply Posted: 22 August 2008 at 6:26am
	As a paid up subscriber you would do better to open a support ticket
	Visit 123 Simples Web Design

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

pbanks Members Profile Find Members Posts Groupie Joined: 22 August 2008 Location: Ireland Status: Offline Points: 70	Post Options Post Reply Quote pbanks Report Post Thanks(0) Quote Reply 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?

pbanks Members Profile Find Members Posts Groupie Joined: 22 August 2008 Location: Ireland Status: Offline Points: 70	Post Options Post Reply Quote pbanks Report Post Thanks(0) Quote Reply 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?

pbanks Members Profile Find Members Posts Groupie Joined: 22 August 2008 Location: Ireland Status: Offline Points: 70	Post Options Post Reply Quote pbanks Report Post Thanks(0) Quote Reply 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!!

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum