The following table provides a list of OLAP Data Provider recipes and their descriptions.
| This recipe... | Explains how to do this... |
|---|---|
| Opening an ADO Connection Object | Open an ADO Connection object. Lists required and optional connection properties for each of the SAS Data Providers. |
| Making Connections by Using the Microsoft Data Link API | Use the Microsoft Data Link API to prompt users for OLE DB connection information at run time and to provide persistent connection information for the SAS Data Providers. |
| Controlling Data Access Permissions with a Connection | Set permissions on your data source. |
| Connecting to a Remote SAS OLAP Server | Connect to a remote SAS OLAP Server using the OLAP Data Provider. Lists the relevant ADO Connection object properties. |
| Reading Multidimensional Data with ADO MD | Read multidimensional data from a SAS OLAP server by using an ADO Connection object to establish a connection and then using the ADO MD Cellset object to execute an MDX query and retrieve the results. |