OLAP Exception

[leszek]

 Using visual Studio 2005

1. I drop chart on winForm

2. Add Extensions (selcted OLAP)

3. from "chose OLAP data source" I selected existing cube

4. selected first radio button (I want Chart FX OLAP to help...)

5.  selected two dimensions and one measure

I try to run and receive exception:

System.InvalidOperationException was unhandled

  Message="An error occurred creating the form. See Exception.InnerException for details.  The error is: Provider cannot be found. It may not be properly installed."

  Source="olap1"

  StackTrace:

at olap1.My.MyProject.MyForms.Create__Instance__[T](T Instance) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 190

at olap1.My.MyProject.MyForms.get_Form1()

at olap1.My.MyApplication.OnCreateMainForm() in \\ahla.com\AHLEI\Users\lmlynarczyk\Documents\Visual Studio 2005\Projects\olap1\olap1\My Project\Application.Designer.vb:line 35

at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()

at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()

at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)

at olap1.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81

at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)

at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()

at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

at System.Threading.ThreadHelper.ThreadStart()

 

what I am missing?

 

 

[Frank]

Do you have the OLEDB provider for OLAP installed?

The error says "Provider cannot be found. It may not be properly installed".

Can you connnect to OLAP dataSources otherwise (othern than using Chart FX).

If your computer is 64-Bit will need both 32-Bit and 64-Bit version of this provider.

[leszek]

 yes, it is 64-bit PC running on Windows7

I can view cube from excel pivot table on my PC.

 

[leszek]

I created another test

When I insert chart on the form selected add extension check OLAP box and run no error.

when I select choose OLAP Data Source I can select my cube see olap2 jpg

after selecting dimensions and measure when running I have same exception 

[leszek]

I downloaded and installed

Microsoft ADOMD.NET

Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

Microsoft SQL Server 2005 Datamining Viewer Controls

from http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en

and now program is running fine.

 

Thank You

Leszek