多维数据集无法使用azure分析服务的连接字符串进行访问 [英] Cube cannot access with connection string of an azure analysis services

问题描述

我们正在尝试将来自云（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 ID=[e-mail];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 ?

推荐答案

您好Scintilla A，

Hi Scintilla A,

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

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分析服务的连接字符串进行访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！