Connect (clsServer)

Analysis Services Programming

Analysis Services Programming

Connect (clsServer)

The Connect method of an object of ClassType clsServer connects to the Analysis server service (MSSQLServerOLAPService).

Syntax

dsoServer.Connect([ByVal ServerName As String])

dsoServer

A Decision Support Objects (DSO) server object.

ServerName

The name of the computer on which the Analysis server is installed and running. You can use LocalHost to specify the Analysis server running on the same computer as your DSO application.

Remarks

The Connect method sets the name of the server object. If you need to reconnect to the same server, do not specify the name on subsequent executions of the method on the same object.

Important  You cannot use an Internet Protocol (IP) address as the ServerName parameter to connect to a server. You must use the network name of the computer that hosts the Analysis server.

Example

Use the following code example to connect to the Analysis server:

Public dsoServer As DSO.Server
Set dsoServer = New DSO.Server
'Assume "Server1" to be the name of the computer
'where the Analysis server service is installed and running.
dsoServer.Connect "Server1"  'Error is raised if unable to connect

See Also

clsServer