p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_components thread: Permission Denied when launching Excel


Message #1 by "Martijn W. Coppoolse" <p2p.wrox.com+asp_components@m...> on Mon, 3 Jun 2002 15:21:22
Hi all,

We're running a web application that's supposed to extract data from an 
Excel sheet into a database.  For this, we use an ASP pages.  In the ASP 
page, we create a VB object. That object then tries to open an Excel sheet 
on the network by calling the excel automation interface (GetObject 
("\\computer\share\folder\sheet.xls")).  This is where the error occurs, 
and it also happens if we use the Set objXL = New Excel.Application syntax.

Now when we run the client and the server on the same machine, it works
fine: on the development machine, which runs its own server, ok.  On the
Web server, when using IE on the same machine, ok.  When using IE on any 
other machine to call the web server, we get 'Permission denied' on the 
creation of the Excel application object.

We've already tried to add the IUSR_-account to the Administrators group, 
but that didn't help.

Any idea how to solve this?  Or at least, where the problem lies?

TIA,

Martijn Coppoolse
Message #2 by =?iso-8859-1?Q?Fl=E1vio_Rodrigues_Maciel?= <flaviorm@p...> on Mon, 3 Jun 2002 12:26:38 -0300
Have you tried to add Write permission to the \\computer\share\folder for
IUSR_computer? It's probably needed for temporary files created during
access. I know turning IUSR into administrator should've worked, but it's a
possibility.

----- Original Message -----
From: "Martijn W. Coppoolse"
<p2p.wrox.com+asp_components@m...>
To: "ASP components" <asp_components@p...>
Sent: Monday, June 03, 2002 3:21 PM
Subject: [asp_components] Permission Denied when launching Excel


> Hi all,
>
> We're running a web application that's supposed to extract data from an
> Excel sheet into a database.  For this, we use an ASP pages.  In the ASP
> page, we create a VB object. That object then tries to open an Excel sheet
> on the network by calling the excel automation interface (GetObject
> ("\\computer\share\folder\sheet.xls")).  This is where the error occurs,
> and it also happens if we use the Set objXL = New Excel.Application
syntax.
>
> Now when we run the client and the server on the same machine, it works
> fine: on the development machine, which runs its own server, ok.  On the
> Web server, when using IE on the same machine, ok.  When using IE on any
> other machine to call the web server, we get 'Permission denied' on the
> creation of the Excel application object.
>
> We've already tried to add the IUSR_-account to the Administrators group,
> but that didn't help.
>
> Any idea how to solve this?  Or at least, where the problem lies?
>
> TIA,
>
> Martijn Coppoolse
>
flaviorm@p...
%%email.unsub%%
>
>

Message #3 by "Adrian Forbes" <adrian.forbes@n...> on Wed, 5 Jun 2002 09:16:50 +0100
> We've already tried to add the IUSR_-account to the Administrators
> group, but that didn't help.

IUSR is a local account on the webserver and doesn't have any access to
other machines regardless of the permissions.  Easiest way is to change the
anon access user from IUSR to a domain account that you have created.  You
will then have access to machines that that account has access to.

Message #4 by Javier Pi <jpi@e...> on Thu, 13 Jun 2002 11:02:23 -0400
I had the same probleme. The difference was that the developpment server is a 2000
server and the other is a nt 4.0. NT 4.0 need a special permission.

Flavio, si necesitas mas info, no dudes en contactarme por email.

Javier


Flávio Rodrigues Maciel wrote:

> Have you tried to add Write permission to the \\computer\share\folder for
> IUSR_computer? It's probably needed for temporary files created during
> access. I know turning IUSR into administrator should've worked, but it's a
> possibility.
>
> ----- Original Message -----
> From: "Martijn W. Coppoolse"
> <p2p.wrox.com+asp_components@m...>
> To: "ASP components" <asp_components@p...>
> Sent: Monday, June 03, 2002 3:21 PM
> Subject: [asp_components] Permission Denied when launching Excel
>
> > Hi all,
> >
> > We're running a web application that's supposed to extract data from an
> > Excel sheet into a database.  For this, we use an ASP pages.  In the ASP
> > page, we create a VB object. That object then tries to open an Excel sheet
> > on the network by calling the excel automation interface (GetObject
> > ("\\computer\share\folder\sheet.xls")).  This is where the error occurs,
> > and it also happens if we use the Set objXL = New Excel.Application
> syntax.
> >
> > Now when we run the client and the server on the same machine, it works
> > fine: on the development machine, which runs its own server, ok.  On the
> > Web server, when using IE on the same machine, ok.  When using IE on any
> > other machine to call the web server, we get 'Permission denied' on the
> > creation of the Excel application object.
> >
> > We've already tried to add the IUSR_-account to the Administrators group,
> > but that didn't help.
> >
> > Any idea how to solve this?  Or at least, where the problem lies?
> >
> > TIA,
> >
> > Martijn Coppoolse
> >
> flaviorm@p...
> %%email.unsub%%
> >
> >
>
>
> To unsubscribe send a blank email to %%email.unsub%%
>


  Return to Index