Current filter:
                                You should refresh the page.
                                Support Center
                                0
                                  • We have deployed a Windows App using XtraPivotGrid v9.2.8 to a customer's machine.
                                    The customer is able to connect to the database server using the command prompt; however, when they try to load data to the XtraPivotGrid, the following exception appears:

                                    See the end of this message for details on invoking
                                    just-in-time (JIT) debugging instead of this dialog box.

                                    ************** Exception Text **************
                                    DevExpress.XtraPivotGrid.Data.OLAPConnectionException: Couldn't connect to the Analysis Services. ---> System.Data.OleDb.OleDbException: Not Found
                                       at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
                                       at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
                                       at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
                                       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
                                       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
                                       at System.Data.OleDb.OleDbConnection.Open()
                                       at DevExpress.XtraPivotGrid.Data.PivotGridOLAPDataSource.ConnectCore()
                                       --- End of inner exception stack trace ---
                                       at DevExpress.XtraPivotGrid.Data.PivotGridOLAPDataSource.ConnectCore()
                                       at DevExpress.XtraPivotGrid.Data.PivotGridOLAPDataSource.Connect(Boolean forced)
                                       at DevExpress.XtraPivotGrid.Data.PivotGridOLAPDataSource.PopulateColumns()
                                       at DevExpress.XtraPivotGrid.Data.PivotGridOLAPDataSource.DoRefreshCore(PivotGridFieldReadOnlyCollection sortedFields)

                                    In our installation package, we are including the following dll's: DevExpress.XtraPivotGrid.v9.2.dll, DevExpress.XtraPivotGrid.v9.2.Core.dll, Microsoft.AnalysisServices.DLL, Microsoft.AnalysisServices.AdomdClient.dll. Are there any other dlls that need to be included in order to make the oledb connection?

                                    Steps to Reproduce:

                                    The code that throws the errors on the customer's machine is as follows. The connection failes when Globals.IsAccessServiceRemotely is true or false, but we are able to ping the Analysis Server through HTTP and through the server host name:

                                                string connStr = Program.CubeOLAPConnectionStringByCubeName;

                                                connStr = connStr.Replace("@@CubeName", this.lookUpEditCubes.Text.Trim());

                                                connStr = connStr.Replace("@@DatabaseName", CPCALib.pcaString(this.lookUpEditCubes.GetColumnValue("AnalysisServerDatabaseName")));

                                                if (!Globals.IsAccessServiceRemotely)

                                                {

                                                    connStr = "Provider=msolap;Data Source=[servername]\\sql2008;Initial Catalog=" + CPCALib.pcaString(this.lookUpEditCubes.GetColumnValue("AnalysisServerDatabaseName")) + ";Cube Name=" + this.lookUpEditCubes.Text.Trim() + ";";

                                                }

                                                this.pivotGridControl.OLAPConnectionString = connStr;

                                                this.pivotGridControl.BeginUpdate();

                                    Actual Results:

                                    "Couldn't connect to the Analysis Services" exception.

                                    Expected Results:

                                    Pivot Grid should populate with data from the Analysis Services cube.

                                0

                                Hi David,

                                Thank you for the report. This is not a bug in the XtraPivotGrid. The problem appears because the OleDBConnection cannot be opened. If you create a simple sample project which does not contain the XtraPivotGrid, pass the same connection string to the OleDBcommand and call its Open method, the same exception will be raised.

                                We will think over this issue and let you know if we determine why this problem might appear. Also, the exception text is strange, it looks like something is missing here:

                                System.Data.OleDb.OleDbException: Not Found ... ???

                                Could you please recheck this and let us know if the exception text contains some valuable information?

                                Thanks,
                                Plato

                                0

                                Hi David,

                                We have an idea. Please try to install OleDb Provider for Analysis Services 10.0 (2008 server) on the client. It is available at:

                                http://www.microsoft.com/downloads/details.aspx?FamilyId=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en

                                Does this help?

                                Thanks,
                                Plato

                                0

                                Yes, installing OleDb Provider for Analysis Services 10.0 solved the problem on our test machine; we are waiting word from the customer that this fixes the issue.

                                It may be worth mentioning this in the "Deployment" section of the XtraPivotGrid documentation, or possibly building this into the redistributable package.

                                Thanks,

                                - David

                                0

                                Yes, installing OleDb Provider for Analysis Services 10.0 solved the problem on our test machine; we are waiting word from the customer that this fixes the issue.

                                It may be worth mentioning this in the "Deployment" section of the XtraPivotGrid documentation, or possibly building this into the redistributable package.

                                Thanks,

                                - David

                                0

                                Hello David,

                                I'm glad to hear that the problem is resolved.

                                I've created a separate request on documentation: Documentation - Add a note that XtraPivotGrid requires an OleDb provider for Analysis Services on a client machine

                                Thanks,
                                Ivan

                                To start a chat you should create a support ticket


                                If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

                                FOLLOW US

                                DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, Silverlight, ASP.NET, WinForms, HTML5 or Windows 8, DevExpress tools help you build and deliver your best in the shortest time possible.

                                Copyright © 1998-2014 Developer Express Inc.
                                All trademarks or registered trademarks are property of their respective owners