OWC 9 to OWC 11 due to killbits conversion problem

[CodeGeek]

So I'm somewhat struggling with converting (may not be the best term) an
existing asp page that utilizes OWC 9 components to use OWC 11 components due
to our company finally installing the killbit patches for version 9. It
appears that perhaps MS will release an update to OWC 11 so that the security
issue will no longer be there, so we are hoping that we can convert to OWC 11
and not have to implement MOSS + Excel Services to provide pivot tables...

Anyway, when I try updating the components on the server in question, and
modify the asp page to use the correct class ids, it seems that it's having
an issue connecting to our cube. I've checked and rechecked the connection
string for MSOLAP.2 and it's as expected (works fine within Excel, works fine
when I create a windows form app) but for some reason, it just will not work
in this current asp page.

Any thoughts or suggestions???

 

[CodeGeek]

Since no one was willing to provide some insight, I went through and figured
it out.
It had nothing to do with the connection string at all, but some of the
legacy code that was in place to handle loading previously saved xml to the
pivot table.