About OLE DB for DM!

I am a new comer in data mining, so I have some question that: Which
Microsoft? OLE DB Providers supported in Data Mining Services 2005? Is
MSDMine provider supported in Data mining Service 2005? Why no mining
model is created (althought there is no exception) when I run the program
like that: (I use C# in Microsoft Visual Studio 2005). I look forward
to hearing from you soon. Thanks and regards.
using System.Data.Oledb;
using System.Data;
............
string sConnect = "Provider =MSDMine;Data source = localhost;Initial
Catalog = Analysis Services Project1";
OleDbConnection cn = new OleDbConnection(sConnect);
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = cn;
cmd.CommandText = "CREATE MINING MODEL [AnalyzeShipments]( "
+ " [Shipment Id] LONG KEY,"
+ " [Days Since Last Shipped] LONG DISCRETIZED(CLUSTERS) PREDICT, "
+ " [Store Id] LONG DISCRETE, "
+ " [Quantity] LONG DISCRETIZED(CLUSTERS) PREDICT_ONLY, "
+ " [Vendor Name] TEXT DISCRETE, "
+ " [Product Type] TEXT DISCRETE) "
+ "USING Microsoft_Decision_Trees";
try
{
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
catch(Exception e)
{
MessageBox.Show(e.Message);
}MSDMine was an implementation "detail" in SQL Server 2000 and it was never intended to connect directly to the MSDMIne provider. You can do all the same using MSOLAP. If you want to use local mining models, eliminate datasource, and set the connection string parameter Location to a file name.

About data mining trainings for SQL Server 2005

Hi, all here,

I really wanna know when will some data mining trainings (trainings for delivering business intelligence solutions with data mining functionality in SQL Server 2005) for SQL Server 2005 be available then?

Thanks a lot for any information.

The eLearning and certification folks at Microsoft are working on advanced certifications and associated training material for BI Developers that will likely be available later this year. See this page for more information: http://www.microsoft.com/learning/mcp/mcitp/bid/default.mspx (Course 2796 will include data mining).|||

Solid Quality Learning also offers a SQL Server Data Mining course. If you're interested, I gave a 2 day course in Copenhagen last year and the slides are in the whitepapers section at sqlserverdatamining.com (free login required)

http://www.sqlserverdatamining.com/DMCommunity/Whitepapers+and+Articles/Whitepapers/Links_LinkRedirector.aspx?id=3584

The slides are a bit sparse (I think I wrote most of them on the plane), but have a pretty broad coverage of the technical side of the platform.

|||Hi, Raman,thanks a lot. And would those courses available in the UK at the time you mentioned above? Thanks a lot.|||Hi, Jamie, thanks a lot.

About Data algorithms

I just want to know what are the data algorithms available for sql server 2005 and can i use data mining as a web service

A list of algorithms with descriptions can be found at this location: http://msdn2.microsoft.com/en-us/library/ms175595.aspx

SQL Server Data Mining can be used as a web service (by sending XML/A requests inside SOAP payloads). A (live) sample for this can be found here: http://www.sqlserverdatamining.com/XMLAThinMiner/

Our client APIs (OLE DB Provider for Analysis Services, Adomd.Net, AMO) can also be used to conect to an Analysis Services HTTP end point. In this context, the web service communication part is encapsulated in our APIs, so your application does not need to distinguish between locally-accessible servers and HTTP end points (other than providing the appropriate connection string)

about analysis manager data mining model

i use sql server analysis manager and build a cube,
the i right click the cube ,select new mining model,
a messege box tell me: 'unable to get list of data mining
model algorithms,object or provider is not capabel of
performing requested operation'
what shall i do? install a new service pack?Please do not post the same question to multiple groups.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"frank" <wang_jidong@.founder.com.cn> wrote in message
news:0db101c3858d$6c8d7a40$a301280a@.phx.gbl...
> i use sql server analysis manager and build a cube,
> the i right click the cube ,select new mining model,
> a messege box tell me: 'unable to get list of data mining
> model algorithms,object or provider is not capabel of
> performing requested operation'
> what shall i do? install a new service pack?