Print Page | Close Window

SQL Error '80040e21'

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=20722
Printed Date: 11 April 2026 at 10:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: SQL Error '80040e21'
Posted By: lodogg
Subject: SQL Error '80040e21'
Date Posted: 17 July 2006 at 3:59pm

I went to modify one of my posts to upload more pictures, this is something I do alot and I got the following error?

SELECT tblThread.Thread_ID, tblThread.Author_ID, tblThread.Message, tblThread.Show_signature, tblThread.IP_addr, tblThread.Hide, tblThread.File_uploads FROM tblThread WITH (ROWLOCK) WHERE tblThread.Thread_ID=3575;

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/edit_post.asp, line 557


Thanks,
-lo


-------------
Just trying to have some fun and learn in the process.
http://www.lodogg.com - Come have Some Fun



Replies:
Posted By: WebWiz-Bruce
Date Posted: 18 July 2006 at 10:29am
Does this happen all the time? Or just when you try to add more than 5 images to a post?

-------------
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: lodogg
Date Posted: 18 July 2006 at 9:27pm
This happens when I go back to a post and choose Edit and then upload several pictures at one time I get the error posted above:\

My work around was to just make another post below it to append to the thread.

-------------
Just trying to have some fun and learn in the process.
http://www.lodogg.com - Come have Some Fun


Posted By: WebWiz-Bruce
Date Posted: 19 July 2006 at 9:16am
Because of the way database work, for performance reasons you can only have upto 5 or 6 image/file uploads per post, depending on the length of the file name.

The next version has been adapted so you wouldn't get the error message, but the limitation is still there.

If you want to have lots of image/file uploads then you would need to spread them across multiple posts.


-------------
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: lodogg
Date Posted: 24 July 2006 at 7:30pm

I take that was a code change since 7.97?  I was able to upload tons of images per post.  I actually like to post a bunch of images under one post but that’s me.

If I shorten the file name down to 1.jpg,  2.jpg etc will I be able to post more than 5 or  6 at a time?
 

Thanks for the feedback..

-lodogg



-------------
Just trying to have some fun and learn in the process.
http://www.lodogg.com - Come have Some Fun


Posted By: WebWiz-Bruce
Date Posted: 25 July 2006 at 8:44am
Version 7 never associated posts and uploads which allot of people didn't like as uploads had to be manually removed.

Version 8 associates uploads with posts so that when the post is removed so is the uploaded file.

By shortening the name of the uploaded file you will be able to upload more 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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net