通过

Working with Servers

注意注意

  下一版本的 Microsoft SQL Server 将删除该功能。 请不要在新的开发工作中使用该功能，并尽快修改当前还在使用该功能的应用程序。

The example code in this topic shows you how to connect to an Analysis server using Decision Support Objects (DSO) and list some of its property values.

If the Analysis server is not installed on the computer on which you are running this example, change LocalHost to the name of the Microsoft® Windows NT® Server 4.0 or Windows® 2000 computer where the Analysis server is installed and running.

List Servers

The following code example illustrates the use of the DSO.Server object in connecting to and retrieving attributes from an Analysis server. The following code example connects to the local Analysis server using the Connect method of the DSO.Server object, and then it displays some of the basic server properties in the Immediate window:

Private Sub ListServerProps()
    Dim dsoServer As DSO.Server
    Dim enuClassType As DSO.ClassTypes

    ' Create instance of server and connect.
    ' "LocalHost" will default to the
    ' local Windows NT Server 4.0 where the
    ' Analysis server is installed.
    Set dsoServer = New DSO.Server
    dsoServer.Connect "LocalHost"

    ' Show the server's information to the user.
    If dsoServer.ClassType = clsServer Then
        Debug.Print "Server Properties:"
        Debug.Print "       Name: " & dsoServer.Name
        Debug.Print "Description: " & dsoServer.Description
    End If

End Sub