ErrorSystem.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed

[Priyanka]

ErrorSystem.UnauthorizedAccessException: Retrieving the COM class
factory for component with CLSID {00024500-0000-0000-
C000-000000000046} failed due to the following error: 80070005. at
excelint.Bpopdta_Click(Object sender, EventArgs e) in c:\Inetpub
\wwwroot\adat.dlh.st.com\Priya_Setup1\excelint.aspx.cs:line 44 (->)

i hav made a connection successfully. and if i run this page on simple
machine it runs correctly..
bt if it s installed(deploying) on a file system.. it returns above
error.. plz help me out..


Excel.Application oXL;
Excel._Workbook oWB;
Excel._Worksheet oSheet;

try
{
int i = 2;
error-> oXL = new Excel.Application();
oXL.Visible = true;
oWB = (Excel._Workbook)
(oXL.Workbooks.Add(Missing.Value));
oSheet = (Excel._Worksheet)oWB.ActiveSheet; //create
table's row nd column
oSheet.get_Range("A1", "D1").Font.Bold = true;
oSheet.get_Range("A1", "D1").VerticalAlignment =
Excel.XlVAlign.xlVAlignCenter;
sqlcon.Open();
Reader = sqlcmd.ExecuteReader();
oSheet.Cells[1, 1] = "Customer Id";
oSheet.Cells[1, 2] = "Customer Name";
oSheet.Cells[1, 3] = "Address";
oSheet.Cells[1, 4] = "Order";
while (Reader.Read())
{
cust_id = Convert.ToString(Reader["cust_id"]);
c_name = Convert.ToString(Reader["c_name"]);
c_add = Convert.ToString(Reader["c_add"]);
c_order = Convert.ToString(Reader["c_order"]);
oSheet.Cells[i, 1] = cust_id;
oSheet.Cells[i, 2] = c_name;
oSheet.Cells[i, 3] = c_add;
oSheet.Cells[i, 4] = c_order;
i =i+1;

}

oXL.Visible = true;
oXL.UserControl = true;
}

catch( Exception theException )
{
String errorMessage;
errorMessage = "Error: ";
errorMessage = String.Concat( errorMessage, theException.Message );
errorMessage = String.Concat( errorMessage, " Line: " );
errorMessage = String.Concat( errorMessage, theException.Source );
Response.Write("Error" + theException);
}

[CK]

you need to grant access and create permissions to the COM+ service
for excel. look in the Component Services in Administrative Tools in
Control Panel.