In the Microsoft Analysis Service, when we try to connect to analysis service, we generally will use connection string as below:
Provider=MSOLAP.3;Cache Authentication=False;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Adventure Works DW;Data Source=Michael02;Impersonation Level=Impersonate;Mode=ReadWrite;Auto Synch Period=20000;Default Isolation Mode=0;Default MDX Visual Mode=0;MDX Compatibility=0;MDX Unique Name Style=0;Non Empty Threshold=0;SQLQueryMode=Calculated;Safety Options=1;Secured Cell Value=0;SQL Compatibility=0;Compression Level=0;Real Time Olap=False;Packet Size=4096
Provider property indicates the provider that the connection uses to connect analysis service, whose possible value is MSOLAP/MSOLAP.1/MSOLAP.2/MSOLAP.3. So we have
MSOLAP ---Default Provider
MSOLAP.1 ---OLAP 7.0 Provider (msolap.dll)
MSOLAP.1 ---Analysis Service 2000 Provider (msolap80.dll)
MSOLAP.1 ---SSAS provider (msolap90.dll)
When MSOLAP is set for the Provider property in the connection string, the default OLAP provider will be used. We need to check the default OLAP Provider in registry. When we install the AS2000 client files do we create a key called HKCR/MSOLAP.2 and will AS2000 be the default client file when msolap is used in the connection string. when we install the client files of AS2005 do we create the HKCR/MSOLAP.3 registry key and will this be the default there it copies his CLSID to the HKCR/MSOLAP registry key during registration. HKCR/MSOLAP is the default when there is no number mentioned in the connection string, so we have:
HKCR/MSOLAP ---is the default and used when MSOLAP is selected in the connection string, the file msolap.dll, msolap80.dll or msolap90.dll that is latest registered will be the default.
HKCR/MSOLAP.1 ---is the registry key for OLAP version 7, file msolap.dll
HKCR/MSOLAP.2 ---is the registry key for AS2000, file msolap80.dll
HKCR/MSOLAP.3 ---is the registry key for AS2005, file msolap90.dll
Thanks and regards,
Michael