User (Legacy) Posted October 21, 2004 Report Share Posted October 21, 2004 I have XML for Analysis installed and their sample is working. I have ChartFX and ChartFX OLAP installed and a simple example working using AdoMultiDimensionalData. What I want however is to use XmlAnalysisData to connect to a URL. When I use the code below directly from the SoftwareFX Extensions API docs and I get the following err: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. XmlAnalysisData code directly from SoftwareFX API docs: xmlaProvider.Url = "http://localhost/xmla/msxisapi.dll" xmlaProvider.Catalog = "FoodMart 2000" xmlaProvider.Statement = "SELECT {[store].[store Country].[uSA].Children} ON COLUMNS,{CROSSJOIN(Descendants([Gender]),Descendants([Time].[1997]))} ON ROWS From [sales]" xmlaProvider.DataSource = "Provider=MSOLAP;Data Source=localhost" xmlaProvider.Connect() Please advise, Tyler Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.