March 29, 2007 at 7:51 am
Good afternoon,
I am running the above and have created three cubes (on a seperate server). I am able to browse the cubes from myone pc. I have SQL 2k5 and Visual Studio installed.
I am unable to browse the cubes using excel 2002 or 2003 on any one elses pc (using my credientials). I have managed to test it on office 2007 and it works fine.
To me it seems as if a newer connection type is needed, which I am unable to find.
Any ideas??
March 30, 2007 at 12:36 pm
Are you connecting from the clients and then finding you can't browse, or are you unable to even connect? When you try to connect through excel, do you see the Microsoft OLE DB Provider for Analysis Services 9.0 as an option when creating the data source?
April 2, 2007 at 6:30 am
Hi Sean,
I am connecting via excel (office 2002). I do not get that option.
Thx
Frank
April 2, 2007 at 6:47 am
Sean,
Your last post pointed me in the right way.
Installed the following and I can now connect.
msxml6
SQLServer2005_ASOLEDB9
Many thanks
Frank
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply