Problem with MDX Connection String in .Net

Hi,

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:

con.Open(connection_string,"sa","",0);

Donno what the problem is.

Could anyone plz. help? Is my connection string correct??

Thanks in advance!

Arun KK