Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - SQL Server error ’80040e21’
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL Server error ’80040e21’
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
whittibo View Drop Down
Groupie
Groupie


Joined: 24 May 2003
Location: United States
Status: Offline
Points: 180 		Post Options Post Options   Thanks (0) Thanks(0)   Quote whittibo Quote  Post ReplyReply Direct Link To This Post Topic: SQL Server error ’80040e21’
    Posted: 02 October 2003 at 9:22am

Hello!

Everything on my forum is running PERFECTLY .. until "Admin" trys to post..    here is the error I get..

 

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.

/forum/post_message.asp, line 604

 

Nobody else seems to be having this problem.. just the admin.. can anyone help me fix it?! 

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 02 October 2003 at 9:27am
What version are you running?
What does line 604 say?
Does it happen when replying to posts or new posts or both?
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
whittibo View Drop Down
Groupie
Groupie


Joined: 24 May 2003
Location: United States
Status: Offline
Points: 180 		Post Options Post Options   Thanks (0) Thanks(0)   Quote whittibo Quote  Post ReplyReply Direct Link To This Post Posted: 02 October 2003 at 9:34am

THANK YOU BORG!!! 

ok.. lets see.. version 7.01  SQL

forum/post_message.asp  says   .Fields("Subject") = strSubject

I have only tried a new message.. let me go try a reply!  I'll be back!

Back to Top
whittibo View Drop Down
Groupie
Groupie


Joined: 24 May 2003
Location: United States
Status: Offline
Points: 180 		Post Options Post Options   Thanks (0) Thanks(0)   Quote whittibo Quote  Post ReplyReply Direct Link To This Post Posted: 02 October 2003 at 9:35am

OK.. just posted a reply.. went perfectly!

is that good or bad?

Back to Top
whittibo View Drop Down
Groupie
Groupie


Joined: 24 May 2003
Location: United States
Status: Offline
Points: 180 		Post Options Post Options   Thanks (0) Thanks(0)   Quote whittibo Quote  Post ReplyReply Direct Link To This Post Posted: 02 October 2003 at 9:40am

OK.. very odd..

I just changed the topic title.. and now it works.

could my title have been too long??   would that have caused it?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 02 October 2003 at 9:56am
This error sometimes does occur if the data input is two long.

The subject title field in the database is much larger than that allowed to be input to try and prevent this, but the security filters do sometimes encode characters thus increasing the number of characters, in normal cercumstances this should be fine but sometimes as in this case many more characters must have been encoded than the database field size could cope with.

The max characters allowed in the text box is 41 and the database feild size is 70 so this should be almost impossible. Have you increased the amount of characters allowed for the subject of a post?


Edited by -boRg-
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
whittibo View Drop Down
Groupie
Groupie


Joined: 24 May 2003
Location: United States
Status: Offline
Points: 180 		Post Options Post Options   Thanks (0) Thanks(0)   Quote whittibo Quote  Post ReplyReply Direct Link To This Post Posted: 02 October 2003 at 10:04am

WEELLL.. now that you mention it.. I think I did change the field size for when a Poll is posted.  is that the same field? 

I followed instructions found here.  and that was before I switched to SQL  so that could very well be causing the problem then..

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 02 October 2003 at 11:09am
You may need to increase some of the field sizes in the database relating to those input boxes you increased the size on.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.