Excel XP - Cannot connect to OLAP 9 - Analysis Services 2005
MS Excel XP on Windows 2000 fails to connect to OLAP 2005 Cube with the OLAP 9 Provider. Excel gives the error: <initialisering datasource failed>. The same error appears when I try to connect to OLAP 8 cubes. Before I could access OLap 8 cube, I had to reinstall Office XP.
Windows XP with Office 2003 works fine. It can access both OLAP 8.0 and OLAP 9.0 cubes.
Does the new OLAP 9.0 provider only works with Office 2003?
Best regards,
Jakobsgaard
I have been investigating a bit more in this matter...The PC which is giving os all this trouble are running Windows 2000 with Office XP SP3.
If I registre msolap90.dll, both MS Olap 8.0 and MS Olap 9.0 fails with the error: <initialisering datasource failed> when I connect to a cube from MS Excel.
But if I only registre msolap80.dll, MS Olap 8.0 works fine again.
Best regards,
Jakobsgaard
-
regsvr32 "c:\program files\common files\system\ole db\msolap90.dll"
regsvr32 "c:\program files\common files\system\ole db\msolap80.dll"
Suresh Bansal Stated the following in a further post:
"ok i found the solution. we need to reregister the olap 9.0 provider before we can use it to connect SQL Server 2005 Analysis Service Cube with Excel Pivot Table :
regsvr32 "c:\program files\common files\system\ole db\msolap90.dll"
"This did the trick for us.
