Examples of Connecting to SSAS via XMLA

[mark_ellul]

Hi,

I am new to the OpenLink Ajax Toolkit, I was wondering if there are any examples of connecting to SqlServer Analysis Services via the XMLA functionality?

I am trying to connect to my local machine using the code below, in IE it shows nothing wrong neither does it do the alert, and i Firefox 3 it shows a Ajax Error.

PS: I have set up the XMLA over HTTP using IIS (which I am running on port 8181...long story)... using the information provided by http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx

Code: Select all

    <script type="text/javascript">
    var featureList = ["xmla"];

    options = new Object();
    options.endpoint = "http://http://localhost:8181/olap/msmdpump.dll";

    OAT.Xmla.connection = new Object();
    OAT.Xmla.connection.options = options;

    var callback = function(data) {
               alert(data); // array of DSNs
               }
    OAT.Xmla.discover(callback);

    </script>

The Firefox AJAX Error is below..

Code: Select all

generic uncaught error = uncaught exception: [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [nsIXMLHttpRequest.setRequestHeader]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: http://localhost:8080/javascripts/oat/ajax2.js :: anonymous :: line 282" data: no], url = , line = 0
uncaught exception: [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [nsIXMLHttpRequest.setRequestHeader]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: http://localhost:8080/javascripts/oat/ajax2.js :: anonymous :: line 282" data: no]

Am I doing something obviously wrong?

Is my XMLA.connection set correctly?

Any help would be appreciated.

Regards

Mark

[bkutil]

Hi Mark,

These exceptions appear mostly with AJAX errors. From the code you've pasted, the options.endpoint isn't correct (note the double http://).

In case you get such error, more sensible output can be obtained by surrounding the code with try { } catch(e) { console.log(e): } and then inspecting the exception object via firebug. That can help you get a backtrace and the precise line of the error.

Let me know if this helps.

[louenlax]

How to use ajax validation for forms in php? I need to know with codes or example how can ajax be used in php for form validations, slide shows etc.
___________________
keyword research ~ keyword tool ~ keyword tracking ~ affiliate elite