March 7, 2006 at 3:10 am
Hello all,
Before migrating our server from SQL2000 to SQL2005 I had a web page using OWC10 component and XMLA to browse Analysis services cubes via a web application.
Now this do no work any more. I read some articles about using msmdpump.dll instead of msolap.asp in the olap web service (In order to set up the XMLA communication is suppose)
Must OWC10 be updated also ? but with what since i heard that OWC are now integrated in AS . I recongnize all this is not very clear for me
Do some one has already resolved this ? Code samples, links or advices discussing on this topic with (only with SQL2005) would be appreciated.
Thanks
Oliver
March 7, 2006 at 8:52 am
Hi Oliver,
If you were previously using msolap.dll then you weren't using XMLA (as I know it anyway), you were more likely using HTTP access which is slightly different. I'm not sure if setting up XMLA over http (versus the native TCP) will help you, but here is a link to the instructions for doing this -> http://www.sqlserveranalysisservices.com/OLAPPapers/ConfiguringHTTPAccessToYukon.htm
I think this may have been for the beta bits but should still hold true for the RTM version.
HTH,
Steve.
March 7, 2006 at 9:07 am
Hi Steve,
Indeed , I had already saw this link and followed the steps to set up the olap web service, using msmdpump.dll.
I think it is part of the solution, but i need others pieces of the puzzle, As soon as i get the sworking solution, i will give the infos here.
Thanks
March 10, 2006 at 8:00 am
Did you upgrade to the MSOLAP.3 (the ole db for olap 9) driver? I was thinking that maybe if OWC uses OLEDB for the connection, if you had the driver it might translate to XMLA over TCP (rather than http). The updated ptslite is part of the Feature Pack (released Nov 05) for SQL2005, found on the Msft website here -> http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
Steve.
March 13, 2006 at 7:43 am
I got this to work using AS2K5 (naed instance on my local machine) and Excel (2003). What (if any) error message/s were you getting when trying to connect?
Steve.
March 14, 2006 at 7:55 am
Hi Steve
Still fighting with step 1 (the olap virtual directory) !
The following URL http://myserver/olap/msmdpump.dll reponds with an http500 error instead of sending a SOAP message like the one described at http://www.activeinterface.com/b2005_11_21.html
I have excuted and checked all steps in document http://www.sqlserveranalysisservices.com/OLAPPapers/ConfiguringHTTPAccessToYukon.htm
My pc ( running WXP2002 + SP2 and all SDKs and SQL client parts for AS2K5 ) is connected to myserver (W2003 ) which hosts the olap virtual directory and AS2K5
I guess something is still missing (an hot fix, a security parameter, a right on a file)
An idea ?
March 14, 2006 at 10:53 pm
I was getting the 500 error to, but I think this is due to having your browser set to displaying 'friendly' http errors (you can change this in tools|Internet Options|Advanced|Browsing subtree-> Show Friendly Http Errors checkbox).
Did you end up updating the PTSLite on your client machine to the one available in the SQL 2005 Feature pack (msdn site)?
Steve.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy