Problem with MDX Connection String in .Net

[Former Member]

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

[Former Member]

Hi,

"sa" user looks like the MSSQL server admin logon user.

As far as I understand, you'll have to specify with which user you want to connect to BW.

Can you paste the code related to your open connection and what's in the connection string?

Olivier.

[Former Member]

Hi Olivier,

I had put 'sa' jus as an example.

Here goes my code.

connString = "Datasource=http://mysite.com/sap/bw/xml/soap/xmla; Provider=msolap;";

mdxQuery = "SELECT {[Measures].[0OPR_PLDWRK],[Measures].[0OPR_ACTWRK]} ON COLUMNS, "

+ "NON EMPTY [0PLANT].MEMBERS ON ROWS FROM [$ZPM_C02]";

sapConnection = new ConnectionClass();

sapConnection.Open(connString,user_id,"******",0);