I get COMException while exporting chart on IIS 6.0.

[asp newbie]

I have this code that works perfectly on my development machine when I
deployed it at customer site it gets exception. Here is the error and my code:

thanks

error
==========
Exception from HRESULT: 0x800A03EC.
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: Exception
from HRESULT: 0x800A03EC.

Source Error:

An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.

Stack Trace:


[COMException (0x800a03ec): Exception from HRESULT: 0x800A03EC.]
Excel._Chart.Export(String Filename, Object FilterName, Object
Interactive) +0
apac2.WebForm1.copyDataAndRunMacro(String fName, String eventdir)
apac2.WebForm1.uploadButton_Click(Object sender, EventArgs e)
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292



my code
========
Excel.Range chartRange = dstMsh.get_Range("B15", "D" +
chartData.ToString());
Excel.ChartObjects chObjs =
(Excel.ChartObjects)dstMsh.ChartObjects(Type.Missing);
Excel.ChartObject chObj = chObjs.Add(100, 200, 400, 300);
Excel.Chart chart = chObj.Chart;

chart.SetSourceData(chartRange, Type.Missing);
chart.ChartType = Excel.XlChartType.xlBarClustered;

string imgDir = "C:\\inetpub\\wwwroot\\apacevent\\images\\";
string imgSaveAs = getCurrentTime()+ "_chart.gif";
chart.Export(imgDir + imgSaveAs, "GIF", false);

imgChart.Visible = true;
imgChart.ImageUrl = "images\\" + imgSaveAs;

[Andy Pope]

Hi,

I have no idea why you code is not working but does it make sense to
name your variable, chart, with the same name as an existing excel
object type?

Cheers
Andy

asp newbie wrote:
> I have this code that works perfectly on my development machine when I
> deployed it at customer site it gets exception. Here is the error and my code:
>
> thanks
>
> error
> ==========
> Exception from HRESULT: 0x800A03EC.
> 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: Exception
> from HRESULT: 0x800A03EC.
>
> Source Error:
>
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
>
> Stack Trace:
>
>
> [COMException (0x800a03ec): Exception from HRESULT: 0x800A03EC.]
> Excel._Chart.Export(String Filename, Object FilterName, Object
> Interactive) +0
> apac2.WebForm1.copyDataAndRunMacro(String fName, String eventdir)
> apac2.WebForm1.uploadButton_Click(Object sender, EventArgs e)
> System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
>
> System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
> System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument) +18
> System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
> System.Web.UI.Page.ProcessRequestMain() +1292
>
>
>
> my code
> ========
> Excel.Range chartRange = dstMsh.get_Range("B15", "D" +
> chartData.ToString());
> Excel.ChartObjects chObjs =
> (Excel.ChartObjects)dstMsh.ChartObjects(Type.Missing);
> Excel.ChartObject chObj = chObjs.Add(100, 200, 400, 300);
> Excel.Chart chart = chObj.Chart;
>
> chart.SetSourceData(chartRange, Type.Missing);
> chart.ChartType = Excel.XlChartType.xlBarClustered;
>
> string imgDir = "C:\\inetpub\\wwwroot\\apacevent\\images\\";
> string imgSaveAs = getCurrentTime()+ "_chart.gif";
> chart.Export(imgDir + imgSaveAs, "GIF", false);
>
> imgChart.Visible = true;
> imgChart.ImageUrl = "images\\" + imgSaveAs;
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info