Windows 2003 Server Asp.Net application for excel report is not working

Question

0.00/5 (No votes)

See more:

hi all
i have developed c# Asp.Net application for Room Booking, which gives output report in Excel format, same is working fine in xp machine where we have developed this application. But once we have hosted in server remaining all pages data gathering etc are working perfectly except excel report.

I am getting error stating that: Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space.

• To make more memory available, close workbooks or programs you no longer need.

• To free disk space, delete files you no longer need from the disk you are saving to.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space.

[COMException (0x800a03ec): Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space.

I have tried many thing which was there in google when putting this error seach. but there is no luck, Request you to provide any solution if you know.

Posted 23-Jun-11 19:51pm

Mohiyuddin Khan

Add a Solution

Comments

[no name] 24-Jun-11 1:55am

This might be because of low space in hard disk. Or there is some permission issue.

thatraja 24-Jun-11 2:26am

Yes.

Mohiyuddin Khan 1-Jul-11 2:43am

hi thatraja

If you provide full details solutions for this problem it would be great help as i am not able to find its solution with full details any where.

Thanks in Advance

Mohiyuddin Khan 24-Jun-11 8:05am

There is 26 GB space is available in server, I am using Microsoft Sever 2003 Enterprice Edition. could you please eloborate what is permission issues, and if it is there, how can i provide permission to which i have to give.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2011-06-23T20:26:00

Solution 1

Yes, it's the permission issue, see this

Problem in Microsoft.Office.Interop.Excel[^]

EDIT
--------------------------------------
Link 1[^] & Link 2[^]

Posted 23-Jun-11 20:26pm

thatraja

Updated 24-Jun-11 1:33am

v2

Comments

Mohiyuddin Khan 24-Jun-11 3:17am

i have did what you have suggested,
step1 :Go to run type dcomcnfg

Step2: Click >Component services >Computes >My Computer>Dcom config> and select micro soft Excel Application>

Step3: Right Click on microsoft Excel Application>Properties>Give Asp.net Permissions

Step 4: Select Identity table >Select interactive user >select ok

After doing that iam getting this error:
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a.
Exception Details: System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a.

Line 238: Excel.Sheets xlSheets;
Line 239: object misValue = System.Reflection.Missing.Value;
Line 240: xlApp = new Excel.ApplicationClass();

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a.]

thatraja 24-Jun-11 7:33am

Check my updated answer

Mohiyuddin Khan 24-Jun-11 8:07am

hi Thatraja, The solution what you have provided is for x86 that is 64 bit server, but here i am using 32 bit server only. and this is not working.

Mohiyuddin Khan 1-Jul-11 2:33am

hi Thatraja

Can you please eloborate what permisstion other than above i have to give for this to work now, i am getting the same error, since last 2 weeks i am not able to solve this problem, i tried to google it but every where they have mentioned this problem but non of the place they have not given full solution with details.

At present i am getting this errors.

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a.
Exception Details: System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a.

Line 238: Excel.Sheets xlSheets;
Line 239: object misValue = System.Reflection.Missing.Value;
Line 240: xlApp = new Excel.ApplicationClass();

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a.]

Mohiyuddin Khan 7-Jul-11 6:24am

Is any body expert here who can solve my problem, if yes then please provide full details what i have to do for solving this problem.