Hi,

I have a cube setup and working for all of the office machines (olap server
at different location) One client reported she got a message "No data source
specified."

I am not able to recreate the issue she's having. I've been researching on
this issue for the last 3 days but still can't resolve it.

Can anyone help me fix this? The connection string I used is below:

PivotControl.ConnectionString = "PROVIDER=MSOLAP.2;" & _
"DATA SOURCE=http://server.com; INITIAL CATALOG=database; user id=user;
password=password;"

Many thanks,

Brian