Re: Error result after connection to http://localhost/xmla/msxisapi.dll



Hi,

I'm not entirely familiar with the mssqlbiwebctrlsample application (is
this the one which comes in the XMLA SDK install?), but what happens
when you type in the URL direct into IE? Do you get the http get
error?

Your error message is indicating that XML is the expected response, but
your receiving HTML. That suggest that XMLA can't talk to your
Analysis server, so is your IIS server setup to use Windows
authentication or Anonymous.

If setup to use Anonymous, then your IIS account will need to be added
to a cube role on the Analysis Server. Better to use Windows
authentication here if possible.

HTH

John

yugicm wrote:

i never successfull to try the sample of .net webcontrol of bi. i
always got this message:

Client found response content type of 'text/html', but expected
'text/xml'.

the full message of error is:


Server Error in '/mssqlbiwebctrlsample' Application.
--------------------------------------------------------------------------------

Client found response content type of 'text/html', but expected
'text/xml'.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Client found
response content type of 'text/html', but expected 'text/xml'.

Source Error:

Line 63: private void btnGetDataSources_Click(object sender,
System.EventArgs e)
Line 64: {
Line 65: MSSQLBI.XmlAnalysis.Data.DataSource[] dataSources
= MSSQLBI.Web.Olap.OlapControl.GetDataSourceList(txtUrl.Text, null);
Line 66:
Line 67: ddlDataSource.Items.Clear();


Source File: C:\Program Files\Visual Studio .NET Web Control for
BI\Sample\connection.aspx.cs Line: 65


i already set the permission of virtual directory xmla. and my
datasource.xml :

<DataSources UnnamedSessionsTimeout="300" NamedSessionsTimeout="3600"
MaxRequestSize="128" AllowInsecureTransport="1"
EnableNagleAlgorithm="1">
<DataSource>
<DataSourceName>Local Analysis Server</DataSourceName>
<DataSourceDescription>Microsoft Analysis Server 2000 on local
machine</DataSourceDescription>
<URL>http://localhost/xmla/msxisapi.dll</URL>
<DataSourceInfo>Provider="MSOLAP.2";Data
Source=local</DataSourceInfo>
<ProviderName>Microsoft XML for Analysis</ProviderName>
<ProviderType>
<TDP/>
<MDP/>
<DMP/>
</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
</DataSource>
</DataSources>


please help me.

yugicm

.



Relevant Pages

  • Problems Connecting to MSAS2000 XMLA SDK 1.1
    ... Installed SQL Server 2000 and Analysis Server with SP4 ... Installed XMLA SDK (connection via unsecure http disabled--> only ... 'Argument "Number" is not a valid value when we execute the following ... Firefox can't find the server at www.cgi-hcadev02.com. ...
    (microsoft.public.sqlserver.olap)
  • Re: Bad performance for MDX query over XMLA
    ... XMLA is not going to be as performant compared with a native binary ... Just the size of the response alone is going to be much larger ... > My query is retrieving a large number of facts accross 5 members ... > When I run the query over PTS I get a reponse within 30 sec. ...
    (microsoft.public.data.xmlanalysis)
  • RE: Problems Connecting to MSAS2000 XMLA SDK 1.1
    ... I would greatly appreciate of kind of response for somebody. ... Installed XMLA SDK (connection via unsecure http disabled--> only ... 'Argument "Number" is not a valid value when we execute the following script: ... Firefox can't find the server at www.cgi-hcadev02.com. ...
    (microsoft.public.sqlserver.olap)
  • Problems Connecting to MSAS2000 XMLA SDK 1.1
    ... Installed XMLA SDK (connection via unsecure http disabled--> only ... Microsoft Analysis Server 2000 on local ... 'Argument "Number" is not a valid value when we execute the following script: ...
    (microsoft.public.sqlserver.olap)
  • Re: Web service was working, now not working
    ... Are you able to connect to the Analysis Server using the MDX Sample app? ... That would indicate that the database is still accessible. ... Perhaps the full response would ... > see how that would affect the web service though. ...
    (microsoft.public.data.xmlanalysis)

Loading