I am trying to retrieve some data from BW cubes using MDX and present them in a web page.
I am using ADOMD.Net for this.
While calling the open method of the Connection class, we need to pass the connecting string as argument.
My connection string is something like this:
Datasource=http://mysite.com/sap/bw/xml/soap/xmla; Provider=msolap;Initial Catalog=ZPM_C02;
where ZPM_C02 is the cube name.
When i run the app, i get an 'Unspecified error' exception at this line:
Donno what the problem is.
Could anyone plz. help? Is my connection string correct??
Thanks in advance!