clsServer

An object of ClassType clsServer provides methods and properties that enable you to control an OLAP server. This object is the root of the Decision Support Objects (DSO) object model tree that specifies the databases, cubes, and user roles managed by the server. With an object of ClassType clsServer you can:

• Connect to the computer where the OLAP server service (MSSQLServerOLAPService) is running.
• Start and stop the server.
• Create new objects such as databases and cubes that define multidimensional data structures.
• Manage existing multidimensional data structures.

A clsServer object provides collections, methods, and properties through its own internal interface.

Example

Use the following code to create and initialize a server.

'Create instance of server and connect

Public dsoServer As DSO.Server

Set dsoServer = New DSO.Server

'ServerName is the Windows NT Server where

'the OLAP server is loaded and running.

' An error is raised if we cannot connect

dsoServer.Connect("ServerName")

An alternate method would be as follows.

DsoServer = New DSO.Server

dsoServer.Name = "ServerName"

dsoServer.Connect

Note You can use “LocalHost” to specify the OLAP server running on the same computer as your DSO application.

See Also