If you are like me, you do all of your development on your computer. Today we decided to finally test some client machines accessing the server and found that none of the OWC ReportViews were rendering. The Scorecards were rendering just fine.
Because we are using SQL Server 2005 and Analysis Service 2005 on the Server, we had Analysis Service OLEDB 9.0 as our driver for the OWC views. Well, on the clients, that did not exist and broke the views. Only took us 5 hours to figure it out. What a waste.
Anyway, you need to download and install the following on your client machines to use OWC against SQL Server and Analysis Services 2005.
- Make sure you have the latest Services Packs installed
- Install MSXML 6.0: click here to download
- Install AS OLEDB 9.0: click here to download
Once you install all that, those OWC ReportViews should render just fine. The question is, how do you push out those installs to several hundred clients. :o)
Hope that helps