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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Microsoft.AnalysisServices.AdomdClient problem

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :Sql Server
I had a C# Winforms project referencing Microsoft.AnalysisServices.AdomdClient. It was working 100%. I upgarded MS SQL 2008 to R2. I also installed the relevant programs in the SQL2008 R2 feature pack. What happens now is after I add a reference to Microsoft.AnalysisServices.AdomdClient, I can add a using statement to the dll. If I type Microsoft, add a dot intellisence will give me 'AnalysisServices' and I can complete the statement. As soon as I build the project, I get a squirel below 'AnalysisServices' and the error message: Error 2 The type or namespace name 'AnalysisServices' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?) The version of Microsoft.AnalysisServices.AdomdClient is The runtime version is v2.0.50727. The fileversion and product version is 10.50.1600.1. I work on a Windows Vista computer using Visual Studio Professional. I am realy desperate for help. I spend the entire weekend uninstalling and re-installing SQL 2008 R2, Visual Studio and the feature pack. All to no avail. I am not sure what forum to select.

View Complete Post

More Related Resource Links

Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint


I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Any help will be very appreciated!


Microsoft .net framework 1.1 installation problem

Well I know there is numerous posts about .net framework 1.1 installation failure,I have searched through a lot of them.I failed to resolve my  problem so I am posting this.when I try to install .net framework 1.1 redistributable package which I downloaded from here it installs  .net framework version 1.0.3705 then when I want to install .net framework 1.1 service pack 1 downloaded from here which has the file NDP1.1sp1-KB867460-X86.exe  it doesnt install showing the message  ''The upgrade patch can't be installed by the windows installer service because the program to be upgraded may be missing,or the upgrade patch may update a different version of the program.Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch.'' I have tried a lot of way to solve this including:using the stebner cleanup tool to erase all versions of framework then restarting  machine and reinstalling again but this way can't solve the problem,modifying registry etc.Other versions(1.0,2.0,3.0,3.5) are installing smoothly they are not creating problems only this fw 1.1.How can I resolve this issue.Please anyone help

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

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=, 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

Problem Install of Microsoft .net Framework 3.5 for over a month.

I have looked at all suggested solutions and had tried all the I found.  No success. I had .net running using Roxio Creator 2009 until the update came out in Feb. 2010. I am using Vista Home premium sp2. I have created the Cab for the files.  Where do I send it? Microsoft .NET Framework 3.5 Service Pack 1 and .NET Framework 3.5 Family Update (KB951847) x64 Installation date: ‎3/‎20/‎2010 5:33 PM Installation status: Failed Error details: Code 643 Update type: Important This update is applicable to Windows Vista Service Pack 2 and Windows Server 2008 Service Pack 2. The Microsoft .NET Framework 3.5 Service Pack 1 is a full cumulative update that contains many new features building incrementally upon .NET Framework 2.0, 3.0, 3.5, and includes cumulative servicing updates to the .NET Framework 2.0 and the .NET Framework 3.0 subcomponents. The .NET Framework 3.5 Family Update provides important application compatibility updates. This update is provided to you and licensed under the Windows Vista and Windows Server 2008 License Terms. More information: http://go.microsoft.com/fwlink/?LinkId=133335 Help and Support: http://support.microsoft.com

Problem trying to attach database file to Microsoft SQL Server Management Studio

I was trying to attach a database to SQL Server MGT Studio and got an exception error.  The message stated that the database file I was trying to attach could not be opened because it was version 661.  The SQL Server shows to support version 655 and earlier.  It states that a downgrade path is not supported. Question:  Is there some download ; fix; I can make to SQL Server 2008 that will allow me to attach the version 661????  I am not technical at all.  Please speak slowly.  :)  Thanks

Problem with Microsoft.NET Framework

i had my PC format recently, and installed windows Vista home premium, the moment i turned on my PC i had this

Unhandled exception has occurred in your application, If you click Continue, the application will ignore this error and attempt to continue.
if you click Quit, the application will close immediately.

