"Bogdan Crivat [MSFT]" wrote:

> Most likely, the problem is related to authentication.
> Your web application is running as some user that has no permissions on the
> Analysis Services server.
>
> Assuming you are running Windows XP and the Analysis Services machine is the
> same as your web server, you should grant permissions over the mining model
> to the localhost\ASPNET user.
> If you have a different configuration, please describe it
> --
> --
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Please do not send email directly to this alias. It is for newsgroup
> purposes only.
>
> thanks,
> bogdan
>
> "miyakejess" <miyakejess@discussions.microsoft.com> wrote in message
> news:B0099CB2-8695-4481-B0A0-B68BFB70A5C7@microsoft.com...
> >I have followed the steps in the link you post before.
> > I have already installed the VS2005 and SQL Server 2005
> >
> > Everything is ok. But when I finish the ASP.NET application and build it
> > THe ASP cannot connect to the Analysis Server! So poor
> >
> > in the link, the sample file's connection string is
> > "Provider=MSOLAP.3;Data Source=localhost;Initial
> > Catalog=MovieRecommendations"
> >
> > but my server name is "prj74" and the Analysis Services name is "ASprj"
> > so I change to
> > "Provider=MSOLAP.3;Data Source=prj74;Initial Catalog=ASprj"
> >
> > And I also try this
> > "Provider=MSOLAP.3;Data Source=prj74;Initial Catalog=MovieRecommendation"
> >
> > As the training Data is in MoiveRecommendatino database
> >
> > however, the connection still cannot establish.
> > Actually, what's the problem ?
> > Is the problem related to the connection string? Or the setting of the
> > server?
> >
> > Please HELP ME!!!!
> >
> > "Bogdan Crivat [MSFT]" wrote:
> >
> >> I don't think it is possible to use AdomdClient in VS 2003.
> >> However, you should get the same functionality with OleDbConnection. The
> >> only major difference, wrt. data mining, in using System.Data.OleDb
> >> objects
> >> is that AdomdCommand supports named parameters and OleDbCommand does not.
> >> Everything else should be the same
> >>
> >>
> >> --
> >> --
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> Please do not send email directly to this alias. It is for newsgroup
> >> purposes only.
> >>
> >> thanks,
> >> bogdan
> >>
> >> "miyakejess" <miyakejess@discussions.microsoft.com> wrote in message
> >> news:38E15D99-9938-4587-8F05-24C0525EB102@microsoft.com...
> >> > Icic, Thank you~
> >> >
> >> > But, from this method, I have raised another problem
> >> > 1) How can I use different .NET framework in different component?
> >> > 2) Is there any references for me to follow by using VS2003~
> >> >
> >> > Indeed, I don't know how to use the "AdomdClient assembly"
> >> >
> >> > Could you help me more?
> >> > THank you very much!
> >> >
> >> > "Bogdan Crivat [MSFT]" wrote:
> >> >
> >> >> VS 2003, uses Microsoft .Net Framework 1.1 and the AdomdClient
> >> >> assembly
> >> >> is
> >> >> built for .Net Framework 2.0.
> >> >> You should either use VS 2005 or, inside VS 2003, use OLE DB:
> >> >>
> >> >> System.Data.OleDb.OleDbConnection with a connection string like
> >> >> "Provider=MSOLAP; Data Source=<your server>; Initial Catalog=<Your
> >> >> Catalog>"
> >> >> Then, System.Data.OleDb.OleDbCommand etc.
> >> >>
> >> >> --
> >> >> --
> >> >> --
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >> Please do not send email directly to this alias. It is for newsgroup
> >> >> purposes only.
> >> >>
> >> >> thanks,
> >> >> bogdan
> >> >>
> >> >> "miyakejess" <miyakejess@discussions.microsoft.com> wrote in message
> >> >> news:83E59DE3-DB25-41CB-B783-124F559E881C@microsoft.com...
> >> >> > Thank you for your reply =)
> >> >> >
> >> >> > I have installed the SQL Server 2005. But when I Try to add the
> >> >> > references
> >> >> > "Microsoft.AnalysisServices.AdomdClient.dll"
> >> >> > It said I cannot add it as "this is not a valid assembly or com
> >> >> > component.
> >> >> > Only assembly extension dll and com can be added......"
> >> >> > Actually, I am using MS visual studio 2003. Is it the reason of the
> >> >> > error?
> >> >> >
> >> >> > Could you help me more?
> >> >> >
> >> >> > Thank you very much!
> >> >> >
> >> >> > "Bogdan Crivat [MSFT]" wrote:
> >> >> >
> >> >> >> As Zulfiqar mentioned, we have lots of documentation on this
> >> >> >> subject (
> >> >> >> and
> >> >> >> this article contains step-by-step information:
> >> >> >> http://www.aspnetpro.com/newsletterarticle/2004/10/asp200410ri_l/asp200410ri_l.asp)
> >> >> >>
> >> >> >> It is possible to do this with SQL Server 2000 using Microsoft
> >> >> >> Decision
> >> >> >> Trees instead of Association Rules. AR is optimized for this kind
> >> >> >> of
> >> >> >> problems, so training will be much faster. Also, AR will scale
> >> >> >> better
> >> >> >> with
> >> >> >> huge product catalogs. However, Decision Trees can be used over the
> >> >> >> same
> >> >> >> kind of mining model (same inputs and outputs).
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> --
> >> >> >> --
> >> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> >> rights.
> >> >> >> Please do not send email directly to this alias. It is for
> >> >> >> newsgroup
> >> >> >> purposes only.
> >> >> >>
> >> >> >> thanks,
> >> >> >> bogdan
> >> >> >>
> >> >> >> "ZULFIQAR SYED" <DRSQLnospam2005@hotmail.com> wrote in message
> >> >> >> news:B6BA22ED-D6C5-40F9-B3FB-FC8E82FBF348@microsoft.com...
> >> >> >> >I mostly familiar with sql server 2005 and you could easily do it
> >> >> >> >in
> >> >> >> >sql
> >> >> >> > server 2005 at the back end and adomd.net on the front end. There
> >> >> >> > are
> >> >> >> > plenty
> >> >> >> > of examples in Jamie/Zhao book DATA MINING SQL SERVER 2005. In
> >> >> >> > sql
> >> >> >> > server
> >> >> >> > 2005 you could use association algorithm for that.
> >> >> >> >
> >> >> >> > But if you must use sql server 2000 then good luck with that
> >> >> >> > otherwise
> >> >> >> > this
> >> >> >> > would be a much easier solution using 2005.
> >> >> >> >
> >> >> >> > Let me know if you have any more questions on this.
> >> >> >> > SQLSERVERDATAMINING.COM
> >> >> >> > also has some great tutorials and exercises on related issues.
> >> >> >> >
> >> >> >> >
> >> >> >> > --
> >> >> >> > http://zulfiqar.typepad.com
> >> >> >> > BSEE, MCP
> >> >> >> >
> >> >> >> >
> >> >> >> > "miyakejess" wrote:
> >> >> >> >
> >> >> >> >> And sorry For All that, I would like to implement it by using
> >> >> >> >> SQL
> >> >> >> >> server
> >> >> >> >> 2000.