Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

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

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
Jonthemoon
Asked:
Jonthemoon
  • 10
  • 4
  • 3
  • +1
1 Solution
 
rlibrandiCommented:
MDAC on the client is irrelevant, but it DOES matter on your IIS server.....
0
 
rlibrandiCommented:
P.S.

....cause your IIS box is actually the SQL Server client.....
0
 
JonthemoonAuthor Commented:
Yeah that's what I tought.
It's already updated to the last version so...
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
JonthemoonAuthor Commented:
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
 
rlibrandiCommented:
Are they different versions of Word?
0
 
JonthemoonAuthor Commented:
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
 
JonthemoonAuthor Commented:
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
 
JonthemoonAuthor Commented:
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
 
JonthemoonAuthor Commented:
0
 
rlibrandiCommented:
What does your  upload code look like?
0
 
raj3060Commented:
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
 
JonthemoonAuthor Commented:
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
 
raj3060Commented:
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
 
JonthemoonAuthor Commented:
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
 
JonthemoonAuthor Commented:
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
 
raj3060Commented:
>>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
 
JonthemoonAuthor Commented:
It was for the other question I had opened for the same matter.
0
 
Computer101Commented:
PAQed, with points refunded (500)

Computer101
E-E Admin
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 10
  • 4
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now