Argument 'Year' is not valid value.

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.ArgumentException: Argument 'Year' is not a valid value.
   at Microsoft.VisualBasic.DateAndTime.DateSerial(Int32 Year, Int32 Month, Int32 Day)
   at EULALauncher.NET.Form1.Form1_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.Contain

Microsoft Word Mail Merge Problem


I wrote code to create label from Microsoft Word Mail Merge using Visual Studio 2008 ASP.NET C#. This is my code:

public void CreateLabel(string strCSVPath, string strTemplatePath)
            Object fileName = strTemplatePath;

            Object missing = System.Reflection.Missing.Value;
            Object oEmpty = "";
            Object oFalse = false;
            Object oTrue = true;
            Object oAutoFormat = word.WdOpenFormat.wdOpenFormatAuto;

            word.Application wApp = new word.Application();
            word.Document wDoc = wApp.Documents.Open(ref fileName,
                ref missing, ref missing, ref missing, ref missing, ref missing,
                ref missing, ref missing, ref missing, ref missing, ref missing,
                ref missing, ref missing, ref missing, ref missing, ref missing);
            word.MailMerge wMM = wDoc.MailMerge;

            wMM.OpenDataSource(strCSVPath, ref oAutoFormat, ref oTrue, ref oFalse, ref oTrue,
                                ref oFalse, ref oEmpty, ref oEmpty, ref oFalse, ref oEmpty, ref oEmpty,
                                ref oEmpty, ref oEmpty, ref oEmpty, ref missing, ref missing);

            wMM.DataSource.QueryString = "SELECT * FROM " + strCSVPath;

            wMM.Destination = word.WdMailMergeDestination.wdSendToNewDocument;


Microsoft SQL Server 2008 Enterprise Installation Problem


Good evening!

I downloaded Microsoft SQL Server 2008 Enterprise Edition (x86 and x64) from MSDNAA (i study computer science) and also  Windows 7 Professional (x86). I installed Windows 7 and i tried to install SQL Server but i receive the "Microsoft .NET Framework 3.5 installation has failed. SQL Server 2008 Setup requires .NET Framework 3.5 to be installed." error. I tried installing .NET Framework but it doesn't work because it's installed by default with Windows 7 (i checked the "Turn Windows features on or off" page and the "Microsoft .NET framework 3.5.1" checkbox is checked). I understand that this means .NET framework 3.5 SP1 is also installed so i shouldn't have any errors.

Can anyone help me with this installation problem?

Thank you!

Microsoft SQL Server 2005 Uninstall remove problem


In trying to install the 2010 Switched On Schoolhouse Home Edition it tries to install the SQL server then comes up with error message that it fails.


Tech support walked me through trying to delete all the SQL titles manually and I came to the last and only application of Microsoft SQL Server 2005 with a log file "80" that will NOT delete.


The IT told me it was corrupt in the registry.


Is there ANY way to delete this??? The new installation has a newer version but I think it is the same one.


Thanks, Ricky

Referencing Microsoft.AnalysisServices.XMLA?


Hi Guys,

How can i reference Microsoft.AnalysisServices.XMLA.dll in my project? Im using SQL Server 2008 R2.


problem while installing microsoft chart add-on for visual studio


When I tried to install chart add-on for visual studio it was asking for microsoft chart controls to be installed as a pre requisite.

Then I installed .net framwork 3.5 sp1 and installed microsoft chart add-on for visual studio

but microsoft chart control add-on for visual studio is asking for .net framework 3.5 to be installed as a prerequisite.

But if I install .net framework 3.5 i cant install microsoft chart controls because it requires .net framework 3.5 sp1.

Can anyone help me to resolve this issue please.

