|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
DCOM Issue with ExcelHi there,
When I try to get an instance of my Excel application in code I get an UnauthorizedAccessException thrown with 'Access Is Denied'. I've heard that DCOM needs permissioning to allow access, but I'm not sure how. I've tried adding ASPNET into the security as a user with the rights to do so, but no joy. The ASP.NET app in question has anonymous access disabled - does that make any difference? Any ideas? Not found anything that's worked for me yet on the net. Cheers, Michael. How are you trying to get your Excel instance. What makes you think you are
using DCOM? Show quote "Michael Burgess" <michael.burg***@rabobank.com> wrote in message news:1192796144.864215.40240@v29g2000prd.googlegroups.com... > Hi there, > > When I try to get an instance of my Excel application in code I get an > UnauthorizedAccessException thrown with 'Access Is Denied'. > > I've heard that DCOM needs permissioning to allow access, but I'm not > sure how. I've tried adding ASPNET into the security as a user with > the rights to do so, but no joy. The ASP.NET app in question has > anonymous access disabled - does that make any difference? > > Any ideas? Not found anything that's worked for me yet on the net. > > Cheers, > Michael. >
Show quote
On 19 Oct, 13:59, "Scott M." <s-...@nospam.nospam> wrote: This is the call that throws the exception..............> How are you trying to get your Excel instance. What makes you think you are > using DCOM? > > "Michael Burgess" <michael.burg***@rabobank.com> wrote in message > > news:1192796144.864215.40240@v29g2000prd.googlegroups.com... > > > > > Hi there, > > > When I try to get an instance of my Excel application in code I get an > > UnauthorizedAccessException thrown with 'Access Is Denied'. > > > I've heard that DCOM needs permissioning to allow access, but I'm not > > sure how. I've tried adding ASPNET into the security as a user with > > the rights to do so, but no joy. The ASP.NET app in question has > > anonymous access disabled - does that make any difference? > > > Any ideas? Not found anything that's worked for me yet on the net. > > > Cheers, > > Michael.- Hide quoted text - > > - Show quoted text - excelApp = new Microsoft.Office.Interop.Excel.Application(); Any ideas? I'm not desperate to find out as it turns out the production problem was a data error, but I'm sure I'll have to make changes soon and I'll need my dev PC to work properly with the site. Thanks, Michael.
Show quote
"Michael Burgess" <michael.burg***@rabobank.com> wrote in message I have a couple of thoughts on this. First, this is not DCOM at all. DCOM news:1193131271.657271.282190@e9g2000prf.googlegroups.com... > On 19 Oct, 13:59, "Scott M." <s-...@nospam.nospam> wrote: >> How are you trying to get your Excel instance. What makes you think you >> are >> using DCOM? >> >> "Michael Burgess" <michael.burg***@rabobank.com> wrote in message >> >> news:1192796144.864215.40240@v29g2000prd.googlegroups.com... >> >> >> >> > Hi there, >> >> > When I try to get an instance of my Excel application in code I get an >> > UnauthorizedAccessException thrown with 'Access Is Denied'. >> >> > I've heard that DCOM needs permissioning to allow access, but I'm not >> > sure how. I've tried adding ASPNET into the security as a user with >> > the rights to do so, but no joy. The ASP.NET app in question has >> > anonymous access disabled - does that make any difference? >> >> > Any ideas? Not found anything that's worked for me yet on the net. >> >> > Cheers, >> > Michael.- Hide quoted text - >> >> - Show quoted text - > > This is the call that throws the exception.............. > > excelApp = new Microsoft.Office.Interop.Excel.Application(); > > Any ideas? > > I'm not desperate to find out as it turns out the production problem > was a data error, but I'm sure I'll have to make changes soon and I'll > need my dev PC to work properly with the site. > > Thanks, > Michael. > has to do with utilizing an object across the LAN using MS proprietary technology. This is InterOperability between a .NET assembly and a COM component. Microsoft recommends using the PIA's (Primary InterOp Assemblies when connecting to Office libraries as these assemblies have been built specifically for this purpose. Here is a nice article describing the Office PIA's and it contains links to their usage - perhaps it will help. http://msdn2.microsoft.com/en-us/library/kh3965hw(VS.80).aspx Good luck. -Scott
Show quote
On 23 Oct, 16:03, "Scott M." <s-...@nospam.nospam> wrote: Thanks Scott, I'll take a look - have to admit I know nada about DCOM,> "Michael Burgess" <michael.burg***@rabobank.com> wrote in message > > news:1193131271.657271.282190@e9g2000prf.googlegroups.com... > > > > > > > On 19 Oct, 13:59, "Scott M." <s-...@nospam.nospam> wrote: > >> How are you trying to get your Excel instance. What makes you think you > >> are > >> using DCOM? > > >> "Michael Burgess" <michael.burg***@rabobank.com> wrote in message > > >>news:1192796144.864215.40240@v29g2000prd.googlegroups.com... > > >> > Hi there, > > >> > When I try to get an instance of my Excel application in code I get an > >> > UnauthorizedAccessException thrown with 'Access Is Denied'. > > >> > I've heard that DCOM needs permissioning to allow access, but I'm not > >> > sure how. I've tried adding ASPNET into the security as a user with > >> > the rights to do so, but no joy. The ASP.NET app in question has > >> > anonymous access disabled - does that make any difference? > > >> > Any ideas? Not found anything that's worked for me yet on the net. > > >> > Cheers, > >> > Michael.- Hide quoted text - > > >> - Show quoted text - > > > This is the call that throws the exception.............. > > > excelApp = new Microsoft.Office.Interop.Excel.Application(); > > > Any ideas? > > > I'm not desperate to find out as it turns out the production problem > > was a data error, but I'm sure I'll have to make changes soon and I'll > > need my dev PC to work properly with the site. > > > Thanks, > > Michael. > > I have a couple of thoughts on this. First, this is not DCOM at all. DCOM > has to do with utilizing an object across the LAN using MS proprietary > technology. This is InterOperability between a .NET assembly and a COM > component. > > Microsoft recommends using the PIA's (Primary InterOp Assemblies when > connecting to Office libraries as these assemblies have been built > specifically for this purpose. > > Here is a nice article describing the Office PIA's and it contains links to > their usage - perhaps it will help. > > http://msdn2.microsoft.com/en-us/library/kh3965hw(VS.80).aspx > > Good luck. > > -Scott- Hide quoted text - > > - Show quoted text - hence my naivety! A couple things can cause this chiefly that the Excel object isn't correctly
registered. It will usually throw a null reference object, but I have seen it throw exceptions related to permissions access. Secondly, your ASP.NET application runs least privilege meaning that your worker process trying automate Excel may not have sufficient permission. You can determine which of the two is the issue by turning CAS off at a command prompt (cas -s off) and running the application. If it works, bump your worker process permissions up a notch. If it still fails, go register the Excel object. I don't suspect this is a PIA issue but it may be solved by installing the PIAs again, which would point to registration issue. -- Show quoteRegards, Alvin Bruney ------------------------------------------------------ Shameless Author Plug OWC Black Book 2nd Edition Exclusively on www.lulu.com/owc $24.99 "Michael Burgess" <michael.burg***@rabobank.com> wrote in message news:1193152385.140153.239810@v23g2000prn.googlegroups.com... > On 23 Oct, 16:03, "Scott M." <s-...@nospam.nospam> wrote: >> "Michael Burgess" <michael.burg***@rabobank.com> wrote in message >> >> news:1193131271.657271.282190@e9g2000prf.googlegroups.com... >> >> >> >> >> >> > On 19 Oct, 13:59, "Scott M." <s-...@nospam.nospam> wrote: >> >> How are you trying to get your Excel instance. What makes you think >> >> you >> >> are >> >> using DCOM? >> >> >> "Michael Burgess" <michael.burg***@rabobank.com> wrote in message >> >> >>news:1192796144.864215.40240@v29g2000prd.googlegroups.com... >> >> >> > Hi there, >> >> >> > When I try to get an instance of my Excel application in code I get >> >> > an >> >> > UnauthorizedAccessException thrown with 'Access Is Denied'. >> >> >> > I've heard that DCOM needs permissioning to allow access, but I'm >> >> > not >> >> > sure how. I've tried adding ASPNET into the security as a user with >> >> > the rights to do so, but no joy. The ASP.NET app in question has >> >> > anonymous access disabled - does that make any difference? >> >> >> > Any ideas? Not found anything that's worked for me yet on the net. >> >> >> > Cheers, >> >> > Michael.- Hide quoted text - >> >> >> - Show quoted text - >> >> > This is the call that throws the exception.............. >> >> > excelApp = new Microsoft.Office.Interop.Excel.Application(); >> >> > Any ideas? >> >> > I'm not desperate to find out as it turns out the production problem >> > was a data error, but I'm sure I'll have to make changes soon and I'll >> > need my dev PC to work properly with the site. >> >> > Thanks, >> > Michael. >> >> I have a couple of thoughts on this. First, this is not DCOM at all. >> DCOM >> has to do with utilizing an object across the LAN using MS proprietary >> technology. This is InterOperability between a .NET assembly and a COM >> component. >> >> Microsoft recommends using the PIA's (Primary InterOp Assemblies when >> connecting to Office libraries as these assemblies have been built >> specifically for this purpose. >> >> Here is a nice article describing the Office PIA's and it contains links >> to >> their usage - perhaps it will help. >> >> http://msdn2.microsoft.com/en-us/library/kh3965hw(VS.80).aspx >> >> Good luck. >> >> -Scott- Hide quoted text - >> >> - Show quoted text - > > Thanks Scott, I'll take a look - have to admit I know nada about DCOM, > hence my naivety! >  |
|||||||||||||||||||||||
Other interesting topics