Web Wiz Forums - Suspend User Error

Print Page | Close Window

Suspend User Error

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=24555
Printed Date: 06 April 2026 at 1:38pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Suspend User Error

Posted By: pould
Subject: Suspend User Error
Date Posted: 01 October 2007 at 7:40am

Trying to suspend a user, but when I click the button to edit settings I get this error message:

------------

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

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

/forum/admin_register.asp, line 394

----------------

Using 9.0.5 registered. Any ideas?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 01 October 2007 at 9:55am

This will be looked into, for the moment you can suspend users from within the main forum pages by editing their forum profile when logged in as the forum admin.

-------------
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: WebWiz-Bruce
Date Posted: 01 October 2007 at 9:56am

By the way to try and replicate this do you have any unusual settings like using the Member API, or the Windows Active Directory API?

-------------
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: pould
Date Posted: 01 October 2007 at 2:43pm

When I try and moderate (logged in) from the front end I get the following:

-------------

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

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

/forum/register.asp, line 939

----------------------

As to your API questions, not my strong point, but happy to host any files / make inquiries that might help.

The server is PHP4 based Windows IIS (I think). I can do a phpinfo (or equivalent) if that would help.

Posted By: pould
Date Posted: 01 October 2007 at 3:08pm

Oh and I forget to say "thanks" for any help you can give.

"Thanks"

Posted By: WebWiz-Bruce
Date Posted: 01 October 2007 at 4:05pm

I take it as you are asking about hosting the API you are not using it otherwise you would know what it is.

The forum is written in ASP, so the version of PHP installed on the server makes no difference as PHP support is not a requirement.

All really need to know is the Web Wiz Forums version and the database type you are using? (eg. Access, SQL Server)

Also check the server requirements page to make sure that the server is an Windows 2000, 2003, or 2008 server with IIS and with ASP enabled.

-------------
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: pould
Date Posted: 01 October 2007 at 4:56pm

IIS6 2003 Windows Server - MySQL 5 database
We use version 9.0.5 of the forum software.

Posted By: WebWiz-Bruce
Date Posted: 01 October 2007 at 5:05pm

If you are using mySQL 5 then the problem looks like you have changed the default driver as the error is thrown up by:-

Microsoft OLE DB Provider for ODBC Drivers

This is a Microsoft driver error, when using the mySQL versions you should be using the myODBC 3.51 driver.

Have you edited the database_connection.asp file to use a different driver? Also check that it is the mySQL version you are using and not the SQL Server version.

-------------
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: pould
Date Posted: 01 October 2007 at 5:14pm

That's what I thought, but the file is setup correctly.

In the Database System Type Section I have removed the ' in front of the MySQL line and left it on the other 4.

In the relevant places underneath "Enter the details of your Microsoft SQL...." section I have completed the four lines as appropriate. The forum is accessing the database fine with users posting messages etc

Posted By: WebWiz-Bruce
Date Posted: 02 October 2007 at 8:46am

There is no reason why you would get this error, and can only think it's some type of server issue, as we have over 200 mySQL 5 Web Wiz Forums running on our own servers here without any such issue, and as of yet no-one else has reported this issue.

-------------
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: pould
Date Posted: 02 October 2007 at 9:59am

OK,

Is there anything I can do my end to help you work out what's going on?

Posted By: WebWiz-Bruce
Date Posted: 02 October 2007 at 11:21am

If you have support I suggest that you login into the Client Area and contact support giving details of your forum, server, and login details so that support staff can lo into your forum and try and workout what the problem is.

-------------
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