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
Excel XP - Cannot connect to OLAP 9 - Analysis Services 2005
fleshi
"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.
Brendan Comerford
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"
kojot
Edmund Leung
Windows 2000 does not have MSXML6 by default and Office XP does not install it (Office 2003 does install MSXML5 which the 9.0 provider is able to use, in the absence of MSXML6).
Installing MSXML6 solved the problem.
Robin Speed
Did you hear anything from anyone else
Mark e. Johnson