.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

could not load file or assembly'Microsoft.office.interop.excel

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :.NET Framework
 

could not load file or assembly'Microsoft.office.interop.excel, version=12.0.0.0  , culture=neutral, public keytoken=71e9bce111e9429c' or one of its dependencies

i am getting this error when i am installing setup of my project in other machine.

 




View Complete Post


More Related Resource Links

Could not load file or assembly 'Microsoft.Office.InfoPath.Vsta...

  

I was evaulating SharePoint Designer 2010 and InfoPath 2010 for my team so I installed both of them on my pc. But after I realize we won't have SharePoint Server 2010 for a while, I uninstalled those two applications.

Now the problem cames... when I try to publish a InfoPath 2007 form and it gave me that error message:

Could not load file or assembly 'Microsoft.Office.InfoPath.Vsta, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies.

Clearly, Visual Studio 2005 is trying to find the assembly from InfoPath 2010, but it's been uninstalled already. So how do I tell VS to use InfoPath 2007?

Another question, how to force InfoPath 2007 to create the C# code project with VS 2008? It's using VS 2005 by default.


Could not load file or assembly 'Microsoft.SqlServer.BatchParser' or one of its dependencies

  
I got this problem when I tried to migrate one of my web deployment project from vs2005 to vs2010 on windows 7 machine. The exactly error message is like this: Could not load file or assembly 'Microsoft.SqlServer.BatchParser' or one of its dependencies. An attempt was made to load a program with an incorrect format.(description) ASPNETCOMPILER(file), myWebDeploy (project) I have installed all of suggested feature packs as suggested by others: SQLServer2005_ADOMD_x64.msi, SQLServer2005_XMO_x64.msi. Can somebody please help? Thanks a lot 

Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0......

  
Hello to everyone. I have a .exe which uses the Server Management Objects(SMO) When I try it on my pc it runs without any problem. But on another pc it gives this error: Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. I'm using SQL Server 2000 and for the application: Visual Studio 2005. Any idea would be very useful!! Thanks in advance!!

Could not load file or assembly 'Microsoft.Scripting.ExtensionAttribute, Version=2.0.0.0

  
Dear ASP.NET I keep getting this strange error (below) on my local machine on the first time the page loads, Then if I reload it - it loads correctly... What is really strange is that it does not happen on the server (same settings)   I'm using AJAXControlToolkit.dll version 4.1.40412.2 and this script manager (if not I get the Common.Common.js error)<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="AJAX" %> <AJAX:ToolkitScriptManager runat="server" ID="_scriptManager" AsyncPostBackTimeout="600" EnablePartialRendering="true" EnableHistory="true" />   I also tried to add this: <runtime> <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"> <dependentAssembly> <assemblyIdentity name="Microsoft.Scripting.ExtensionAttribute" publicKeyToken="28f01b0e84b6d53e"/> <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="4.0.0.0"/> </dependentAssembly> <dependentAssembly> <assemblyIdentity name="AjaxControlToolkit" publicKeyToken="31bf3856ad364e35"/> <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="4.1.40412.0"/> </depende

Framework error:Could not load file or assembly 'Microsoft.AnalysisServices, Version=9.0.242.0

  
Hi,I use sql clr sp's to load data in to database using .net framework 2.0. I never had aproblem using this and it went well for months.I recently updated to net framework 3.5 sp1 and sqlserver sp3 on 32-bit sql server and win 2003.I am facing an error which i could not resolve.Error:System.IO.FileLoadException: Could not load file or assembly 'Microsoft.AnalysisServices, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)System.IO.FileLoadException:    at StoredProcedures.checktable(String paramComponent, String paramParameters)I have gone through different forums, and trie different options,but did not help. I am using 'unsafe'  option.I also tried to alter assembly which is mentioned in http://support.microsoft.com/kb/949080/pt But when i tried to alter the assembly using the above link or try to change the permission to external access on the assembly, i get the below error.Alter ASSEMBLY AccessibilityFROM 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Accessibility.dll'Cannot alter the assembly 'Accessibility', because it does not exist or you do not have permission.I am an admin on the server/sqlCan some one suggest how to alter assembly with permissions or solve this issue or am i missing anything important.Do i

** Microsoft.Office.Interop.Excel.dll - Do I need Excel installed?? **

  
Hi,I have a VB.Net app which creates an Excel report.  This is all working fine on my development boxwhich turns out to have MS Office 2003 installed.  The app works fine.  I added a reference toMicrosoft Excel 11.0 Object Library under the COM tab when I did the "Add Reference".  I also copiedthe Interop.Excel.dll to my BIN folder.The server that I need to deploy my app to does not have MS Office or Excel installed.  I ran the appanyway just to see if it would worked.  Of course, it failed with this error:Retrieving the COM class factory for component with CLSID {00020820-0000-0000-C000-000000000046} failed due to the following error: 80040154.Do I need to have Excel installed on the target machine?  I took a copy of "Microsoft.Office.Interop.Excel.dll"from the GAC on the DEV box and installed on the GAC on the target machine.  Tried the app again and stillfailed with the same error.  I really don't want to install Excel if I don't have to.  Can someone please providesome help on this?Thank you in advance!