Microsoft Sharepoint Workspace has encountered problem

  • Installed SharePoint 2010 Workspace on two machines: one works perfectly; the other crashes
  • After the start-up splash screen and the one-inch square message "Creating an account", I am taken to the option of creating an account or restore an existing account
  • Two or three seconds later, regardless what option I pick, or choose to do nothing, the configuration wizard crashes, with "Microsoft Sharepoint Workspace has encountered problem."
  • Have uninstalled and re-installed SharePoint Workspace
  • Have uninstalled and re-installed all of Office 2010
  • Have tried installing SharePoint only as "Run on first use"
  • Have run command.com, gone to groove and run groove.exe/clean/all
  • Operating system: Windows XP SP 3, running as admin
  • All other Office 2010 features run smooth as silk

Problem with "Error 0xD59 when trying to install the Microsoft SQL Server Express edition Service Pa

Hi Folks,

I've been jumping from site to site trying to find a solution for this and still no luck.  I have tried this update many times but it always fails.  I have the results of the installation log here if it helps.  I am on HP hardware using XP.  Any help is most appreciated.  Thanks for reading!

Time: 11/30/2009 06:25:09.718
KB Number: KB955706
OS Version: Microsoft Windows XP Professional Service Pack 3 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 3
Package Version: 4035
Command-line parameters specified:
Cluster Installation: No

Prerequisites Check & Status
SQLSupport: Passed

Products Detected                         Language  Level  Patch Level       Platform  Edition
Express Database Services (MSSMLBIZ)      ENU       SP2    2005.090.3042.00  x86       EXPRESS

Products Disqualified & Reason

Problem Installing Microsoft .NET Framework 4 on Vista Ultimate



I am running a Dell XPS m1530 and have been having trouble installing Framework 4 for the last while. I have been through every forum i could find and used every FixIt and tried every piece of advice, but none have worked. I have reset WU, tried to manually and automatically update, from normal and safe mode.

Here is the end of the error log i got from my latest attempt:

[10/20/2010, 23:56:16]Signature verification succeeded for netfx_Extended_x86.msi
[10/20/2010, 23:56:16]Download succeeded at attempt 1 of 4 for http://go.microsoft.com/fwlink/?LinkId=164180&clcid=0x409 using BITS
[10/20/2010, 23:56:16] Action complete
[10/20/2010, 23:56:16]Final Result: Installation failed with error code: (0x00000026), "Reached the end of the file. " (Elapsed time: 0 00:01:33).

I dont know what else to do, some help would be greatly appreciated.


Microsoft.AnalysisServices Translations management from c#


Dear all,

I connect to an OLAP cube from .NET (v3.5, c#) using the objects located in the Microsoft.AnalysisServices namespace. I would like to dynamically manage my translations for dimensions, attributes, measures, measure groups. 

A sample code for updating the translations of an attribute is the following:


foreach(DimensionAttribute attribute in dimension.Attributes){
 attribute.Translations.Add(1043, "Some Caption");

The above code however throws an InvalidOperationException "The item Translation is not valid" when trying to add. 

Any ideas why this is happening and how to fix it?


Microsoft Ribbon for WPF - problem under Windows XP


Hello everyone!

I'm having a problem with WPF Ribbon Application under Windows XP. Applications window borders shows up weirdly and ugly. I think screenshot will describe my problem best. This is a screenshot from sample project supplied with Microsoft Ribbon for WPF installation package:


I'm developing with Visual Studio 2010 and C#-language. .NET framework 4.0 installed. The problem doesn't happen with normal WPF Application.

My client wants ribbon-like user interface and they are still using Windows XP. I would greatly appreciate any help as I'm running out of my own ideas.

Sincerely Otto Patolinna

Microsoft OLEDB Provider for DB2 problem


I have an SSIS package that uses the Microsoft OLEDB Provider for DB2.

The connection to the DB2 machine works 100%, but when I try run a query I get the follwing error

An internal network library error has occurred. A network level syntax error has occurred. SQLSTATE: HY000, SQLCODE: -379 

The query parses fine but can't seem to run

Thanks in advance!

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