Standard using MSOLAP
Connection string
This Microsoft OLE DB Provider for OLAP connection string can be used for connections to OLAP, Analysis Services.
Provider=MSOLAP;Data Source=myServerAddress;Initial Catalog=myDataBase;
This Microsoft OLE DB Provider for OLAP connection string can be used for connections to OLAP, Analysis Services.
Provider=MSOLAP;Data Source=myServerAddress;Initial Catalog=myDataBase;
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 as Provider uses the latest version of OLE DB for OLAP installed on the system.