Running Into A .NET COMException With MS Office Interop?
Feb 16, 2010
I am trying to work with the Windows clipboard and Office Interop in an ASP.NET web application.Everything works well on my local machine running XP (i have created a Windows application first which ran perfectly well on local machine). Then I have executed it on a server running Windows Server 2003 and it worked there as well.Then I made a ASP.NET sample project and it worked on my local machine. However when this time I deployed it at the server, after banging my head with permissions, it started giving me this exception which i have no idea why it is doing this:
System.Runtime.InteropServices.COMException (0x80048240):
Shapes (unknown member): Invalid request. Clipboard is empty or
contains data which may not be pasted here.
at Microsoft.Office.Interop.PowerPoint.Shapes.Paste()
Is the problem with any sort of permissions again on clipboard? If yes, how can I grant appropriate permissions?
View 1 Replies
Similar Messages:
Sep 6, 2010
I wrote some code about sending mail, Task, Appoinment etc. For example you can add someone to your outlook contact list over asp.net page. Every thing is ok on my local machine. But if I publish my application to a server I can not add noone on my outlook.
View 2 Replies
Dec 9, 2010
My server administrator does not allow me to install Microsoft Office in the server.
I have developed a website which converts XML files to Excel and it is using Microsoft.Office.Interop.Excel.
Is there any way I can run this application without installing Microsoft Office in the server?
View 7 Replies
Nov 10, 2010
In my asp.net page, I am creating excel file using Office.Interop and saving. The application works correctly in my local. When I am deploying in Win 2003 server I am getting below Error. I don't have excel installed in server.
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005
View 12 Replies
Feb 25, 2010
I am creating a pivot table excel sheet in my ASP .NET web application using Microsoft Office Interop Excel 12.0 components. It is creating the excel file correctly, when i run it from my Visual Studio 2008 in Debug/Release mode.
But when i deploy the solution in IIS 7, first i got some permission issues, which i resolved by giving permission in the DCOMCNFG file. Now i am getting the following error, when trying to open the Excel file:
[code]....
These are the code which i used to open and close the excel application object
[code]....
View 1 Replies
Mar 25, 2010
I'm having some difficulty merging multiple word documents together using Microsoft Office Interop Assemblies (Office 2007) and ASP.NET 3.5. I'm able to merge the documents, but some of my formatting is missing (namely the fonts and images). My current merge code is shown below.
private void CombineDocuments() {
object wdPageBreak = 7;
object wdStory = 6;
object oMissing = System.Reflection.Missing.Value;
object oFalse = false;
object oTrue = true;
string fileDirectory = @"C:documents";
Microsoft.Office.Interop.Word.Application WordApp = new Microsoft.Office.Interop.Word.Application();
Microsoft.Office.Interop.Word.Document wDoc = WordApp.Documents.Add(ref oMissing, ref oMissing, ref oMissing, ref oMissing);
string[] wordFiles = Directory.GetFiles(fileDirectory, "*.doc");
for (int i = 0; i < wordFiles.Length; i++) {
string file = wordFiles[i];
wDoc.Application.Selection.Range.InsertFile(file, ref oMissing, ref oMissing, ref oMissing, ref oFalse);
wDoc.Application.Selection.Range.InsertBreak(ref wdPageBreak);
wDoc.Application.Selection.EndKey(ref wdStory, ref oMissing);
}
string combineDocName = Path.Combine(fileDirectory, "Merged Document.doc");
if (File.Exists(combineDocName))
File.Delete(combineDocName);
object combineDocNameObj = combineDocName;
wDoc.SaveAs(ref combineDocNameObj, ref m_WordDocumentType, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing);
}
I don't care necessarily how this is accomplished. It could output via PDF if it had to. I just want the formatting to carry over.
View 1 Replies
Feb 21, 2011
I have been using using Microsoft.Office.Interop.Word in my webserver (yes, i know it is not recommended). When I ran it on my machine, it runs fine, but when running on the server I get a timeout on the following line:Documents.Open //when trying to open the file.Is there something I'm missing? Is there a better way to edit a Word document within web servers/websites? (I can't create a new one using string builder or outputting into file; I need to edit an existing one that sits on the server.)
View 1 Replies
Jan 27, 2010
I wanto to create matrix report dynamically using Microsoft.Office.Interop.Excel.dll so that i can create pivot table and Report from this, how i can create these kind of repots where in user will drag and drop the details and it will create reports.
View 2 Replies
Dec 10, 2010
I am having an issue that I do not quite understand. I had an ASP project that I built using
Code:
<add assembly="Microsoft.Office.Interop.Word, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"/>
while I still had Office 2007 still on my development PC. I recently upgraded to Office 2010 and even though the web.config file still remains with the above assembly reference, when I publish it and run it now i keep getting the following error ...
Quote:
Could not load file or assembly 'Microsoft.Office.Interop.Word, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
I also have installed the PIA for Version=14.0.0.0 on the server but I still get the same result.
View 12 Replies
Feb 3, 2010
I'm hoping this is an easy one...I'm using Microsoft.Office.Interop.Word to convert uploaded word documents into previewable html files. I haven't implemented it fully, but I've played around with it enough that I think I have a plan that will work... My question revolves around
[Code]....
I'm not in love with the idea of opening word and closing it everytime there's an upload (which I hope is a lot of the time) I'd like to make this a shared object that loads at application start. I have 2 questions
that go along with this. 1. I imagine that winword could lock up and that would be a problem, right? 2. to save a document I use wordapp.ActiveDocument, this could have an issue as a shared object, right? I think I'm talking myself right out of this...
View 1 Replies
Aug 31, 2010
I've got an ASP 4.0 website running on IIS 7.0 . Part of the web site creates an Excel document using C#, due to company policy I'm stuck with Excel 2003. I've noticed that when I deploy the site and use the part that creates the Excel file, its running Excel application object with the login of the user accessing the site. This causes problems with access rights to the Server.
How do I set the server up to run the Excel application using a fixed account? I've got the Application pool running under one, and I thought that would solve the problem, but it doesn't seem to.
View 1 Replies
Jan 20, 2011
'DataTable' is an ambiguous reference between 'System.Data.DataTable' and 'Microsoft.Office.Interop.Word.DataTable'
View 3 Replies
Dec 3, 2010
MVC app captured an exception i've never seen before in 6 months.I thought the .NET framework had been patched for this "bug/feature" a long time ago ?Do you know if we can safely ignore it ?System.Web.HttpExceptionAn error occurred while communicating with the remote host. The error code is 0x800703E3.
View 2 Replies
Jun 10, 2010
I am running into this strange Cyrstal Report runtime error. To give a bit of a background I am deploying my web application on a 64 bit Windows 2003 server using Crystal Report 11.5.3700.0 where the IIS 6.0 is running under 32 bit mode as one of the forums mentioned that this version of Crystal report can only run under 32 bit mode.So as expected all works ok under the development environment but when I open the reports on to the production server error It recieve this error at the following code line.No error.Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Runtime.InteropServices.COMException: No error.Source Error:
[Code]....
Line 66: document.DataSourceConnections[0].SetConnection(Globals.GlobalSettings.DATABASE_SERVER, Globals.GlobalSettings.DATABASE_NAME, false);
Line 67: document.DataSourceConnections[0].SetLogon(Globals.GlobalSettings.DB_USERNAME, Globals.GlobalSettings.DB_PASSWORD);
Line 68: document.VerifyDatabase();
Can you can see, the error message itself says no error which of no use to me. Has anyone encountered this problem before. I am using Visual Studio 2005, ASP.NET 2.0. .NET 2.050727.No error.No error. Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: No error.Source Error:
[Code]....
Line 66: document.DataSourceConnections[0].SetConnection(Globals.GlobalSettings.DATABASE_SERVER, Globals.GlobalSettings.DATABASE_NAME, false);
Line 67: document.DataSourceConnections[0].SetLogon(Globals.GlobalSettings.DB_USERNAME, Globals.GlobalSettings.DB_PASSWORD);
Line 68: document.VerifyDatabase();
View 2 Replies
Oct 22, 2010
I am using Windows Authentication in asp.net every thing is ok in local but when deploying on different system of same domain then its working getting error in this line SearchResult userObject = adSearcher.FindOne();
Error
system.runtime.interopservice.comException
My code is
WindowsIdentity winId = id as WindowsIdentity;
if (id == null)
{
[code]...
View 2 Replies
Mar 23, 2010
How can I configure my asp.net application to work with excel interop. I added a reference to my application but when I try and say Imports Microsoft.Office.Interop.Excel it doesnt work.
View 1 Replies
May 6, 2010
I migrated my asp application to asp.net . When i run I got an error like this.
"System.Runtime.InteropServices.COMException: Cannot update. Database or object is read-only." I am using access db. I can't find out the solution .
View 6 Replies
Apr 22, 2010
I wrote the following code for my report
[Code]....
But i am getting the follwing exception: Access is denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: Access is denied
I am having 'Full permission' to E:Documents and Settings hiru.TECH27SYSTEMSLocal SettingsTemp IIS is not installed in my system. Visual studio is installed in E: My project is in D: what should i do?
View 5 Replies
Sep 2, 2010
Recently deployed my web app on Windows Server2008, IIS7 (with Office installed). After chasing (& catching) various other errors, I'm facing one I'm not sure even where to begin.
On Cassini (visual studio dev server) everything worked flawlessly (reading excel through excel interop).
On w2008 IIS it throws vague error:
Value cannot be null. Parameter name: o [ArgumentNullException: Value cannot be null.....
Currently, I'm going to add null check and see if things get better but I do suspect that it just blows up and disposes on finally block before it even starts reading anything.
Tried to set application pool to run under localsystem, but that didn't change anything.
[code]....
View 1 Replies
Jan 27, 2011
I have a wcf web service that uses the Word interop to produce documents. All works fine when I run it in visual studio, but when I host the web service in IIS (as it will eventually be on a server) and call it there it will fire up WINWORD.exe but then hangs on a call to the "_WordApp.Documents.Add" method and then times out. I realise that the difference between me running in VS and IIS is that in IIS it will now be running as ASPNET user and I have taken the following steps to try and fix this problem.
I used DCOMCNFG to allow permission for ASPNET on "Microsoft Office Word 97 - 2003 Document" (which I thought was strange as I have Office 2007 installed) and this got me past an earlier error that was stopping me instantiating Word, but then I got stuck where I am now.I then tried using impersonation in the web config to get Word to run as my user (as it does when using VS) but it still runs as ASPNET I've heard that this is because the first time a user fires up Word it pops up a modal form asking you to confirm your name and initials, and because ASPNET hasn't run Word before then I somehow need to get past this form. How can I login as ASPNET to do this? Does this sound right? If I can't do this, how I can get Word to run as a different user?
View 4 Replies
Feb 7, 2011
A client of mine is only proficient in development for ASP Classic. They have recently acquired an account for a site originally written in ASP.NET. They are rolling the site into something they can actively maintain, but the site originally included an image handler that took dynamically changing data regarding water levels and outputs an image containing a graphical representation of that data. The requirement is to develop a COM interop library that can be registered on the server and called with CreateObject to generate the same image's byte array for output using Response.BinaryWrite. The COM interop library must be registered at the remote site on a Windows 2000 Server, and I can't make any assumptions about their having access to regasm/gacutil to accomplish that task.
The Difficulty
I've built the class library by creating a Class Library project in Visual Studio 2010, choosing "COM Class" from the template, and inserting my code to generate a class with a single public method to return a byte array when given an integer (well, enumerator, but all the same). Unfortunately, even on my own development machine after building the library and registering (regasm) and caching the assembly (gacutil), I can't make a call through Classic ASP to instantiate the object, receiving instead an "ActiveX component can't create object" error. And, of course, at the server site, the DLL can't be registered, the response being "Required module was not found."
Resources I've Used
I've already had a look through the following articles and haven't turned up the answers I need:
(basic steps) Walkthrough: Creating COM Objects with Visual Basic Build and Deploy a .NET COM Assembly .NET COM+ Interop Component with Classic ASP
What I Need
Essentially what I need is a bit of hand-holding on a kind of step by step of what it's going to take to meet the requirements and create a COM+ interop module correctly in VS2010. Creating the actual class object itself isn't terribly difficult. However, none of the articles I've looked through really discuss project options or build procedures with VS2010 or the .NET 4.0 Framework, nor have any of them really discussed if there are special considerations for deploying to older systems like Windows Server 2000 and the actual registration of the library on a system with only, say, regsvr32 on hand. Unfortunately, most of the information I find centers on ASP.NET 2.0 and supporting older applications while still in the middle of transitioning from ASP Classic to the new technology.
View 1 Replies
Jul 1, 2010
I am executing a long-running Oracle stored procedure from .NET. The procedure takes about three hours to run. Ideally, the user should be able to kick off the procedure, close the browser, and come back later to check the results.
The problem is that the connection to the Oracle procedure is lost after exactly an hour. As you would expect, the Oracle procedre runs to completion if it is executed from SQL Plus. Strangely enough, it will also run to completion if I run in debug mode on my local machine (I start two threads, one of which executes the procedure. I set a breakpoint on the second thread).
Here is my connection string:
data source= (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=serverx)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TestSID)))
Some relevant sections from web.config:
<sessionState mode="InProc" cookieless="false" timeout="3000" stateNetworkTimeout="72000"/>
<httpRuntime executionTimeout="18000" maxRequestLength="2097151" />
Any thoughts as to why the connection is being lost in exactly an hour, and what I can do to maintain the connection until the procedure finishes?
View 1 Replies
Apr 28, 2010
in my application, when user click on particular link button, MS word has to open how can i write the code for this.
View 3 Replies
Aug 18, 2010
I've got a website that needs to create an Excel File using the Excel object library and then makes it available for download by the user.This of course works fine in my dev environment on my local machine. I getCould not load file or assembly 'office, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
The machine is running 64 bit Windows 2008 Server, and the version of office is 2003 SP3 (yes I know its old, but it does run normally). I'm thinking its a registration issue, but I don't know how to register Excel with the site in IIS 7.0.The development machine (on which everything runs fine), is an XP box. I've noticed that Excel is installed to a different path on the Server 'C:Program Files (x86)Microsoft OfficeOFFICE11' as opposed to 'C:Program FilesMicrosoft OfficeOFFICE11' on the XP box.
View 4 Replies
Aug 10, 2010
I am trying to figure out if the disclaimer below still applies to the .NET Framework 4.0:Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
I was under the impression that the new version of the Framework uses some magic to avoid PIA deployment and somehow one is allowed to manipulate Interop objects ... I do not know enough to figure this on my own. The simple question is: is it possible to open an Excel workbook from within an ASP.NET page, change something in it, save it and do not blow anything in the process?
View 1 Replies
