DM Windows Forms Controls in November Feature Pack for SS2005

Hello,

There is a download in the Feature Pack For Microsoft SQL Server 2005 - November 2005 for the Microsoft SQL Server 2005 Datamining Viewer Controls. Unfortunately I cannot find a shred of documentation for said controls. It would be nice to know what their names are, where they are installed, how you add them to your toolbox. Sample apps would be of great benefit as well (but I don't want to ask for too much).

Here is the description for the controls which I find somewhat confusing. Are they Web Controls or Windows Forms Controls?

The Data Mining Web Controls Library is a set of Microsoft Windows Forms controls that enable software developers to display data mining models created using Microsoft SQL Server 2005 Analysis Services in their client-side applications.

Wendell G.

I agree that documentation would be useful. In the meantime, this sample that demonstrates how to embed the viewer controls (which *are* Winform controls and not web controls, as the description mistakenly indicates) might help:

http://www.sqlserverdatamining.com/DMCommunity/Downloads/Links_LinkRedirector.aspx?id=1362

|||

Wow Raman, this is incredible! Thank you so much.

It appears these controls are the controls that the Business Intelligence Developer's Studio is built with. Does anyone know if these controls are redistributable? I am especially interested in the Microsoft.AnalysisServices.Controls, Microsoft.AnalysisServices.Graphing, and Microsoft.AnalysisServices.Viewers.

Do the controls require Analysis Services to be installed on the deployed workstation?

If Microsoft does not have these documented, is anyone writing a developer's book that explains how to use them?

Thanks again!

Wendell G

|||

Yup, these are the viewer controls hosted in BI Dev Studio and SQL Mgmt Studio and they *are* redistributable. The controls don't require an AS install on the workstation - they only require a subset of client components (just the AS 9.0 OLE DB driver, I believe - the install should pop up the appropriate prerequisites if they are missing).

We are hoping to provide documentation in a web refresh but I don't have a timeframe yet.

DISTRIBUTED TRANSACTION

Hi,
I have two sql servers with SQL2000 service pack 3 which are linked by the "
Link Server". When i use the "begin tran" (distributed transaction) in store
d procedure, i am getting the following error.
"Server: Msg 8525, Level 16, State 1, Line 1
Distributed transaction completed. Either enlist this session in a new trans
action or the NULL transaction. "
The following article talks about this problem.
http://support.microsoft.com/?kbid=834849
But, both servers are SQL 2000 in my case. Any help?
Thanks,
VijayHi, i'm going this trouble but the versions are different. Server A has Sql
server 2000 enterprise edition and the server B has Sql Server 7.0, both
servers are linked properly and running msdtc. No changes were made to their
configurations. If I run the sentence with Begin distributed tran and commin
distributed tran it end right but using that statement it fails with the
error commented is this post.
Any ideas?
"Vijay" wrote:

> Hi,
>
> I have two sql servers with SQL2000 service pack 3 which are linked by the
"Link Server". When i use the "begin tran" (distributed transaction) in sto
red procedure, i am getting the following error.
>
> "Server: Msg 8525, Level 16, State 1, Line 1
> Distributed transaction completed. Either enlist this session in a new tra
nsaction or the NULL transaction. "
>
> The following article talks about this problem.
> http://support.microsoft.com/?kbid=834849
> But, both servers are SQL 2000 in my case. Any help?
>
> Thanks,
> Vijay
>
>