IMMEDIATE ATTENTION PLEASE.....

hi all..
hope u guys can help me out here.....
'm new to .net so hope to get all the basic infomr that would b required...

'm on a proj..basically a data mining proj...
'm using sql 2005 enterprise edn's analysis services to perform my data minning tasks...
here is what i'd like to know....
i've been following the sql online tutorial book...
n as per the tutorial on data minning...i have created a data source ... based on the decision tree algorithm i have even obtained some results..
now.....here is the problem..

i'd like to know if i can actually get all these obtained patterns onto a webpage...
i mean can i actually use asp.net n achieve this task of migrating the patterns generated at the bids to a webpage?

please guys if i can do so...then do tell me how to do so...
my proj dline is in 2 weeks....i need desperate help....
'm waitin...

here is how i vusualize my goal..... web pages that display patterns generated after an analysis has performed......

thxxxx... a ton
hanish

AS includes a set of data mining viewer controls intended for this. You can also query the mining models from RS.

See this topics in Books Online.

Using Analysis Services DMX Query Designer

And this link to download the Data Mining controls:

http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

The mining controls are halfway down the page.

|||

...umm...alrite thanks...

but the thing is i really don't wan't to open bids n check out the report.....

i am asking if there is any way how i can view the obtained patters at a report on a webpage without having to open

BIDS ....ll explain my problem ...........

my task is to illustrate data minning using asp.net as the front end and SQL server 2005 entp.as back end.....

BIDS will take care of all the data minning operations that i need to perform...and will generate reports corresponding to various data minning models.......

