Plug-in algorithm documentation and sample code

I've read in at least one book (and heard firsthand at the SQL Server launch event) that there's a plug-in framework for adding new algorithms to Data Mining. However, the book was apparently written against a Beta version, and the location it suggests for the plug-in sample code doesn't exist in the shipping version. I haven't been able to locate any documentation about the plug-in framework in the SQL Server Books Online, and I haven't been able to find any sample code, either.

Can someone give me a few pointers?Did you explicitly install the SQL Server Samples? You have to choose advanced options during setup to get them - they are not installed by default. If not, go to add/remove programs to run the installer again to add the samples to your installation.|||

You can also find the plug-in algorithm tutorial (with complete source code for a sample) here: http://www.sqlserverdatamining.com/DMCommunity/Tutorials/Links_LinkRedirector.aspx?id=62

The plug-in algorithm whitepaper is available here:
http://www.sqlserverdatamining.com/DMCommunity/Whitepapers+and+Articles/Whitepapers/Links_LinkRedirector.aspx?id=64

Raman Iyer
SQL Server Data Mining

|||Yes, I did install the samples. In fact, I tried on two different installations of SQL Server -- one in which I'd installed the samples with the original installation, and one in which I installed them after-the-fact. In neither case could I find any of the plug-in samples.|||Thank you very much!|||

Hi,

This site is very good but I need to ask aquistion.

Can I use the C# language instead of VC++ in order to create the new mining algorithm.

Is there any example?

Thanks in advance for any help,

Aya.

|||We are working on a framework/SDK for developing plug-in algorithms using managed code. We hope to make it available for download, along with sample code, in the next month or so.

Plug-in algorithm documentation and sample code

I've read in at least one book (and heard firsthand at the SQL Server launch event) that there's a plug-in framework for adding new algorithms to Data Mining. However, the book was apparently written against a Beta version, and the location it suggests for the plug-in sample code doesn't exist in the shipping version. I haven't been able to locate any documentation about the plug-in framework in the SQL Server Books Online, and I haven't been able to find any sample code, either.

Can someone give me a few pointers?Did you explicitly install the SQL Server Samples? You have to choose advanced options during setup to get them - they are not installed by default. If not, go to add/remove programs to run the installer again to add the samples to your installation.|||

You can also find the plug-in algorithm tutorial (with complete source code for a sample) here: http://www.sqlserverdatamining.com/DMCommunity/Tutorials/Links_LinkRedirector.aspx?id=62

The plug-in algorithm whitepaper is available here:
http://www.sqlserverdatamining.com/DMCommunity/Whitepapers+and+Articles/Whitepapers/Links_LinkRedirector.aspx?id=64

Raman Iyer
SQL Server Data Mining

|||Yes, I did install the samples. In fact, I tried on two different installations of SQL Server -- one in which I'd installed the samples with the original installation, and one in which I installed them after-the-fact. In neither case could I find any of the plug-in samples.|||Thank you very much!|||

Hi,

This site is very good but I need to ask aquistion.

Can I use the C# language instead of VC++ in order to create the new mining algorithm.

Is there any example?

Thanks in advance for any help,

Aya.

|||We are working on a framework/SDK for developing plug-in algorithms using managed code. We hope to make it available for download, along with sample code, in the next month or so.

Please tell me why @@Error is not picking up the error

in this procedure the Gender column is a bit datatype. as you can see i'am adding a string.

when i exec proc my error message "print 'error'" is not showing. please help.

you can email at cbmorton!at!gmail.com

CREATE PROCEDURE [dbo].[sp_newuserregistration] AS
BEGIN TRAN
INSERT INTO UserLoginInfo (UserName,[Password]) values ('?','?')
SELECT @.@.IDENTITY AS 'Identity'
DECLARE @.UserID AS INT
SET @.UserID = @.@.Identity
INSERT INTO UserAccountInfo (UserID, Email) VALUES (@.UserID, '?')
INSERT INTO UserProfileInfo (UserID, FirstName, LastName, Gender, DateOfBirth) VALUES (@.UserID, '?', '?', 'x', null)
IF @.@.ERROR <> 0
BEGIN
PRINT 'error'

ROLLBACK TRAN
END
ELSE
BEGIN
COMMIT TRAN
END

GO

--EXEC sp_newuserregistration

The batch stops executing on the error and you can not catch it. You will need to use try/catch but it is only available in SQL Server 2005.|||? As Andreas mentioned, this is a batch-aborting exception -- for this reason, I usually like to use SET XACT_ABORT in my stored procedures that use transactions. Setting that option to ON will cause the transaction to automatically roll back in case of an exception. You might want to read the following articles for more background on all of this: http://www.sommarskog.se/error-handling-I.html http://www.sommarskog.se/error-handling-II.html -- Adam MachanicPro SQL Server 2005, available nowhttp://www..apress.com/book/bookDisplay.html?bID=457-- <codrakon@.discussions.microsoft.com> wrote in message news:2db52d22-6890-435c-92c1-e794a3077677@.discussions.microsoft.com... in this procedure the Gender column is a bit datatype. as you can see i'am adding a string. when i exec proc my error message "print 'error'" is not showing. please help. you can email at cbmorton!at!gmail.com CREATE PROCEDURE [dbo].[sp_newuserregistration] ASBEGIN TRANINSERT INTO UserLoginInfo (UserName,[Password]) values ('?','?')SELECT @.@.IDENTITY AS 'Identity'DECLARE @.UserID AS INTSET @.UserID = @.@.Identity INSERT INTO UserAccountInfo (UserID, Email) VALUES (@.UserID, '?')INSERT INTO UserProfileInfo (UserID, FirstName, LastName, Gender, DateOfBirth) VALUES (@.UserID, '?', '?', 'x', null)IF @.@.ERROR <> 0BEGINPRINT 'error' ROLLBACK TRANENDELSEBEGINCOMMIT TRANEND GO --EXEC sp_newuserregistration