Jaa


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

See Also

Reference

clsServer

Help and Information

Getting SQL Server 2005 Assistance