Could not load file or assembly 'Microsoft.SqlServer.BatchParserClient'

  

Sirs:

I've seen several posts on this forum about this issue, and several have been resolved, but I'm not seeing the answer.

On my Windows 7 machine with SQL Server 2008 R2, I have a Visual Studio 2010 project that uses SQL SMO.

The app runs fine on my machine, but when I publish to another server, I get Could not load file or assembly 'Microsoft.SqlServer.BatchParserClient'

If I go to http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en

and install Microsoft SQL Server 2008 Native Client , Microsoft SQL Server System CLR Types , and Microsoft SQL Server 2008 Management Objects I stop getting the error.

It seems to me that I should just be able to properly reference what I need and deploy my project...

So- how do I deploy my project without needing these installs?

 


In His service,
Steve Gray MCDBA
Vice President, 4Penny.net
www.4penny.net
www.VSToolsForum.com - Dynamics GP development forum
www.devshed.us - Coding blog

Could not load file or assembly Microsoft.ReportingServices.ProcessingCore or one of its dependencie

  

 

My reporting server 2005 frequently throws error below.

The PC hosting reporting server has .net framework 1.1 and 2.0 installed, and it does not have SQL server installed. The 2 databases used by reporting server are in another PC.

Please help.

w3wp!webserver!1!3/14/2007-07:01:35:: i INFO: Reporting Web Server started
w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing PollingInterval to '10' second(s) as specified

Office.sharPoint.Server Event ID: 6482 Could not load file or Assembly

  

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Office Server Shared Services
Event ID: 6483
Date:  4/16/2009
Time:  2:41:10 PM
User:  N/A
Computer: JPFS02
Description:
Application synchronization failed for Microsoft.Office.Server.Administration.UserProfileService.

Reason: Could not load file or assembly 'Microsoft.Office.Server.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.

Techinal Support Details:
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Office.Server.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.Office.Server.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'
   at Microsoft.Office.Server.UserProfiles.SRPSite.SynchronizeManagedPropertyMappings()
   at Microsoft.Office.Server.UserProfiles.SRPSite._Init(ServerContext serverContext)
   at Microsoft.Office.Server.UserProfiles.SRPSite..ctor(ServerContext serverContext)
   at Microsoft.Office.Server.Administration.UserProfileApplication.get_ProfileSiteCache()
   at Microsoft.Office.Server.Administration.UserProfileApplication.Synchronize()<

Could not load file or assembly 'Microsoft.SharePoint.Search, Version=12.0.0.0, Culture=neutral, Pu

  

Hello, I installed smartpart and I created a usercontrol, single one, and then I want to test the user control before using it in sharepoint, so I created a webpage and dragged the user control, when I press F5, I got this strange error never seen.

 

 

 Could not load file or assembly 'Microsoft.SharePoint.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. An attempt was made to load a program with an incorrect format.

 

 

I commented the following web.config lines but that didn work

 

<!--<SafeControl Assembly="Microsoft.SharePoint.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.Search.WebControls" TypeName="*" Safe="True" AllowRemoteDesigner="True" />

<SafeControl Assembly="Microsoft.SharePoint.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.Search.Internal.WebControls" TypeName="*" Safe="True" AllowRemoteDesigner="True" />-->

I am not even

Can't find Microsoft.Office.Interop.Excel.dll

  

 

I am trying to use this namespace and downloaded the O2003pia.exe from http://support.microsoft.com/kb/897646.

 

I ran the msi and see the Interop files in the GAC but when I try to 'Add a Reference' in VS2005, I do not see any of the Interop namespaces.

 

I already had Office 2003 installed before I ran the above msi.

 

What else am I doing wrong. Why aren't these included with VS2005 in the first place..............

 

Please help,

 

JJM


Microsoft Office Excel cannot access the file.There are several possible reasons: . The file name or

  
Hi all,
I am workin on Arc IMS web application project where I will be uploading an excel file containing data say city,addresszip(column headers in excel file)..etc..and load necessary column data in listboxes..and finally save the data to an excel file..when I run though Studio I dont get error..when I run through browser..I got errors ..I even modified DCOMCNFG...But..I get the below error..
Microsoft Office Excel cannot access the file 'E:\vijay\ArcIms\Excelsheets'. There are several possible reasons: • The file name or path does not exist. • The file is being used by another program. • The workbook you are trying to save has the same name as a currently open workbook.
xml
Here goes my code..
Imports Excel
Imports System.Data.OleDb
Imports System.Data
Partial Class _Default
    Inherits System.Web.UI.Page
    Dim connection As New System.Data.OleDb.OleDbConnection
    Dim command As New System.Data.OleDb.OleDbCommand
    Dim dr As System.Data.OleDb.OleDbDataReader
    Dim cmd1 As New System.Data.Ol

