| :: Connection to Cube using MSolap Connection :: (1) | Post a New Message | Post a Reply |
 Connection to Cube using MSolap Connection | Post a Reply |
since: Sep 6, 2005
from: Hier
I am trying to connect to a SQL Analysis Database via your report wizard,
using a msolap connection
The connection string looks as follows:
"Provider=msolap;data Source=127.0.0.1;uid=sa;Database=QQQ"
I am able to read all the cubes from the database, but as soon as I try to click on one of the cubes - I can't see the data.
Futher more when I click to build report - the new window opens up and gives an error specifying that a Unexpected end of statement wasfound.
If you could please point me into the right direction, it would be great.
Or even if it is possible to do this with the report wizard???
Thanks
Sakkie