Building Intelligent applications using SQL Server 2005 Data Mining

Hello,

Are there any samples on Building Intelligent applications using SQL Server 2005 Data Mining uisng Visual Basic.NET, including step-by-step guides? Most of them are in C#. Besides, the June 2005 CTP does not have tutorials on the said topic.

Thanks.We don't have sample code specifically in VB.NET but the object models are exactly the same in all .NET languages so the code should be readily portable. If you encounter any specific issues moving the sample code to VB.NET, we will be happy to help.

In case you missed the sample code (C#) from the recent programmability webcast, it can be found here: http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/1313.aspx

Raman Iyer
SQL Server Data Mining|||Thanks for this as I already have seen this. I sure hope I can work on this but I don't have the sample database named DataValidationModels. Can you post the database as well?

Thanks a lot|||You can download the DataValidation.zip files from SQLServerDataMining.com which contains instructions on how to create the model.|||I want to write DMX queries on the AdventureWorks database specified in the data mining tutorial(from June 2005 CTP) using ADOMD.NET. What are the available mining models in the sample database and do you have sample queries?

Thanks.|||The tutorial can be used to build mining models based on the AdventureWorks database for targeted mailing (using the decision trees, clustering & naive-bayes algorithms), forecasting using time series, market basket analysis (using association rules) and sequence clustering.

For DM programmability using ADOMD.NET (as well as other programming models), please see this article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqldmprgrm.asp. It includes sample code and queries.|||I want to use AMO in my application. One documentation specifically mentions to add a reference to the Microsoft.AnalysisServices assembly in the .NET framework 2.0 but this does not appear in the References list in VS.NET 2005. I am using VS.NET 2005 Beta 2 with .NET Framework version 2.0.50215 with June CTP of SQL Server 2005. What could I use instead?|||

If it doen't show up in the list, you can browse to this location and add Microsoft.AnalysisServices.DLL manually (go to the Browse tab in the Add Reference dialog:
\Program Files\Microsoft SQL Server\90\SDK\Assemblies\

|||

I have a question on connection string in ADOMD.NET when using the AdomdConnection object. Can you use other authentication methods other that Windows to connect to Analysis Services and access the mining models?