ASP.NET Excel Microsoft.Office.Interop.Excel.ApplicationClass

  

Hello,

My server is windows 2008 R2. Everything is running well except the following.

Whenever I tried to export to excel using:

Microsoft.Office.Interop.Excel.ApplicationClass app = new Microsoft.Office.Interop.Excel.ApplicationClass();

It shows exception:

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005

I searched on google, almost every suggestion told me to find Microsoft Excel Application in DomConfig. But I found no Microsoft Excel in DomConfig. Please note, I have Excel 2003 & 2007 on that server.


Please help me, its really urgent.


Microsoft Office Excel cannot access the file 'C:\inetpub\wwwroot\ProjectWebSite\Files\ROUTINE_MCA.

  

Hello everybody.

I am in a critical situation. I first tried to make a project (file->new->project) using visual studio, where I displayed the content of a excel file by GridView. I was successful then, but when I attach it to my website located in inetpub I am getting this error :

Microsoft Office Excel cannot access the file 'C:\inetpub\wwwroot\ProjectWebSite\Files\ROUTINE_MCA.xlsx'. There are several possible reasons:

. The file name or path does not exist.
. The file is being used by another program.
. The workbook you are trying to save has the same name as a currently open workbook.


At first I faced some COM related problem and found solution in Google, but this particular problem is not solving. Is there any way to access Excel document in asp.net website?

In my application there is a facility of uploading excel document to the server and then display its content. But I have failed to do this display operation, is there any turn around way, like store the excel document as dataset and then access it as required.

Please help. I am in great trouble. Thanks in advance.


Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=10.0.0.0, Culture=

  

I am trying to use SQL Server 2008 Developer on Windows Server 2008.  Whenever I try to connect to the server, I get this error: "Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified."

I found some info at http://blogs.msdn.com/b/ashishme/archive/2009/08/15/could-not-load-file-or-assembly-microsoft-sqlserver-diagnostics-strace-version-10-0-0-0-culture-neutral-publickeytoken-89845dcd8080cc91-or-one-of-its-dependencies-the-system-cannot-find-the-file-specified.aspx, but this didn't help me because it is not on my system, even after reinstalling both SQL Server and .NET Framework 4.  I also saw a this page: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/1115cd55-721d-4974-99b1-d142d1e6a927, but this also didn't fix my problem.

What can I do, or where can I get the missing assemble

On Change:Prevent Evaluation fails with error Could not load file or assembly 'Microsoft.SqlServer.

  

Hi All,

I am facing a strange issue with Policy Based Management. Exact problem is as below

SQL Setups

************

I have Lenovo laptop having 3 SQL instances installed on it.

SQL Server 2005 (x86) Developer Edition 9.00.4053  -- Named Instance : SQL2K5

SQL Server 2008 (x86) Developer Edition 10.0.1600.22 -- Named Instance : SQL2K8

SQL Server 2008 R2 (x86) Developer Edition 10.50.1600.1 -- Named Instance : SQL2K8R2

 

I configured SQL2K8R2 instance as a Centralized Server and registed SQL2K8 & SQL2K5 under this. I configured a new condition by using facet: MULTIPART NAME. As per this condition Table Should start with TEST_ in database TEST . Evaluation Mode set to              On Change: Prevent. Idea is if some one logs to database TEST and tries to create table with name other then starting with TEST_ then it should fail.

I Imported this policy on registered servers thru Centralized Management Server Action, as expected policy got configured on Registred SQL2K8 instance

Microsoft.Office.Interop.Excel NumberFormmatting Help

  

Hi Everyone. I wasn't sure which forum to put this under, so please move if necessary.

 

I have an app that exports a data table to excel. This works, however, i have a column with currency that i can't get formatted properly.

 

IE: Right now it prints 24450.00 or 24000 if a whole number with no decimal places.

 

I have tried a lot of things, but this is what i have right now for my range and formatting. Below is a copy of the method. Please let me know where i am going wrong, because with this range and formatting, SOME of the numbers are showing up #######.

 

Below is my formatting code. What am i missing? It seems like it formats some based on the "$#,##0.00", but it doesn't work for them all.

How do i set everything to "Currency" like in the excel options? I have tried range.NumberFormat = "Currency" but that is invalid. Any help is appreciated.

 Microsoft.Office.Interop.Excel._Application excel = new Microsoft.Office.Interop.Excel.ApplicationClass();
      Microsoft.Office.Interop.Excel.Workbook wb = (Microsoft.Office.Interop.Excel.Workbook)excel.Workbooks.Add(System.Reflection.Missing.Value);
      Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.In
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend