Re: Repost: Can't connect to XMLA

From: Joe Genshlea (joegensh_at_yahoo.com)
Date: 03/24/04

  • Next message: Akshai Mirchandani [MS]: "Re: XML/A Schema in Response documents.." 
    Date: Wed, 24 Mar 2004 10:33:00 -0800

    Thanks so much, I will give it a shot.

    If only your site came up on the various google searches I ran. Maybe my
    choice of search prhases could have been better.

    Joe

    "Chris Harrington" <charrington@activeinterface.com> wrote in message
    news:%23QEmY8UEEHA.4080@TK2MSFTNGP09.phx.gbl...
    > Joe,
    >
    > I have samples at my XML/A blog which demonstrate a simple HTTP SOAP
    client.
    > You could replicate the logic I used in probably any language. I've
    attached
    > a generic XML/A command-line client which works this way. This one is
    newer
    > and more feature complete than the one currently on the web site.
    >
    > http://www.activeinterface.com/thinolap/thinolap.asp
    >
    > Chris
    >
    > "Joe Genshlea" <joegensh@yahoo.com> wrote in message
    > news:OTmLqZHEEHA.2408@TK2MSFTNGP10.phx.gbl...
    > > Hi,
    > >
    > > I hate to repost, but I have been working on this for hours and would
    > > apreciate any feedback whatsoever.
    > >
    > > Thanks in advance.
    > >
    > > I am writing a coldfusion application and would just like to test
    > something
    > > very simple.
    > >
    > > I have test the following MDX statement in the sample app and now I'd
    like
    > > to execute it through a ColdFusion App. When I run this MDX through the
    > > ColdFusion App I get
    > >
    > > "Connection Failure"
    > >
    > >
    > >
    > >
    >
    ColdFusion -----------------------------------------------------------------
    > > -----------------
    > >
    > > <HTML>
    > >
    > >
    > > <CFFILE ACTION = READ
    > > VARIABLE = MyXML
    > > file = "c:\inetpub\wwwroot\intranet\modules\HelloWorld.xml">
    > >
    > >
    > > <CFOUTPUT> #MyXML# <BR> </CFOUTPUT>
    > >
    > > <CFHTTP METHOD ="POST" URL = "http://localhost/xmla/msxisapi.dll">
    > >
    > > <CFHTTPPARAM NAME = "body" VALUE ="#ToString(myXML)#" type
    ="XML"
    > > >
    > > </CFHTTP>
    > >
    > > <CFOUTPUT>
    > > #CFHTTP.filecontent#
    > > </CFOUTPUT>
    > >
    > >
    > >
    > > </HTML>
    > >
    > >
    > >
    > >
    > >
    > >
    > >
    > >
    > >
    >
    Helloworld.xml--------------------------------------------------------------
    > > -------------------
    > >
    > > <Execute>
    > > <Command>
    > > <Statement>SELECT NON Empty crossjoin ({[Property
    Type].members},
    > > {[Measures].members}) on columns, NON EMPTY {[Territory].[All
    > > Territory].[Central Region].children} on rows From Sales where [Business
    > > Close].[Month].&amp;[99] </Statement>
    > > </Command>
    > > <Properties>
    > > <PropertyList>
    > > <DataSourceInfo>Local Analysis Server</DataSourceInfo>
    > > <Format>Multidimensional</Format><Catalog>NCA</Catalog>
    > > <AxisFormat>TupleFormat</AxisFormat>
    > > </PropertyList>
    > > </Properties>
    > > </Execute>
    > >
    > >
    > > Data Sources-----------------------------------------------
    > >
    > > - <DataSources UnnamedSessionsTimeout="300" NamedSessionsTimeout="3600"
    > > MaxRequestSize="128" AllowInsecureTransport="1">
    > > - <DataSource>
    > > <DataSourceName>Local Analysis Server</DataSourceName>
    > > <DataSourceDescription>Microsoft Analysis Server 2000 on
    > > CHEF</DataSourceDescription>
    > > <URL>http://localhost/xmla/msxisapi.dll>
    > > <DataSourceInfo>Provider=MSOLAP.2;Data Source=chef; </DataSourceInfo>
    > > <ProviderName>Microsoft XML for Analysis</ProviderName>
    > > - <ProviderType>
    > > <TDP />
    > > <MDP />
    > > <DMP />
    > > </ProviderType>
    > > <AuthenticationMode>Unauthenticated</AuthenticationMode>
    > > </DataSource>
    > >
    > >
    >
    >
    >

  • Next message: Akshai Mirchandani [MS]: "Re: XML/A Schema in Response documents.."