Solved

Dreaded Multiple Step OLEDB operation error when uploading a file under ASP

Posted on 2004-08-13
19
224 Views
Last Modified: 2008-03-03
Hi,
I'm getting the Multiple-step OLE DB operation generated errors message on one of my user when he tries to upload a .doc file. He can upload a PDF or XLS though...
I really have a hard time figuring this one out. THey are really 3-4 users with this problem but they are in a plant far from here.

I'm using IIS6 on a Win2k3 Server with SQL Server 2000 version 8.00.194.
I have MDAC 2.8 on the server. Correct me if I'm wrong but I don't think that the MDAC on  the client is revelant.

I upload into an image field using the script posted there: http://www.stardeveloper.com/articles/display.html?article=2001042501&page=1
I tested this one and got the same error:http://www.tek-tips.com/gfaqs.cfm/lev2/4/lev3/32/pid/329/fid/1869

Thanks.
-Jonthemoon

0
Comment
Question by:Jonthemoon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 10
  • 4
  • 3
  • +1
19 Comments
 
LVL 4

Expert Comment

by:rlibrandi
ID: 11793587
MDAC on the client is irrelevant, but it DOES matter on your IIS server.....
0
 
LVL 4

Expert Comment

by:rlibrandi
ID: 11793597
P.S.

....cause your IIS box is actually the SQL Server client.....
0
 
LVL 3

Author Comment

by:Jonthemoon
ID: 11793612
Yeah that's what I tought.
It's already updated to the last version so...
0
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 
LVL 3

Author Comment

by:Jonthemoon
ID: 11793964
Update:

The user tried on a Win2K machine and it worked. But it work on my XP so the problem is most likely a configuration on his PC than the window's version...


0
 
LVL 4

Expert Comment

by:rlibrandi
ID: 11795193
Are they different versions of Word?
0
 
LVL 3

Author Comment

by:Jonthemoon
ID: 11796091
There must be documents from Office 2K and XP uploaded as both are present in our environment.
The thing is 3-4 users can't upload .doc files.
The user I'm working with tried with a couple Word documents and none worked...

-Jonthemoon
0
 
LVL 3

Author Comment

by:Jonthemoon
ID: 11945531
Update...
The client is runing on Manage Workplace and his computer is a Fat Client. It seems like it's a security issue and that Thin Clients don't have that problem.

Still investigating...
-Jonthemoon
0
 
LVL 3

Author Comment

by:Jonthemoon
ID: 11972549
Hum...
Got another user that have that problem and he'S not on Fat Client...

I really need a solution for that.
If someone got the answer, I'm opening another question of 500 pts and give them to him!

-Jonthemoon
0
 
LVL 3

Author Comment

by:Jonthemoon
ID: 11972619
0
 
LVL 4

Expert Comment

by:rlibrandi
ID: 11972654
What does your  upload code look like?
0
 
LVL 11

Expert Comment

by:raj3060
ID: 11972782
Check your web deployement descripter file and then see in the source code if you see something like this

<mime-mapping>
<extension>.doc</extension>
<mime-type>application/msword</mime-type>
</mime-mapping>

if not add this to it.

I hope this works for you.
--Raj
0
 
LVL 3

Author Comment

by:Jonthemoon
ID: 11972858
rlibrandi,
see the code at http://www.stardeveloper.com/articles/display.html?article=2001042501&page=1

raj,
Could you enlighten me on the descripter file??? Where I find it?

-Jonthemoon
0
 
LVL 11

Expert Comment

by:raj3060
ID: 11973232
Where is the code, if you could please give me the link, or specify how to access your code I might be able to see it.
0
 
LVL 3

Author Comment

by:Jonthemoon
ID: 12030658
Hi,
The solution is kinda half solved now. Our network Admin found something on the IIS about allowin .doc files. I'll ask him what he did and post it here for future reference.
I'll give the 500pts to Raj because he pointed it out.
We still have a couple of users that still have that trouble so I'm not giving all pts.
But hey, 500 is nat half bad!!! :-D
(Points were given on the other question I had on that subject... See http://www.experts-exchange.com/Web/Q_21118101.html)

Thx to all
-Jonthemoon
0
 
LVL 3

Author Comment

by:Jonthemoon
ID: 12030669
Solution was found here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;234497&Product=iis60


Admin, could you refund this question?


-JTM
0
 
LVL 11

Expert Comment

by:raj3060
ID: 12380496
>>I'll give the 500pts to Raj because he pointed it out.

I was wondering if that was for this question. If so then I should get the points.
0
 
LVL 3

Author Comment

by:Jonthemoon
ID: 12380887
It was for the other question I had opened for the same matter.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 12405543
PAQed, with points refunded (500)

Computer101
E-E Admin
0

Featured Post

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question