Why does browsing cube data on the intranet need client side components

Hot Topic

system error 126
Stored Procedure - Insert with table name from parameter
How to send the SQL Reports via email.
SQL Server 2000 / 2005 :: page allocation after reIndexing
SSIS File Validation
Can't get IntegratedSecurity with JDBC driver
Execute SQL Task not running?
Login failed for user 'TEST\administrator'. [CLIENT: <local machine>]
SQL Server next generation product family
sp_executesql - Error converting data type varchar to datetime

SQL Server

OpenQuery() to Linked Server hangs, leaving SPID with open tran, then templog.ldf grows without limit.
Vista install help..
Excel Destination data transfered changes format after 1st run
Identify users and processes
Sum issue on table footers
Full-text catalog '' has been lost
Automatic log decresing space used size in AdventureWorks
multiple tables
trigger- get row number from inserted/deleted
ssis - process xml files

Why does browsing cube data on the intranet need client side components

Hi guys.

I have a simple web component on top of my cube which I made available on the intranet. The problem is that no one can see the data, it comes back with a "The query could not be processed, The data provider didn't supply any further error information". If I install the XML 6 parser and the SQLServer2005_ASOLEDB9 from the microsoft feature pack on the client machines then they can view the data fine. My question is, is there a way to not have to install anything client side. Have I missed a tick box somewhere

Thanks in advance guys.

Answer this question

Why does browsing cube data on the intranet need client side components

  • Vinodonly

    Dear all,

    I have the same problem. I want to use data analysis in project web Access (ms prject 2007 server).

    The first problem appears is "The query could not be processed, cannot connect to the server 'XXXXXXXX'. The server is either not started or too busy"

    Then i tried to install XML 6 parser and the SQLServer2005_ASOLEDB9, open the firewall from port that used by analysis service (2725)

    but the second problem appears "The query could not be processed, The data provider didn't supply any further error information".

    Is there any suggestion

    Thank you.

  • Joshizzle

    Sounds like your web component is doing a client side connect, so it obviously has to have the database drivers.

    To avoid client side installations, you'd need a server side (IIS process) to connect to the cube and render the results to the client. Depending on your requirement, that's not necessarily a trivial task.

    I'd strongly recommend looking at one or more of the following:

    MS Reporting Services 2005 - Included with SQL Server 2005. Great for prepared reports. Easy to use & deploy. Not so great for ad-hoc.

    ProClarity (now owned by Microsoft) - Great ad-hoc tool. Difficult to create a polished tool for prepared reports.

    Dundas OLAP Controls - Really nice rendering components. For developers. Client side access.

    Good luck.



  • SOTY_Programmer

    Mosha has a list here http://www.mosha.com/msolap/util.htm on his site of client tools for Analysis Services, have a look under the section labelled "Thin Clients". I am guessing you are using the OWC controls which is an ActiveX control and even though it is deployed in a web page, it executes on the client, hence the clients need for the drivers

  • Why does browsing cube data on the intranet need client side components
Answer this question