472,093 Members | 2,481 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,093 software developers and data experts.

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 2656

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.