Web service in .net not able to create Excel com object

[Nalina Vemparala via .NET 247]

(Type your message here)
Hi!
I created a web service in .net where in the web method makes call to a function in which I am creating an excel object using
Dim objXl As New Microsoft.Office.Interop.Excel.Application()
objXl.Workbooks.Open("C:\C\Test.xls")
objXl.Visible = True
However, I am getting the error Access denied, Cannot create Activex component.
The same code works in a ASP page and also in .net windows application.
But if I access this code through web service I get the error Access denied, Cannot create Activex component.
I checked the permissions etc for this web service project
Could anyone please help me please.
--------------------------------
From: Nalina Vemparala

-----------------------
Posted by a user from .NET 247 ([url]http://www.dotnet247.com/[/url])

<Id>K4FlI6gD5EyFFDUQg55O5g==</Id>

[Joe H]

the asp.net process runs under a special user. that user will not by
default have rights to resources outside the scope of the web service.
imagine what would happen if a web service could call ANY code on your
server. there are many ways to approach this depending on your environment
and what it is that you are trying to achieve. but at the most basic level,
you need to give the aspnet user the rights to launch excel.

"Nalina Vemparala via .NET 247" <anonymous@dotnet247.com> wrote in message
news:#tvUZyMJEHA.1192@TK2MSFTNGP11.phx.gbl...

> (Type your message here)
> Hi!
> I created a web service in .net where in the web method makes call to a

function in which I am creating an excel object using

> Dim objXl As New Microsoft.Office.Interop.Excel.Application()
> objXl.Workbooks.Open("C:\C\Test.xls")
> objXl.Visible = True
> However, I am getting the error Access denied, Cannot create Activex

component.

> The same code works in a ASP page and also in .net windows application.
> But if I access this code through web service I get the error Access

denied, Cannot create Activex component.

> I checked the permissions etc for this web service project
> Could anyone please help me please.
> --------------------------------
> From: Nalina Vemparala
>
> -----------------------
> Posted by a user from .NET 247 ([url]http://www.dotnet247.com/[/url])
>
> <Id>K4FlI6gD5EyFFDUQg55O5g==</Id>

[Dino Chiesa [Microsoft]]

Also, let's repeat that MS Office components were not designed to be used
from within server-based apps such as ASP.NET webservices (or ASP Pages for
that matter).

[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;257757[/url]


--
Dino Chiesa
Microsoft Developer Division
d i n o c h @ ElideThis . m i c r o s o f t . c o m



"Joe H" <jharri@hotmail.com> wrote in message
news:%23HNzjCVJEHA.2380@TK2MSFTNGP09.phx.gbl...

> the asp.net process runs under a special user. that user will not by
> default have rights to resources outside the scope of the web service.
> imagine what would happen if a web service could call ANY code on your
> server. there are many ways to approach this depending on your

environment

> and what it is that you are trying to achieve. but at the most basic

level,

> you need to give the aspnet user the rights to launch excel.
>
> "Nalina Vemparala via .NET 247" <anonymous@dotnet247.com> wrote in message
> news:#tvUZyMJEHA.1192@TK2MSFTNGP11.phx.gbl...

> > (Type your message here)
> > Hi!
> > I created a web service in .net where in the web method makes call to a

> function in which I am creating an excel object using

> > Dim objXl As New Microsoft.Office.Interop.Excel.Application()
> > objXl.Workbooks.Open("C:\C\Test.xls")
> > objXl.Visible = True
> > However, I am getting the error Access denied, Cannot create Activex

> component.

> > The same code works in a ASP page and also in .net windows application.
> > But if I access this code through web service I get the error Access

> denied, Cannot create Activex component.

> > I checked the permissions etc for this web service project
> > Could anyone please help me please.
> > --------------------------------
> > From: Nalina Vemparala
> >
> > -----------------------
> > Posted by a user from .NET 247 ([url]http://www.dotnet247.com/[/url])
> >
> > <Id>K4FlI6gD5EyFFDUQg55O5g==</Id>

>
>

[freekamel]

Hi,
use "dcomcnfg.exe" to config your policy for Dcom
select the "Default Security pane", insert user everyOne and give it "special Access" right into the tre
option allowed
Restart Your system and good luck

N.B.: Word works very well but Excel not finds the default printer specified i
system registrykeys "[HKEY_USERS\.DEFAULT\Software\Microsoft\Windows NT\CurrentVersion\"
devices, printerports and windows like Microsoft suggests