Groups | Blog | Home
all groups > sql server data mining > march 2004 >

sql server data mining : SQL server books online mining model sample VB6 to C#


oshadha
3/17/2004 9:56:10 PM
Hi all
I'm trying to re-process a manually created mining model in the analysis services. I suppose this is possible with DSO 'processfull' command ? but i use C# for development and not sure how to connect to a existing mining model. I have pasted a part of the VB 6.0 sample coding found in SQL server books online bellow.

Dim dsoServer As New DSO.Serve
Dim dsoDB As DSO.MDStor
Dim dsoDS As DSO.DataSourc
Dim dsoDMM As DSO.MiningMode

' Connect to the server on this computer
dsoServer.Connect "LocalHost

' Select the FoodMart 2000 database
Set dsoDB = dsoServer.MDStores("FoodMart 2000"

' Create a new relational mining mode
' called CustSalesModelRel
Set dsoDMM = dsoDB.MiningModels.AddNew("CustSalesModelRel",
sbclsRelational

' Process the data mining model
With dsoDM
' Lock the mining model for processin
.LockObject olapLockProcess,
"Processing the data mining model in sample code
' Fully process the new mining model
' This may take up to several minutes
.Process processFul
' Unlock the model after processing is complete
.UnlockObjec
End Wit

but above coding creats a mining model, and i also have problem converting VB6 coding to C# in selecting database and connecting to appropriate mining model... can some help me out with the C# coding and how to connect to mining model statements..
Thanks a lot
Oshadha
Peter Kim [MS]
3/18/2004 3:07:04 PM
I don't have any DSO sample in C#, but isn't it good enough to just add DSO
references to you C# project and use it?

--
Peter Kim
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]
services. I suppose this is possible with DSO 'processfull' command ? but i
use C# for development and not sure how to connect to a existing mining
model. I have pasted a part of the VB 6.0 sample coding found in SQL server
books online bellow.
[quoted text, click to view]
VB6 coding to C# in selecting database and connecting to appropriate mining
model... can some help me out with the C# coding and how to connect to
mining model statements...
[quoted text, click to view]

AddThis Social Bookmark Button