Connect (clsServer)
Note
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
The Connect method of an object of ClassType clsServer connects to the Analysis server service (MSSQLServerOLAPService).
Syntax
dsoServer.Connect([ByVal ServerName As String])
Parameters
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