Microsoft OLE DB Provider for OLAP

This OLE DB Provider is provided by Microsoft.

Include "Provider=MSOLAP" in the connection string to use this provider.


  If you have more then one OLEDB for OLAP provider installed you may need to specify the version of the provider in the connection string, 
  MSOLAP.1 for MSAS 7.0
  MSOLAP.2 for MSAS 2000
  MSOLAP.3 for MSAS 2005
  MSOLAP.4 for MSAS 2008
  Just specifying MSOLAP should use the latest version of OLE DB for OLAP installed.


There is no 'Microsoft OLE DB Provider for OLAP' installation package to download. (if you know about an installation package URL you can contribute to the community by submitting the info to us through this message form)

Connection Strings

The Microsoft OLE DB Provider for OLAP provider can be used to connect to the following data sources by using the following connection string references:

OLAP, Analysis Services