I want to access a Microsoft Analysis Server 2000 cube With excel 2013 in Windows 10. I cannot install the "SQLServer2005_BC.msi" because it is not compatible. The "SQLServer2005_BC_x64.msi" installs but it do nothing. I can not install
Analysis Server 2000 components, because it is not compatible.
I experiment the same in Windows 8 but installing Analysis Server 2000 components solve the problem.
What can I do ? I can not use Windows 10 to connect to Analysis Server 2000 server?
I have also a VB6 program that connect to the server and also do not work and it works in Windows 8.
Public dbOLAP As New ADODB.Connection
dbOLAP.Open "provider=msolap;data source=server;Initial Catalog=Ventas;"