Can OWC and ASP.NET be used to connect to an OLAP cube running on SQL Server 2005 ?

Hello, I'm from Romania and I have a small problem. I recently found on MSDN an articol and an ASP.NET project showing how to browse an OLAP cube from a web page, using OWC controls. The cube was built using Analysis Services for SQL Server 2000.

My question is can the same be done with a cube running on SQL Server 2005 (browse it from ASP.NET page using OWC) ? If so, can anyone please give a link to an tutorial or sample project ?
Or if not, please offer a solution on how to browse an OLAP cube from SQL Server
2005 from ASP.NET.

Thanks.

For the client application using OWC all you need to do is to install new version of the AS OLEDB provider. OWC can work with both AS200 and AS2005. Same goes for Excel and all major Analysis Services clients.

You can install "Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider " from http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi. It's me again, I have downloaded and installed all necessary stuff, and project runs seems to run fine, but the Office Web Control says it cannot find the object specified by me.

Here's the OLAPconnection string :

value="Provider=MSOLAP.2;Data Source=http://localhost/elena;Initial Catalog=Aplicatie LogyCars;"

Here is the block of code where i attempt to connect ;

Try

Dim objPT As PivotTableClass = New PivotTableClass

objPT.ConnectionString = strOLAPConn

'strDataMember = "CubLogyCar"

strDataMember = "Cub LogyCar"

objPT.DataMember = strDataMember

m_XML = objPT.XMLData

objPT = Nothing

Catch err As Exception

m_XML = "<err>" & err.Source & " - " & err.Message & "</err>"

Finally

End Try

Return (m_XML)

End Function

There's no error, but still does not connect. "Cub LogyCar" is the name of the OLAP cube buuilt inside the Aplicatie LogyCars solution. Both of them are correctly written in code and web.config file.

Any Suggestions ?

|||For Analysis Service 2005, the provider should be MSOLAP.3