no datasource found - mondrian
ODBO provider for connections to XMLA data sources
Status: Beta
Brought to you by:
alexa77
Hello,
i have a problem connecting to my xmla-connection. I'm using mondrian.
When i connect to the XMLA analysis from the web-interface mondrian finds the datasource (via xmlaTestPage.jsp which is linking to the xmla.jsp-Query).
But if i want to access xmla using the Excel-Plugin the error message from the screenshot appears.
Any idea how to fix it?
My connection-adress looks like http://IPADRESS:8080/mondrian/xmla
My datasource is called "DsMySQL".
There's a foodmart-databaseuser for the FoodMart database.
The Catalog is called "FoodMart".
This is an error generated by Mondrian. Can you use fiddler from here www.telerik.com/download/fiddler/fiddler2 to record the traffic? Check the file attached for details about the setup of a session. This way we will see better what happens.
It says there's a datasource configured with null, but it din't configure it with null.
In the Excel-Plugin i entered my Datasource "DsMySQL" manually. As Username and password i entered foodmart and his password.
The error occurs when clicking on the dropdown-menu.
Do you want to have my datasource.xml or some other configuration file to look there?
I attached a txt-file.
The web interface connection fails, because my datasource is not 'MondrianFoodMart'. It's 'DsMySQL'. If I change the webinterface request in the TextArea to 'DsMySQL' there's a successful answer.
But the Excel-Plugin seems to ask with the datasource name 'null'. It's the same error when asking with a wrong Datasource name from the webinterface.