多维数据集无法使用azure分析服务的连接字符串进行访问

问题描述

我们正在尝试将来自云（Azure分析服务）的多维数据集与ADOMD.Net连接，但是我们遇到了连接字符串的问题，该字符串是从azure分析服务。

We are trying to connect the cube from cloud (Azure analysis service) with ADOMD.Net, but we have encountered a problem with connection string which is generated from the azure analysis services.

我们的ADOMD.Net连接代码如下，

 static void Main(string[] args)
        {
            string connection = "Provider=MSOLAP;Data Source=asazure://southeastasia.asazure.windows.net/azuresql;Initial Catalog=adventureworks;User [email protected];Password=******;Persist Security Info=True;Impersonation Level=Impersonate";
            {
                MASAC.AdomdConnection adomdConnectionObjMain = new MASAC.AdomdConnection(connection);
                adomdConnectionObjMain.Open();
                if (adomdConnectionObjMain.Cubes.Count > 0) {
                        Console.Write("connection works");
                }
            }

        }

打开连接时，我们遇到了以下问题，

While opening the connection, we have faced the following issue,

Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException
  HResult=0x80131500
  Message=The connection string is not valid.
  Source=Microsoft.AnalysisServices.AdomdClient
  StackTrace:
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetInstancePort(ConnectionInfo connectionInfo)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
   at cubeConnection.Program.Main(String[] args) in D:\Cube_file\cubeConnection\cubeConnection\Program.cs:line 22

Inner Exception 1:
FormatException: Input string was not in a correct format.

当我们与ADOMD.Net连接时，是否还需要其他连接字符串格式？

Is there any other connection string format is needed to follow when we connect with ADOMD.Net ?

推荐答案

您可能会收到此错误消息"连接字符串无效"，未安装客户端库时。

You may receive this error message "The connection string is not valid", when the client libraries are not installed.

确保已安装
用于连接Azure Analysis Services的客户端库。

有关更多详细信息，请参阅" Azure Analysis Services连接错误 - 连接字符串无效"。

For more details, refer "Azure Analysis Services connection error - The connection string is not valid".

希望这会有所帮助。

这篇关于多维数据集无法使用azure分析服务的连接字符串进行访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！