Accessing April CTP OLAP cube from Excel 2003

Accessing April CTP OLAP cube from Excel 2003

• Richard Blackburn

  Error was fixed by adding the domain name to the username when logging into the Analysis Services server. <domain name>\<username>
  
  

• Anusuya

  Having the same issue here. No idea how to fix it at this point. Any ideas would be much appreciated. I am trying to access a cube in AS2005 from EXCEL 2003. Access through excel to the cube works fine from the server hosting the AS 2005 cube. It does not work when connecting to the cube from a remote machine.
  
  

• P.V.Shanthi

  Do you have msolap80.dll on your machine Somehow the 80 dll may have made itself the default for olap access. Try to re-register the olap 9.0 dll at command prompt
  
  regsvr32 "%program files%\common files\system\ole db\msolap90.dll"
  
  

• Matt S

  I had the same error and I installed the Office Service pack 2. Even though I am still getting the error and after clicking ok for that and pointing the data source it allows me to access data.
  
  

• John Mark Howell

  Spot on - thanks very much

  Regards

  Nick

  
  
  

• Thanh Duong

  I did all things you mentioned before and it still does not working. Could it be a problem that I have installed OWC10 and then I installed OWC11
  
  I have also installed "Microsoft OLE DB Provider for Analysis Services 9.0" and I registered msolap90.dll and unregistered msolap80.dll and none of this helped.
  
  Maybe other DLL's have this msolap80.dll as default written somwhere
  
  Does any one have any other ideas Many thanks for any help you could give me.
  
  
  Hint: The connection works fine when I try it on a brand new machine with Windows XP & Office 2002 SP2 (and OLEDB 9.0). It is not working at all with "old" computer where OLEDB8.0 was installed before. And I have no idea why.
  
  
  

• LFLFM

  Save your password creating odc file (mark checkbox "Save password in file"). Should help
  
  

• Thomas B

  I'm still having trouble with this as I still get the error.

  I have XML6.0 installed, OLE DB 9.0 installed but I still get the error when trying to connect to the OLAP server. Anymore ideas

  Thanks

  
  

• zespri

  In SQL2000 you could extract ptsfull.exe or ptslite.exe from the distribution disks and run these on the client to install OLAP 8.0 without installing the whole SQL Client tools suite. Pivot table services would then work in Excel against a SQL2000 Analysis Services database.

  Try as I might I can't find these files on the SQL2005 distribution disks. Have they been renamed or is this approach no longer supported Being able to install OLAP 9.0 on clients would be very useful.

  Has anyone discovered the secret to this yet

  Regards

  Nick

  
  
  

• jarda.jirava

  Hi
  I have the same problem and i did the solotion to registe the olap 9.0.dll and it don't resolve my problems. Do you know why.

  Thank you for your help.

  
  
  

• jjoravec

  Hi,

  I've the same problem and this solution has changed anything.

  Please help me!!!!!!!!

  
  

• PeterSpanien

  You can install OLE DB 9.0 via a download from MS. I think this is what you are asking.... I found it at the following link:

  http://www.microsoft.com/downloads/details.aspx familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

  I downloaded the file called "SQLServer2005_ASOLEDB9.msi".

  You can also get to the same page by googling Analysis Services OLE DB 9.0 if the link fails. In addtion to installing this, I also had to install XML6.0 first. The installer for OLE DB 9.0 will let you know if this is needed. The XML 6.0 upgrade is also available on MS site though I was only able to locate through a Google search looking for "XML 6.0 download". I then pulled down the install called "msxml6.msi".

  Hope this helps!

  
  
  
• Accessing April CTP OLAP cube from Excel 2003