Post reply

C# ADOMD Connection error - Element return was not found

  • December 23, 2013 at 9:57 am

    #98952

    Hi guys

    I am trying to put together a Dashboard using VS2012 in c#. I want to connect to my Cube in order to retrieve the Data to be displayed in Graphs.

    I have the following connection:

    AdomdConnection myconnect = new AdomdConnection(@"provider=msolap.5;initial catalog=Cube;datasource=xx.xx.xx.xx;UID=MyUser;PWD=MyPassword;Timeout=10000;connect timeout=1000");

    When I replace xx.xx.xx.xx (in AWS) by "localhost" I can connect and run MDX Queries otherwise I get the Element error.

    In some forums, some people advise to increase the timeout delay but it doesn't seem to make any difference. The error message comes back straight after calling Open() whatever value I use.

    Any ideas?

    Cheers

  • December 23, 2013 at 6:24 pm

    #1675713

    Add the port number to the IP address. To find the correct port number: http://support.microsoft.com/kb/2466860

  • December 24, 2013 at 1:37 am

    #1675737

    Hi

    Thanks for the info but I have already tried with xx.xx.xx.xx:2383 an go the same result.

    Cheers

  • March 3, 2015 at 7:24 am

    #1781348

    If you are using the ADOMD.NET DLL installed under C:\Program Files\Microsoft.NET\ADOMD.NET\120, try referencing the one under the "100" folder instead.

    I was getting the same error and this worked for me.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply