Re: Implementing ASP.NET to get the result of the Data Mining

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:38E15D99-9938-4587-8F05-24C0525EB102@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:83E59DE3-DB25-41CB-B783-124F559E881C@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxx> wrote in message
news:B6BA22ED-D6C5-40F9-B3FB-FC8E82FBF348@xxxxxxxxxxxxxxxx
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.

"miyakejess" wrote:

Dear All,

Help. I am a beginner of implementing Data mining program.

Now, I would like to find a the result that
when someone buy product A, they mostly will buy product B and C
too,
so that I am implementing something related to the Association
Rules?

But I don't know what tools, software to implement?
And futhermore, i don't know how to start up my program.
I will use VB to implement my webpage.

Do anybody help me? I am quite urgent on it!
Please help me.
one thousands of Thanks!












.

Relevant Pages

  • Re: One Connection String for Multiple Users (SQL)
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... "William Vaughn" wrote: ... This uses the> same connection string for all instances of the application. ...
    (microsoft.public.sqlserver.connect)
  • RE: How do I configure Analysis Services for Excel 2003 users?
    ... they had had Office 2003 installed AFTER SQL Server. ... > I have been preparing a set of cubes in Analysis Services 2005 to be viewed ... > Excel reports have been designed as pivot tables based on AS cubes, ... > Surely it must be that the connection string is incorrect but I seem to have ...
    (microsoft.public.sqlserver.olap)
  • Re: Connecting to Sql Server using an IP address
    ... using IP address without port number (default port number ... of SQL Server is 1433) cannot connect to the SQL Server on a remote ... name in the connection string can connect the remote machine successfully. ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem connecting to an SQL 2005 Express Instance in RANU mod
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... I'm using SQL2005 Express User Instance Feature. ... attaching an MDB file with the following connection string: ...
    (microsoft.public.sqlserver.connect)
  • asp.net 2.0 login control
    ... A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] ... These problems left me stranded for days, then today, on another machine, I hit a different set of problems I kept getting the following "Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance. ... (Basically this is a new option in the connection string that allows you to point out where the ..mdf file resides eliminating the need to create database in some SQL instance.) ... Beware that the windows account of the user that first creates the connection in this databaseless manner, becomes exclusive user for this file and no other windows account will be able to create a connection to this file. ...
    (microsoft.public.dotnet.languages.vb)