dbTalk Databases Forums  

AS2000 and XML/A Problem

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


Discuss AS2000 and XML/A Problem in the microsoft.public.sqlserver.olap forum.



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

Default AS2000 and XML/A Problem - 04-19-2006 , 09:11 AM






I can't connect to AS2000 on my local machine using the sample.net
application from the xmla 1.1 sdk.

I installed AS2000 with SP4.
I installed XMLA from the XMLA 1.1 SDK
I created XMLA virtual directory in IIS


I ran sample.net
I enter: http://localhost/xmla/msxisapi.dll as url
I click update
I get following error: The request failed with http status 405. Method
not
allowed

When i open the same from IE
http://localhost/xmla/msxisapi.dll

I get the message the web service supports only POST operation

any help much appreciated.


Reply With Quote
  #2  
Old   
Akshai Mirchandani [MS]
 
Posts: n/a

Default Re: AS2000 and XML/A Problem - 04-19-2006 , 01:30 PM






I think you have a configuration issue -- most likely you haven't allowed
the POST operation on the virtual directory...

HTH,
Akshai

--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Uma" <uma.kewl (AT) gmail (DOT) com> wrote

Quote:
I can't connect to AS2000 on my local machine using the sample.net
application from the xmla 1.1 sdk.

I installed AS2000 with SP4.
I installed XMLA from the XMLA 1.1 SDK
I created XMLA virtual directory in IIS


I ran sample.net
I enter: http://localhost/xmla/msxisapi.dll as url
I click update
I get following error: The request failed with http status 405. Method
not
allowed

When i open the same from IE
http://localhost/xmla/msxisapi.dll

I get the message the web service supports only POST operation

any help much appreciated.




Reply With Quote
  #3  
Old   
Uma
 
Posts: n/a

Default Re: AS2000 and XML/A Problem - 04-20-2006 , 12:01 AM



It has all opearion set 'on' like POST,GET,HEAD and DEBUG.

<?xml version="1.0" ?>
- <SOAP-ENV:Envelope
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
- <SOAP-ENV:Body>
- <SOAP-ENV:Fault>
<faultcode>XMLAnalysisError.88BA0800</faultcode>
<faultstring>The Web Service supports only the POST
operation.</faultstring>
<faultactor>XML for Analysis Provider</faultactor>
- <detail>
- <faultstring>
<Error ErrorCode="2293893120" Description="The Web Service supports
only the POST operation." Source="XML for Analysis Provider" />
</faultstring>
</detail>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Akshai , Can you please explain me in detail?


Reply With Quote
  #4  
Old   
Uma
 
Posts: n/a

Default Re: AS2000 and XML/A Problem - 04-20-2006 , 12:21 AM



Please see the following error message... now i am getting "Access
Denied"

The following exception has occurred:
WebException: The request failed with HTTP status 401: Access Denied.


Reply With Quote
  #5  
Old   
Uma
 
Posts: n/a

Default Re: AS2000 and XML/A Problem - 04-20-2006 , 05:24 AM



Hi Akshai, I set the virtual directory's application protection to LOW.
Now the sample.net program comes with XML/A 1.1 is working Fine.

Thanks Akshai for your help.

Now I am using Visual studio dotnet Business Intelligence Control to
access the OLAP data. When i run the sample project, i click on
connection sample -> get datasources --> it gives me "access denied".
The sample virtual directory is already set to Low Application
protection.

I created a new project and properly configured the iis settings. When
i run the project, it gives error "Access Denied".I added network
credentials as mentioned in the help file of BI control, now i do not
get the access denied error.
(olapControl1.XmlaSoapClient.Credentials = New
System.Net.NetworkCredential("userid", "mypassword", "mydomain")

But now it throws me different error

"Unable to process the request, because the DataSourceInfo property was

missing or not correctly specified. "

The connection string is here

OlapControl1.Connection = New
MSSQLBI.XmlAnalysis.Data.MdxConnection("http://localhost/bitest/xmla/msxisapi.dll",
"Provider=MSOLAP.2;data source=local", "FoodMart 2000", "Sales")

Akshai Please assist to go further.


Reply With Quote
  #6  
Old   
Akshai Mirchandani [MS]
 
Posts: n/a

Default Re: AS2000 and XML/A Problem - 04-20-2006 , 12:24 PM



If I remember correctly, the BI Control only works with XMLA 1.0... I don't
think that they added support for 1.1 -- and there is a breaking change
between the two releases which makes it fail against 1.1.

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Uma" <uma.kewl (AT) gmail (DOT) com> wrote

Quote:
Hi Akshai, I set the virtual directory's application protection to LOW.
Now the sample.net program comes with XML/A 1.1 is working Fine.

Thanks Akshai for your help.

Now I am using Visual studio dotnet Business Intelligence Control to
access the OLAP data. When i run the sample project, i click on
connection sample -> get datasources --> it gives me "access denied".
The sample virtual directory is already set to Low Application
protection.

I created a new project and properly configured the iis settings. When
i run the project, it gives error "Access Denied".I added network
credentials as mentioned in the help file of BI control, now i do not
get the access denied error.
(olapControl1.XmlaSoapClient.Credentials = New
System.Net.NetworkCredential("userid", "mypassword", "mydomain")

But now it throws me different error

"Unable to process the request, because the DataSourceInfo property was

missing or not correctly specified. "

The connection string is here

OlapControl1.Connection = New
MSSQLBI.XmlAnalysis.Data.MdxConnection("http://localhost/bitest/xmla/msxisapi.dll",
"Provider=MSOLAP.2;data source=local", "FoodMart 2000", "Sales")

Akshai Please assist to go further.




Reply With Quote
  #7  
Old   
Uma
 
Posts: n/a

Default Re: AS2000 and XML/A Problem - 04-21-2006 , 04:04 AM



Thanks Akshi for your help.

It works fine with XML/A 1.0.


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.