dbTalk Databases Forums  

XMLA & ASP.NET

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss XMLA & ASP.NET in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tony
 
Posts: n/a

Default XMLA & ASP.NET - 08-13-2003 , 11:14 AM






Hi,

I am trying the below code to gain access to Analysis Services, but I
can't seem to get a result back, it always errors with Object
Reference not set, which indicates that the XML is not being set. My
set up seems to be ok, my datasources.xml is configured correctly,
XMLA only accepts POST and I can access the Analysis Services via the
management console.

Any ideas???

// Create the Xml for Analysis proxy class
MsXmlAnalysis xa = new MsXmlAnalysis();
xa.Credentials = System.Net.CredentialCache.DefaultCredentials;

//server url
xa.Url = "http://localhost/xmla/msxisapi.dll";

XmlDocument restrictDom = new XmlDocument();
XmlDocument propDom = new XmlDocument();

restrictDom.LoadXml("<RestrictionList></RestrictionList>");
propDom.LoadXml("<PropertyList></PropertyList>");

XmlElement xelem3;

// Call the execute method
xelem3 = (XmlElement)xa.Discover("DISCOVER_DATASOURCES", (XmlElement
restrictDom.FirstChild, (XmlElement)propDom.FirstChild);

//it will return the resulted xml
return "<ROOT>" + xelem3.InnerXml + "</ROOT>";

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.