Hi,

I have an application that uses DSO to build and process cubes on
Analysis Services 2000. I am trying to upgrade it to work with Analysis
Services 2005. I know we need to eventually switch to AMO, but for now
I want to quickly get it working using our existing DSO code.

Although the doc states DSO is backward compatible, when I install SQL
Server 2005 Analysis Services 9.0 OLE DB Provider and SQL Server 2005
Backward Compatibility Components (which includes a 2005-compatible
version of DSO), my code no longer compiles due to some missing
properties on the DSO.DataSource class. Furthermore, when I late bind
to get around the previous problem and try to run the code, it fails at
the DSO.Server.Connect method with "ActiveX component can't create
object at DSO.ServerClass.Connect(String ServerName)".

Does anyone know what I need to do to get my DSO application working
against 2005? Any help would be appreciated.

Thanks,
Chris

Just installing Backward Compatibility Components is not enough for DSO to
connect to AS 2005.

Ideally in addition you should be able to install Management Object redist,
but it looks to be missing some binaries.



For now try installing SQL Management studio and see if you can get your DSO
connect to the Analysis Server 2005.



Edward Melomed.

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



"cneiltx" <c_rneil (AT) yahoo (DOT) com> wrote

The problem I have is that the Backwards Compatibility components contains
DSO 8.0 and not 9.0! How are you supposed to install version 9.0????! I
have spent hours on this and realised finally by running
Debug.Print DSOServer.Version
that the 8.0 version was being reinstalled not 9.0. I simply cannot find
9.0 anywhere, deleting the DSO files and then installing Backwards
Compatability components still leaves me with 8.0. What's going on?!!

"cneiltx" wrote: