Web Wiz Support and Community Forums : SQL Error '80040e21' https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 08:59:40 +0000 Tue, 25 Jul 2006 08:44:26 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20722 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL Error '80040e21' : Version 7 never associated posts...]]> https://forums.webwiz.net/sql-error-80040e21_topic20722_post111421.html#111421 Author: WebWiz-Bruce
Subject: 20722
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.
]]> Tue, 25 Jul 2006 08:44:26 +0000 https://forums.webwiz.net/sql-error-80040e21_topic20722_post111421.html#111421 <![CDATA[SQL Error '80040e21' : I take that was a code change...]]> https://forums.webwiz.net/sql-error-80040e21_topic20722_post111398.html#111398 Author: lodogg
Subject: 20722
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 perpost.  I actually like to post a bunch ofimages 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 5or  6 at a time?
 

Thanks for the feedback..

-lodogg

]]> Mon, 24 Jul 2006 19:30:01 +0000 https://forums.webwiz.net/sql-error-80040e21_topic20722_post111398.html#111398 <![CDATA[SQL Error '80040e21' : Because of the way database work,...]]> https://forums.webwiz.net/sql-error-80040e21_topic20722_post111120.html#111120 Author: WebWiz-Bruce
Subject: 20722
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.
]]> Wed, 19 Jul 2006 09:16:23 +0000 https://forums.webwiz.net/sql-error-80040e21_topic20722_post111120.html#111120 <![CDATA[SQL Error '80040e21' : This happens when I go back to...]]> https://forums.webwiz.net/sql-error-80040e21_topic20722_post111098.html#111098 Author: lodogg
Subject: 20722
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.]]> Tue, 18 Jul 2006 21:27:32 +0000 https://forums.webwiz.net/sql-error-80040e21_topic20722_post111098.html#111098 <![CDATA[SQL Error '80040e21' : Does this happen all the time?...]]> https://forums.webwiz.net/sql-error-80040e21_topic20722_post111063.html#111063 Author: WebWiz-Bruce
Subject: 20722
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?]]> Tue, 18 Jul 2006 10:29:29 +0000 https://forums.webwiz.net/sql-error-80040e21_topic20722_post111063.html#111063 <![CDATA[SQL Error '80040e21' : I went to modify one of my posts...]]> https://forums.webwiz.net/sql-error-80040e21_topic20722_post111001.html#111001 Author: lodogg
Subject: 20722
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
]]> Mon, 17 Jul 2006 15:59:46 +0000 https://forums.webwiz.net/sql-error-80040e21_topic20722_post111001.html#111001