How to check the MSOLAP Provider used in connection string

最新推荐文章于 2021-02-19 01:55:06 发布

wantfly2006

最新推荐文章于 2021-02-19 01:55:06 发布

阅读量5.7k

点赞数

分类专栏： BI(Analysis Service) 文章标签： string service compression authentication microsoft security

本文链接：https://blog.csdn.net/wantfly2006/article/details/715823

版权

BI(Analysis Service) 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

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