Skip to content

Latest commit

 

History

History
49 lines (41 loc) · 2.6 KB

File metadata and controls

49 lines (41 loc) · 2.6 KB
title Open Method (ADO MD) | Microsoft Docs
ms.prod sql
ms.prod_service connectivity
ms.technology connectivity
ms.custom
ms.date 01/19/2017
ms.reviewer
ms.topic conceptual
apitype COM
f1_keywords
Open
Cellset::Open
helpviewer_keywords
Open method [ADO MD]
ms.assetid a87d8080-a238-45e5-bc80-9a8625b3810f
author MightyPen
ms.author genemi

Open Method (ADO MD)

Retrieves the results of a multidimensional query and returns the results to a Cellset.

Syntax

  
Cellset.Open Source, ActiveConnection  

Parameters

Source
Optional. A Variant that evaluates to a valid multidimensional query, such as a Multidimensional Expression (MDX) query. The Source argument corresponds to the Source property. For more information about MDX, see the OLE DB for Online Analytical Processing (OLAP) documentation in the Microsoft Data Access Components SDK.

ActiveConnection
Optional. A Variant that evaluates to a string specifying either a valid ADO Connection object variable name or a definition for a connection. The ActiveConnection argument specifies the connection in which to open the Cellset object. If you pass a connection definition for this argument, ADO opens a new connection using the specified parameters. The ActiveConnection argument corresponds to the ActiveConnection property.

Remarks

The Open method generates an error if either of its parameters is omitted and its corresponding property value has not been set prior to attempting to open the Cellset.

Applies To

Cellset Object (ADO MD)

See Also

Cellset Example (VB)
ActiveConnection Property (ADO MD)
Close Method (ADO MD)
Connection Object (ADO)
Source Property (ADO MD)
State Property (ADO MD)