SQL Server 2000
I am using Active X script to add roles to Analysis Database. I am using the
below code

Dim dsoServer
Set dsoServer = New DSO.Server
dsoServer.Connect "LocalHost"

Dim dsoDatabase

' Create an interface for the database.

' Use the AddNew method of the server's MDStores collection to create the
new database:
Set dsoDatabase = dsoServer.MDStores.AddNew("MyDatabase")

' Create database roles.
Dim DbRole_FinanceMgrs
Dim DbRole_ProductionMgrs
Dim DbRole_SalesMgrs
Set DbRole_FinanceMgrs = dsoDatabase.Roles.AddNew("FinanceManagers")
Set DbRole_ProductionMgrs = dsoDatabase.Roles.AddNew("ProductionManagers")
Set DbRole_SalesMgrs = dsoDatabase.Roles.AddNew("SalesManagers")

' Update the repository for the database roles.
DbRole_FinanceMgrs.Update
DbRole_ProductionMgrs.Update
DbRole_SalesMgrs.Update

Main = DTSTaskExecResult_Success

But when i execute this step, its giving me an error saying "Class not
defined: DSO ".

FRom
http://msdn.microsoft.com/library/de...about_27hh.asp,
I understand that we need Msmdso.rll in C:\Program Files\Common
Files\Microsoft Shared\DSO. But for some wierd reasons I dotn find them in my
computer.

Is this something that gets installed when you install analysis services or
should we do any additional settings for this. Can someone help me here?

Thanks
GS

My bad,

I could locate Msmdso.rll in the location C:\Program Files\Common
Files\Microsoft Shared\DSO\Resources\1033, but still my code is throwing the
error "Class not defined: DSO".

Should I register Msmdso.rll also under shared dll in registry. Are these
dlls installed when Analysis Services is installed?

Pls help

Thanks
GS

"GS" wrote:

I don't think you can register a .rll file, it is simply a resource
file. And these dll's should be installed when you install AS, Analysis
Manager uses these same dlls to manage the AS server.

Have you tried running regsvr32 on the msmddo80.dll file in the C:
\Program Files\Common Files\Microsoft Shared\DSO folder?

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