MS SQL Data Warehousing - Installing DSO ..

Author

Installing DSO ..

Harish Mohanbabu

2005-10-24, 8:23 pm

Hi,

I am in the process of creating/setting up cubes from an ERP application
(Axapta) across user machines. In some of the machines I noticed an error
message (which I believe) indicates DSO objects not being installed.

A quick look at SQL BOI gave me details of DSO library.

My query is - where can I get hold of this DSO library files?

Can someone let me know please. Many thanks in advance,

Harish Mohanbabu
--
MBS Axapta - MVP
http://www.harishm.com/

Darren Gosbell

2005-10-24, 8:23 pm

> My query is - where can I get hold of this DSO library files?

The DSO library is what Analysis Manager uses to build/manage OLAP
Databases. It should be installed when you install the client tools for
Analysis Services 2000. If there is something wrong with the
registration of the dll the default path is C:\Program Files\Common
Files\Microsoft Shared\DSO\msmddo80.dll. But as far as I know there is
no re-distributable version of this library. The users would need to be
OLAP Administrators to use it anyway.

--
Regards
Darren Gosbell [MCSD]
< dgosbell_at_yahoo_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Peter Yang [MSFT]

2005-10-25, 8:23 pm

Hi,

You may try to copy the following files

msmddo.dll
msmddo80.dll
msmdint.dll
msmdnet.dll

You could register these com objects by using regsvr32.exe. for example:

regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DSO\msmddo.dll"

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

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

--------------------
>From: Darren Gosbell <xxx@xxx.com>
>Subject: Re: Installing DSO ..
>Date: Tue, 25 Oct 2005 10:20:56 +1000
>Message-ID: <MPG. 1dc825762779a6059897
6e@news.microsoft.com>
>References: <89CCB5B6-1AE5-4C63-B3D3- 37FA2953C0B3@microso
ft.com>
>MIME-Version: 1.0
>Content-Type: text/plain; charset="iso-8859-15"
>Content-Transfer-Encoding: 7bit
>User-Agent: MicroPlanet-Gravity/2.60.2060
>Newsgroups: microsoft.public.sqlserver.datawarehouse
>NNTP-Posting-Host: cpe-61-9-145-77.vic.bigpond.net.au 61.9.145.77
>Lines: 1
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.datawarehouse:2370
>X-Tomcat-NG: microsoft.public.sqlserver.datawarehouse
>
>
>
>The DSO library is what Analysis Manager uses to build/manage OLAP
>Databases. It should be installed when you install the client tools for
>Analysis Services 2000. If there is something wrong with the
>registration of the dll the default path is C:\Program Files\Common
>Files\Microsoft Shared\DSO\msmddo80.dll. But as far as I know there is
>no re-distributable version of this library. The users would need to be
>OLAP Administrators to use it anyway.
>
>
>--
>Regards
>Darren Gosbell [MCSD]
>< dgosbell_at_yahoo_do
t_com>
>Blog: http://www.geekswithblogs.net/darrengosbell
>

Sponsored Links