Web Wiz Forums - SQL Error when password protecting forum

Print Page | Close Window

SQL Error when password protecting forum

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=20149
Printed Date: 11 April 2026 at 4:33pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Error when password protecting forum

Posted By: wolfman
Subject: SQL Error when password protecting forum
Date Posted: 01 June 2006 at 9:41pm

Hi Gang,

I am getting the following error when creating a new forum with password protection. I did upgrade from Access2003 to SQL version of WWF - but this is the first time I have tried this, so I am not sure if I ever could do it. I am running 7.91

Thank you in advance.

WOLF

error:

========================================

Microsoft OLE DB Provider for SQL Server error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/admin/forum_details.asp, line 188

==========================================

Replies:

Posted By: WebWiz-Bruce
Date Posted: 01 June 2006 at 10:38pm

This error can happen if the upsize wizard in Access didn't upsize the database to SQL server correctly.

Try doing the upsize process again.

-------------
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: wolfman
Date Posted: 01 June 2006 at 10:42pm

Thanks Borg -

If I upgraded to 8, would the issue still likely exist?

Posted By: WebWiz-Bruce
Date Posted: 01 June 2006 at 10:52pm

Probally yes.

You would be better off upgrading your Access version to version 8 before moving to SQL Server

-------------
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: wolfman
Date Posted: 01 June 2006 at 10:58pm

oops - too late - I am running the SQL upgrade now with no flaws except the passworded forum issue.

I think I will wait a bit and then tackle the conversion on a test server to see what issues I may encounter.

Thanks - I appreciate your insight.

Cheers