Thursday, March 8, 2012

AS2005 and Excel

Hi all

i am trying to connect to a AS2005 cube from excel.

On my computer (Excel2003+sp1) i am able to see and broswe the cube.On the user's Pc (excel2003+sp1) I istalled the msolap9.dll but i got this error when i try to connect to the OLAPserver:

"Unable to connect to data source.Reason: Unable to locate database server"

Both me and the user are in the Cube's Role Membership.....

Any idea?

Thx in advance

Are you using this addin or not?: http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

The message "Unable to connect to data source.Reason: Unable to locate database server".,can mean that the service is down or you can have a firewall problem.

Many causes. Can you supply more details?

Regards

Thomas Ivarsson

|||

Thank you so much Thomas, that is was i forgot to install....

thx

No comments:

Post a Comment