now i intend to create a UI using asp.net(c# codin.) and then link these web-pages to the already obtained reports.....can i do it without having the user open BIDS?

plzzzzzz plzzzz guys help me.....

thx.....

|||

That functionality is exactly what the data mining controls provide. The user doesn't have to use BIDS to see the results. For that matter, if you develop a report in Reporting Services and deploy it, the user doesn't need BIDS.

For your task, you need to look at the data mining controls. Or you could query directly through ADOMD (an OLEDB provider), but the mining controls handle the visual display for you.

|||

hi jwelch

thx for ur instructions for my problem.......

as per u instructed i d/loaded Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider which i suppose helps provide the data mining controls....... here is an honest appeal...after having installed it i havn't really seen any change or havn't really been able to discover the data mining controls...

i am certain that it is because i am totally new to sql server, i am getting a little nervous if i can really do this task, please would u mind helping me in achieving my task......

i've done minning on the adventure datawarehouse and now have obtained the patterns which i can view in BIDS......i would now like to know the steps i should follow to make use of the data mining controls by which i can migrate these results onto a browser.......you have told me this is possible ...please i have no other option but to take your help do consider my request ......

waiting for your reply..

|||

any body here ...

plzzzzzz help me in figurin my way out.....

mr.john u der?

|||

No, it's not the OLE DB provider. It's the data mining viewer controls. They are about 4 items below the OLE DB provider.

http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

Microsoft SQL Server 2005 Datamining Viewer Controls

The Data Mining Web Controls Library is a set of Microsoft Windows Forms controls that enable software developers to display data mining models created using Microsoft SQL Server 2005 Analysis Services in their client-side applications. The controls in this library display the patterns that are contained in Analysis Services mining models.
|||

hj wrote:

any body here ...

plzzzzzz help me in figurin my way out.....

mr.john u der?

hanish,

you really need a course on forum ettiquette: don't demand things, don't write all in capitals (your subject line), and don't expect people to do your work for you.

What exactly are you wanting? It seems to me that you want to know how to run or request reports from within a standard ASP.Net page?

|||

i do apologize ,

yup sluggy u got my prob rite......im tryin to run the results i got after the minin operation from within a std asp.net page..

hey..n thx ...mr.john....

|||

hi ...'m back again with my nt so good doubts..

;m stuck on thiz one thing mr.john...........

after havning installed the data mining viewer controls what is my next step....i mean i don't even see these contrls in my web dvlpr toolbar....

after going tro some threads here..i figured out that the nxt step is to add the viewer contrls into the toolkit of visual c# web dvplr.....

but ;m not succesful in doing so.....

jus like i told u before ...my task is to bring out these patters onto a web page.........

one more doubt......

is there any tutorial about what each of these web contrl does? whr can i learn more bout these controls......are there any sample videos i could get access to, to actually know more about how to use these controls....

please help me ....thx a lot

hanish|||

hj wrote:

hi ...'m back again with my nt so good doubts..

;m stuck on thiz one thing mr.john...........

after havning installed the data mining viewer controls what is my next step....i mean i don't even see these contrls in my web dvlpr toolbar....

after going tro some threads here..i figured out that the nxt step is to add the viewer contrls into the toolkit of visual c# web dvplr.....

but ;m not succesful in doing so.....

jus like i told u before ...my task is to bring out these patters onto a web page.........

one more doubt......

is there any tutorial about what each of these web contrl does? whr can i learn more bout these controls......are there any sample videos i could get access to, to actually know more about how to use these controls....

please help me ....thx a lot

hanish

Have you looked in your C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls folder? You may need to install the SQL Server Samples to use this.

|||

yup...dat is de exact prob....i did install dm viewer controls but den din find a samples folder under \Program Files\Microsoft SQL Server\90.......

now i did install all the samples that came with the sql cd..could u tell me whr i could download these samples from the net.....

my sincere thanks mr john..

feel like ur the only one replyin to my posts here..

thx again.......

hanish

|||one more question...'m working with sql server 2005 enterprise edn........do i hav to install sp2 for sql server to achieve my tasks...|||

hj wrote:

yup...dat is de exact prob....i did install dm viewer controls but den din find a samples folder under \Program Files\Microsoft SQL Server\90.......

now i did install all the samples that came with the sql cd..could u tell me whr i could download these samples from the net.....

my sincere thanks mr john..

feel like ur the only one replyin to my posts here..

thx again.......

hanish

This link has the lastest sample applications for SQL Server.

http://www.microsoft.com/downloads/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

|||

hj wrote:

one more question...'m working with sql server 2005 enterprise edn........do i hav to install sp2 for sql server to achieve my tasks...

I don't think it is required. However, the samples I referenced above have been updated for SP2.

IMMEDIATE ATTENTION PLEASE!!!

hi all..
hope u guys can help me out here.....
'm new to .net so hope to get all the basic infomr that would b required...

'm on a proj..basically a data mining proj...
'm using sql 2005 enterprise edn's analysis services to perform my data minning tasks...
here is what i'd like to know....
i've been following the sql online tutorial book...
n as per the tutorial on data minning...i have created a data source ... based on the decision tree algorithm i have even obtained some results..
now.....here is the problem..

i'd like to know if i can actually get all these obtained patterns onto a webpage...
i mean can i actually use asp.net n achieve this task of migrating the patterns generated at the bids to a webpage?

please guys if i can do so...then do tell me how to do so...
my proj dline is in 2 weeks....i need desperate help....
'm waitin...
thxxxx... a ton
hanish

i'd like to code in c#...so plzz tell me a way out of this prob.....|||

if you dump your results into a table you can report against it using .net tools like OWC (i. e. FrontPage, Excel, RS).

Also, here is the link to the article on how to build a model dynamically:

http://www.aspnetpro.com/newsletterarticle/2004/10/asp200410ri_l/asp200410ri_l.asp

|||

my task is to illustrate data minning using asp.net as the front end and SQL server 2005 entp.as back end.....

BIDS will take care of all the data minning operations that i need to perform...and will generate reports corresponding to various data minning models.......

now i intend to create a UI using asp.net(c# codin.) and then link these web-pages to the already obtained reports.....can i do it without having the user open BIDS?

plzzzzzz plzzzz guys help me.....

thx.....

|||

Included with SQL Server as a sample are the sample Data Mining web viewers - I think this should give you what you need. You can see them in action by launching the sample from here http://www.sqlserverdatamining.com/DMCommunity/LiveSamples/52.aspx

Also you can render your results as a report using the example here:

http://blogs.msdn.com/jamiemac/archive/2006/06/22/642541.aspx

|||hello Hanish,,,
i need decision tree code in c#,if u have plz help me.........
nd reply me at innocent_desire_89@.hotmail.com,waitng 4 ur reply
tcsql

Immedeite Help Required! - Fulltext indexing

Hello All,
When I restore a backup on a different Server, It automatically creartes the
records in sysfulltextcatalogs which refers the Catelogue path of old
database.
How to come out of this Proble?
If I remove the records from sysfulltextcatalogs, then while enabling the
Database for Fulltext indexing, the below error occured.
" Full-text catalog '' has been lost. Use sp_fulltext_catalog to
rebuild and to repopulate this full-text catalog. "
Is there a way that we can remove the old catelogue references and re-create
and populate the Catelogues?
Warm Regards
Sahian
Hi
This may help:
http://support.microsoft.com/default...b;en-us;240867
John
"Sathian" wrote:

> Hello All,
> When I restore a backup on a different Server, It automatically creartes the
> records in sysfulltextcatalogs which refers the Catelogue path of old
> database.
> How to come out of this Proble?
> If I remove the records from sysfulltextcatalogs, then while enabling the
> Database for Fulltext indexing, the below error occured.
> " Full-text catalog '' has been lost. Use sp_fulltext_catalog to
> rebuild and to repopulate this full-text catalog. "
> Is there a way that we can remove the old catelogue references and re-create
> and populate the Catelogues?
> Warm Regards
> Sahian
>
>
|||John,
While that KB article talks about moving or copying FT Catalogs it does not
directly address the issue that Sathian is encountering relative to the
"Full-text Catalog has been lost" (due to deleting the entry in
sysfulltextcatalogs). Sathian, you can run the following T-SQL system stored
proc to 'clean up' or remove any FT Catalogs that are referenced in
sysfulltextcatalog, but not actually present on the server or in the
registry keys:
sp_fulltext_service 'Clean_Up'
This should "clean up" the registry keys and allow you to proceed. See
http://msdn.microsoft.com/library/de...ullad_2gtv.asp
for more details.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:B792F9EB-983E-4E7E-84E0-17A0126167BF@.microsoft.com...[vbcol=seagreen]
> Hi
> This may help:
> http://support.microsoft.com/default...b;en-us;240867
> John
> "Sathian" wrote:
the[vbcol=seagreen]
the[vbcol=seagreen]
re-create[vbcol=seagreen]
|||Hi John
The removal of the record was by the OP,
"If I remove the records from sysfulltextcatalogs, then while enabling the
Database for Fulltext indexing, the below error occured."
He required:
"Is there a way that we can remove the old catelogue references and re-create
and populate the Catelogues?"
If he follows the article he can transfer the Full Text indexing correctly.
John
"John Kane" wrote:

> John,
> While that KB article talks about moving or copying FT Catalogs it does not
> directly address the issue that Sathian is encountering relative to the
> "Full-text Catalog has been lost" (due to deleting the entry in
> sysfulltextcatalogs). Sathian, you can run the following T-SQL system stored
> proc to 'clean up' or remove any FT Catalogs that are referenced in
> sysfulltextcatalog, but not actually present on the server or in the
> registry keys:
> sp_fulltext_service 'Clean_Up'
> This should "clean up" the registry keys and allow you to proceed. See
> http://msdn.microsoft.com/library/de...ullad_2gtv.asp
> for more details.
> Regards,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:B792F9EB-983E-4E7E-84E0-17A0126167BF@.microsoft.com...
> the
> the
> re-create
>
>
|||Hi John,
True. My only point is that the OP should not be manually removing records
from a system table as it is generally not recommended by Microsoft or by
MVP's to manually delete rows from any systems tables... However, the
"clean_up" parameter of sp_fulltext_service does - "Remove from the file
system all full-text catalogs that no longer have meta data for them in SQL
Server by executing this stored procedure". Note, the meta data includes the
entries in sysfulltextcatalogs as well as the FT Catalog registry keys that
are maintained by the MSSearch service.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:A2BA13CF-D2AE-4557-AE46-C3D10D2CD188@.microsoft.com...
> Hi John
> The removal of the record was by the OP,
> "If I remove the records from sysfulltextcatalogs, then while enabling the
> Database for Fulltext indexing, the below error occured."
> He required:
> "Is there a way that we can remove the old catelogue references and
re-create
> and populate the Catelogues?"
> If he follows the article he can transfer the Full Text indexing
correctly.[vbcol=seagreen]
> John
> "John Kane" wrote:
not[vbcol=seagreen]
stored[vbcol=seagreen]
http://msdn.microsoft.com/library/de...ullad_2gtv.asp[vbcol=seagreen]
creartes[vbcol=seagreen]
old[vbcol=seagreen]
enabling[vbcol=seagreen]
sp_fulltext_catalog to[vbcol=seagreen]

Imbedded charts in SQL Reporting

Can any third party charting tools be embedded within SQL Reports?
If so, is the Enterprise version of SQL Reporting required? We are
interested in developing a ASP.NET web site which has SQL Reports in it.
Those reports need charts embedded in them and the charts go beyond the
default charts shipped with the Standard Edition of SQL Reporting Services.Have a look at the following sites and go through their documentation. You
may have to research on pricing, development time etc...
http://www.cizer.com/portalcsvs/DesktopDefault.aspx
http://www.dundas.com/products/casestudies/index.aspx?Section=CaseStudies&Campaign=ReportingServi
Good luck!
Rajesh Meenrajan
MCSD.NET
http://meenrajan.blogspot.com
"bteclt" wrote:
> Can any third party charting tools be embedded within SQL Reports?
> If so, is the Enterprise version of SQL Reporting required? We are
> interested in developing a ASP.NET web site which has SQL Reports in it.
> Those reports need charts embedded in them and the charts go beyond the
> default charts shipped with the Standard Edition of SQL Reporting Services.

IIS required for SQL Express Adv

I'm trying to install SQL Express Adv and it warns me I need IIS to support certain features for Reports. Despite hours of searching through the MS website, I can not figure out what features those are to determine if I want put in IIS. Furthermore, I can not even figure out how to get IIS on my system. I need to do this for my laptop, which is XP Pro 2002 SP2. I also need to do this for my desktop, which is XP Home 2002 SP2. Neither of them have IIS installed that I can tell (and according to the initial install check done by SQL Express Adv it is not installed).

XP Pro comes with IIS, but does not install it, you need to select it from the list of options in add/remove programs/add/remove windows components. XP Home does not support IIS at all, ever.

I would guess that unless you want to serve data over the web, you don't need IIS.