OWC Client Machine accessing BSM with SQL05

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.

  1. Make sure you have the latest Services Packs installed
  2. Install MSXML 6.0: click here to download
  3. 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

Later

Patrick

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s