Re: Using Excel through COM interop in ASP.Net--need a little more hel

Tech-Archive recommends: Speed Up your PC by fixing your registry




"Mark Miller" <MarkMiller@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0ED5361D-C65B-403E-BD1C-ACE147B3A7B6@xxxxxxxxxxxxxxxx
> I'm trying to run Excel on the server side, uploading an Excel file to the
> server and having it processed there.
>
> I've read elsewhere about how to configure security for this, but I'm
> unclear on all I need to do.
>
> The advice I've read is to use dcomcnfg.exe to grant access and execute
> rights to the ASPNET user for Microsoft Excel Application. I've done
> this,
> but when I run my ASP.Net app., I still get the same error: "Unable to
> create
> ActiveX control".
>
> What I'm unclear about is, I've heard I need to do something in the
> Identity
> tab of the properties, but I'm not sure what. There are a few selections:
>
> - The interactive user
> - The launching user
> - This user (followed by textboxes for userID and password)
>
> I've tried selecting "This user" and entering the ASPNET ID, but dcomcnfg
> apparently thinks the ASPNET ID has an associated password. I don't know
> what it is. I've tried the other settings "The interactive user" and "The
> launching user", but I get the same result.
>
> I need a little more help here.
>
> Thanks,
>
> ---Mark
>

No, it's the security tab you have to select and gran launch and access
permissions to aspnet.

Willy.
Note that using Office server side is not supported and in general doesn't
work at all.


.



Relevant Pages

  • Using Excel through COM interop in ASP.Net--need a little more hel
    ... I'm trying to run Excel on the server side, uploading an Excel file to the ... I've tried selecting "This user" and entering the ASPNET ID, ... launching user", but I get the same result. ...
    (microsoft.public.dotnet.framework.interop)
  • Re: Using Excel through COM interop in ASP.Net--need a little more
    ... I had Microsoft Excel Application set to Local ... Launch and Local Access for the ASPNet user, though I just noticed that Local ... >> I'm trying to run Excel on the server side, uploading an Excel file to the ...
    (microsoft.public.dotnet.framework.interop)
  • Re: VS2003 transfer data between two data sources
    ... data and blast the rows to a SQL Server table. ... The problem with reading an excel table without a header row is that the ... Another not so elegant solution might be to get the UI to read the Excel ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VS2003 transfer data between two data sources
    ... data and blast the rows to a SQL Server table. ... The problem with reading an excel table without a header row is that the ... Another not so elegant solution might be to get the UI to read the Excel ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VS2003 transfer data between two data sources
    ... data and blast the rows to a SQL Server table. ... The problem with reading an excel table without a header row is that the ... Another not so elegant solution might be to get the UI to read the Excel ...
    (microsoft.public.dotnet.framework.adonet)