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?

Building a report

I have been "Thrown to the wolves" and need to learn Visual Studio and Reporting Services thru the scholl of hard knocks. I have had about 5 years a self teaching on Microsoft Access and 2 months of SQL Server. Not by any means a pro but I'm learning.

I put my SQL in the Data tab. I go to layout. I have made a couple of reports using the table and subreport in the toolbox. However when I try to drag and drop the fields into the body without a table all that previews is the first field.

When I drop the field in the body it comes out=First(Fields!fldname.Value) or=Sum(Fields!fldname2.Value)

I'd like to get this a continuous report(form). I hope I'm explaining this well enough. I'm going top Barnes and Noble today to get a book but in the meantime does anyone understand what I'm looking for?

I tried finding it on BOL but it didn't help me that much.

Hi

you can also use List to place labels inside. List is similar to Table(Grid) as you can place fields inside, but list does not force you to have table layout.

-yuriy

|||

Hi, I am not sure what you are trying to ask, if you are bugged that when you drag/drop a field it comes like =First(Fields!fldname.Value) instead of

=Fields!fldname.Value, then you can edit this directly or right click in textbox ot table cell and go to Expressions and there you can create an expression using different functions,variables, parameters and fields.

I apologise if I am tootally off the track.

|||

No apologise necessary. I can't explain what I'm looking for well.

I grab a field from my fieldlist and drop it in the body. I go to preview and all that comes up is the first record in my result set. How do I make it a continous report so I have the first record, the last record and everything in between.

I'm able to do this if I create a table in the body and drop the fields in the details portion of that table. However that is too structured for some of the reports I'm looking for.

|||

Drag LIST control to your report first. Configure it to repeat records from your source. Then drag fields into the LIST control.

|||

Yes,

That works. Well I haven't tried the configure part yet but I create a list, drag the field in the list and BAM there it is. Great answer thank you.

|||

You can only use the data regions available to build reports, and they are sufficient to build most of the reports, go through the report design basics(http://msdn2.microsoft.com/en-us/library/ms159253.aspx) and Data regions available in reporting services and you should be able to design more complicated reports with a combination of these data regions(http://msdn2.microsoft.com/en-us/library/ms157134.aspx) .

Still if you have some problem designing the report you can post your specific requirement and we will try to help.

Build fails but no errors are returned

hi,

I moved my ssis solution from on dev machine to another.

When building the solution, visual studio keeps saying that the build failed but no errors are returned which is not really helpful...

any clues would be appreciated.

thanks

I don't believe you need to "build" anything.|||

well, the solution is built before starting the debugger process...

anyway, I've sorted my problem... errors where not displayed in the error list but I've found one returned in the output window.

It was complaining that it could not load the project files (note that I had no errors while loading the solution in VS).

I've deleted the .suo and other user files from the solution and it now works... did not realise that project file paths informations could be in the user files... I was expecting this information to be specific to solution and project files ...

|||I set my projects to never build under Tools-Options. Never had a problem.