469,903 Members | 2,004 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

Cannot connect to the cube via pivot table control


I am using a pivot table control (OWC) via web access to an analysis server.

My connection string is:

ci.ConnectionString = "Provider=MSOLAP.2;User ID=peterdev01\\" + the_username +
";Password=" + the_password +
";Data Source=http://peterdev01/webtest;Initial Catalog=Peter ALL v2;Integrated Security=SSPI;Persist Security Info=True;Client Cache Size=25;Auto Synch Period=10000";

ci.DataMember = "PIER cubes"

I have set the above database security of analysis server to "All Users".

Then, on my pivot table control, it shows:
"The cube name 'Peter cubes' is invalid."

Why ?? How can I solve the problem?
Regards,
Peter
Jul 20 '05 #1
0 2599

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Wojtek Jurek | last post: by
reply views Thread by Tim_k | last post: by
1 post views Thread by thomas.wordsworth | last post: by
7 posts views Thread by J-Burns | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.