Wednesday, March 7, 2012

Microsoft.AnalysisServices.Viewers.DLL Microsoft SQL Server 2005 Datamining Viewer Controls

Hi

I am trying to use Association Viewer Control in

Microsoft.AnalysisServices.Viewers.DLL dll in VS 2005 but sometimes it gives an error.

"Code generatio for property 'ConnecitonManager'" failed. Error was:'Property accesor 'ConnectionManager' on object 'AssosiactionViewer1' threw the following exception:'Object referance not set to instance of an object"


Is there anyone here who use
"Microsoft SQL Server 2005 Datamining Viewer Controls" in SQLServer2005 FeaturePack ?
http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en

i am using VS2005 Version 8.0.50727.762 (SP.050727-7600)
and SQL Server 2005 SP2

thanks from now.

Cem üney

Thanks for reporting this issue. We are trying to reproduce this problem and will provide an update soon.|||

Thank you very much for your reply.

i hope you can see the same problem.

|||

Cem,

It would be very helpful if you could tell us a little bit more about your problem. Have you found any particular conditions when you hit the error? Are you getting the error when creating the viewer? or after? What are you doing before invoking the viewer? This will save us a lot guessing and we will be able to find the problem and work a solution earlier.

Thanks,

Fernando Godinez, SQL Server Data Mining

|||

ok sir,

i am sending you the pictures that shows my problem. thanks for your interest.

viewer1.jpg

http://img517.imageshack.us/my.php?image=viewer1sz6.jpg

i just open new VBProject.

viewer2.jpg

http://img478.imageshack.us/img478/4223/viewer2jp1.jpg

i add the Microsoft.AnalysisServices.Viewers.dll controls to ToolBox

viewer3.jpg

http://img504.imageshack.us/img504/2976/viewer3qd4.jpg

i just drag and drop the AssociationViewer control to my empty form. When i click properties after 2-3 seconds, it gives me the error at the image.

viewer4.jpg

http://img504.imageshack.us/img504/7746/viewer4ho7.jpg

Connection Manager error and my referances. Maybe i have to some more references but which one?

viewer5.jpg

http://img504.imageshack.us/img504/9749/viewer5if8.jpg

When i close the project and open it again i saw this message Sad

All pictures are here

http://rapidshare.com/files/38900865/viewer.rar.html

|||

Cem,

I was able to reproduce the error and we will work on it. In the meantime here is what you need to do to get you application running:

1. Create a form with a Panel on it.

2. From the code part you will have to create a new AssociatonViewer

3. Set the ConnectionString property for you association viewer manually

4. Set the mining model name that you want to view

5. Add the viewer to the panel controls collection

6. Call the LoadViewerData method from the viewer (context parameter can be null).

* Note: You connection string must have the form "Provider=MSOLAP.3;Data Source= your server name;Initial Catalog=your catalog". Where you must provide your server name and your catalog name.

You can see an implementation on the use of the controls in http://www.sqlserverdatamining.com/dmcommunity/_downloads/1361.aspx

All the code in that sample is in C# but I'm sure you can get the grasp without much trouble.

Hope this helped,

Fernando

|||

ok fernando,

i know the example before, and i adapted it to VB.

control does not give error when its created at runtime.

thanks for your interest again.

Cem üney

No comments:

Post a Comment