|
.net
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Urgent - Issues with using Office 2003 PIA on Windows Server 2008I would appreciate immediate help on this.
We are using a functionality to read and write Excel files using Office Automation using PIA assemblies for MS Office 2003. We have office 2003 installed on Windows Server 2008. While trying to run the application we are getting following error - System.Runtime.InteropServices.COMException ErrorCode: -2146827284 Message: Exception from HRESULT: 0x800A03EC The application is running under Network Service account and we have added this account to Admin group. Appreciate if some one can help out on this issue at the earliest.
Show quote
Hide quote
"dinoo" <di***@discussions.microsoft.com> wrote in message Microsoft Office isn't designed to be used in this way, to the extent that news:F97AA047-82AF-4A0D-9BCE-9E164AA6C18C@microsoft.com... >I would appreciate immediate help on this. > > We are using a functionality to read and write Excel files using Office > Automation using PIA assemblies for MS Office 2003. We have office 2003 > installed on Windows Server 2008. > While trying to run the application we are getting following error - > System.Runtime.InteropServices.COMException > ErrorCode: -2146827284 > Message: Exception from HRESULT: 0x800A03EC > > The application is running under Network Service account and we have added > this account to Admin group. > > Appreciate if some one can help out on this issue at the earliest. Microsoft won't support any solution which even tries: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2 - note specifically the paragraph in bold... Use this: http://www.aspose.com/categories/file-format-components/aspose.cells-for-.net-and-java/default.aspx and your problems will disappear. Remember to uninstall Office from your webserver too... I checked on the internet and people have success using Office 2000 and
Office 2003 in IIS with some configuration. The only thing is it is not working for us because we are missing some thing. Is there any information any one can point to related this configuration? This application is using Office 2003 on II6 with no issues for last 3 years using .Net framework 1.1. The application is now being converted to .Net 2.0 and being ported on 2008 server. 1. Do I need to have Framework 1.1 installed on the 2008 server? We are using PIA assemblies for excel and on Microsoft site it shows the requirement of .Net Framework 1.1. 2. My another question is - Do you think using PIA assemblies for Office 2007 will work here if Office 2003 being used on the server. Show quoteHide quote "Mark Rae [MVP]" wrote: > "dinoo" <di***@discussions.microsoft.com> wrote in message > news:F97AA047-82AF-4A0D-9BCE-9E164AA6C18C@microsoft.com... > > >I would appreciate immediate help on this. > > > > We are using a functionality to read and write Excel files using Office > > Automation using PIA assemblies for MS Office 2003. We have office 2003 > > installed on Windows Server 2008. > > While trying to run the application we are getting following error - > > System.Runtime.InteropServices.COMException > > ErrorCode: -2146827284 > > Message: Exception from HRESULT: 0x800A03EC > > > > The application is running under Network Service account and we have added > > this account to Admin group. > > > > Appreciate if some one can help out on this issue at the earliest. > > Microsoft Office isn't designed to be used in this way, to the extent that > Microsoft won't support any solution which even tries: > http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2 - note > specifically the paragraph in bold... > > Use this: > http://www.aspose.com/categories/file-format-components/aspose.cells-for-.net-and-java/default.aspx > and your problems will disappear. > > Remember to uninstall Office from your webserver too... > > > -- > Mark Rae > ASP.NET MVP > http://www.markrae.net > > "dinoo" <di***@discussions.microsoft.com> wrote in message No, it is not working for you because it is not designed to work like this - news:58221BA4-AAC5-429F-8F9F-65BB5A5E3300@microsoft.com... > The only thing is it is not working for us because we are missing some > thing. that's why Microsoft don't support it - please (re-)read the link I gave you... > Is there any information any one can point to related this configuration? No.> 1. Do I need to have Framework 1.1 installed on the 2008 server? No. You need to re-write your web app properly so that it doesn't use server-side Office automation. > 2. My another question is - Do you think using PIA assemblies for Office No.> 2007 will work here if Office 2003 being used on the server. On Jul 9, 1:11 am, dinoo <di***@discussions.microsoft.com> wrote:
Show quoteHide quote > I would appreciate immediate help on this. Hi,> > We are using a functionality to read and write Excel files using Office > Automation using PIA assemblies for MS Office 2003. We have office 2003 > installed on Windows Server 2008. > While trying to run the application we are getting following error - > System.Runtime.InteropServices.COMException > ErrorCode: -2146827284 > Message: Exception from HRESULT: 0x800A03EC > > The application is running under Network Service account and we have added > this account to Admin group. > > Appreciate if some one can help out on this issue at the earliest. Using Excel Automation is not such a good idea cause it's very complicated to program with it. You should use 3rd party component like GemBox.Spreadsheet. You will also avoid problems in the future like if somebody who wants to use your application doesn't have installed Microsoft Excel he will still be able to use the application. http://www.gemboxsoftware.com/GBSpreadsheet.htm Filip
Other interesting topics
autoincrement vs uniqueidentifier (easy)
Is Delegation Necessary? session state time out Using if on ASPX-side instead of in code behind restrict number of users á ÇáÅÓáÇã Úä ÇáÅÑåÇÈ¿ Redirect To Login Page - Forms Authentication Page refresh - Alternative to using frames How can the Login control stop authenticating? Trap Data Tier Errors? |
|||||||||||||||||||||||