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.
I need to read an Excel work book with 2 sheet which have more than 60,000 records. The application is an ASP.Net application so the performance matters.
Which approach should I take? Sohuld I do it using Microsoft.Office.Interop.Excel or should I do it using OLEDB in ADO.Net?
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.
I am exporting HTML table/Repeater to excel, its not working on Windows server 2008, however same working on Windows Server 2003 and local machine
[Code]....
I have debug on Windows Server 2008, I am getting the same string that is on my local machineResponse.Write(sw.ToString()); but nothing wrote on my file and not getting any errorI have tried hard but not able to figure out the issue
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
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
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.
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.
Microsoft Visual Studio 2010 was being used along with SQL Express for website development on the Operating System, Windows Server 2008 R2 Enterprise Edition of Intel Xeon CPU @ 2.13 GHz (2 Processors) containing 12 GB RAM with 64-bit Operating System. Website was developed along with the databases of SQL Express with the help of Visual Studio. Whether the developed website along with the databases may be used on the Operating System, Windows 7 of 64-bit? The website will used within Intranet. Which Operating System and configuration to be used for the Intranet Website?
I've installed IIS for Windows Server 2008 SP2 and Windows 7. In both instances, I can't get even the simplest of ASP.net scripts to work (note: I'm ftping the published files from Visual Web Dev 2008 Express on XP):
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.
Source Error
[Code]....
Line 36: ASP.NET to identify an incoming user.Line 37: -->Line 38: <authentication mode="Windows"/>Line 39: <!--Line 40: The <customErrors> section enables configuration Source File: C:inetpubwwwroot estweb.config Line: 38
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a
<customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
I just downloaded and installled the Microsoft Windows Azure SDK yesterday for the first time and I am having issues running the application as I all I am getting is 503 errors. I run Windows Server 2008 R2 on my development machine and even tested it on another co-workers 2008 R2 and couldn't even compile the application. He got this error instead "A problem occurred while trying to set the "References" parameter for the IDE's in-process compiler. Error HRESULT E_FAIL has been returned from a call to a COM component."
From within my Windows Server 2008 R2 Hyper-V Virtual Windows 7 x86 enviroment, I was able to successfully build and run the Windows Azure SDK and it even showed the base ASP.NET application.So my question is, does the Windows Azure SDK for Visual Studio 2010 w/ Visual Studio 2010 SP 1 installed not work under Microsoft Server 2008 R2?
We have a working version of application (Intranet) with uses Windows Authentication deployed in Windows 2003. The application uses HttpContext.Current.User.Identity.Name to get the logged-in user. Here impersonate is turned off.Right now, we are move to Windows 2008 RC2 where this Windows Authentication problem arised. I have Digest Authentication and Windows Authentication enabled. And also I have enabled Anonymous Authentication enabled to avoid the Login dialog of IIS in the end-user IE. Now I am getting HttpContext.Current.User.Identity.Name as Empty. When I impersonate using username and password, I am used to login using that user but all the users uses the same user to login.Does any has solution for this?Deployment Server - Windows 2008 RC2 (IIS 7.5)Development - Windows 7 (IIS 7.5)I am new to IIS 7.5. Please give me a solution
I have looked at all the posts I can find on this problem and tried everything I can think of, but still the problem persists. I am getting really sick of it.was working fine for the last year until an update to MS Office 2007 caused a lot of problems (automatic update). After checking posts here, I removed it completely. No change. I then tried all the things I could find on other posts, also no change. Today, I removed VS and the Web Authoring Component and re-installed. Still no go.
Does anyone have a fix for this problem. It seems that it has been around a long time, but is still giving problems. I even saw one suggestion to reformat the drive! You've got to be joking!
I am looking at developing using Visual Studio 2010/2008 and SQL Server 2008 on Windows 7. Should I be able to do this on Windows 7 Professional, or do you need Windows 7 Ultimate?
I`ve installed Excel 2007 on my Win 2003 SBS with installed terminal serwer function on it.I can`t run the Excell app, as I don`t have a valid license for using it on terminal serwer.Is there any other way of creating Excel files in my ASP.NET app, without opening, and automating an Excel app object?Are there any libriaries which allow to use Excel objects without opieng Excel app, as it is with Access app?
Currently we are running an application build in VB6,ASP,Commerce Server2000 and Sql Server 2000. This application is running in Windows 2000 server.Now we are planning to migrate Windows server 2000 to Windows 2008.Will this application run in Windows 2008 or do we need to upgrade this application to dotnet and Sql 2008?
Exising .net 2 app migrated to .net 4 and moved to an IIS7 Windows 2008 R2 server. We used to be able to run some code on the web page to export some stuff to excel. Now, when we do... we get the following error: The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID {00024500-0000-0000-C000-000000000046} and APPID Unavailable to the user d"omainusername" SID (S-1-5-21-2084383492-816144152-925700815-4150) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool. I did wonder if it may be to do with the authenticated user being on a different domain to the webserver - where we see this error?
I am building an windows application using visual studio 2005. I want to retreive data from excel workbook and i want to display the retreived data in a drop down menu.
I have few question regarding this process.
1. How do we connect to excel using ADODB.Connection.
let me know following code snippet works or not.
Dim cn as ADODB.Connection Set cn = New ADODB.Connection With cn .Provider = "Microsoft.Jet.OLEDB.4.0" .ConnectionString = "Data Source=C:MyFolderMyWorkbook.xls;" & _ "Extended Properties=Excel 8.0;" .Open End With
2:How do we access and manupilate individual column from excel worksheet?
Since i am new to .Net environment i need detailed explanation about whole process.
Ive recently got a new development machine with windows 7 64 bit. On loading up a website and opening default.aspx, the whole ide just freezes. Nothing responds, I have to shut it down from the task manager. This happens every time (ive tried it 4 times so far)The site was fine on my old machine (windows xp 32 bit) are there any compatibility issues with windows 7 64 bit and vs 2008 ?
I'm working on my company's intranet site and I wanted to create a function or class that would return the user's domain name and user name so I tried creating a class:
Code: Imports Microsoft.VisualBasic Imports System.Web.Security Public Class DataWhareHouseClass
