DMX Error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Mining » DMX Error

DMX Error

Rate Topic

Display Mode

Topic Options

Author

Message

Larry Page(Ehsan.Akbar)

Posted Sunday, April 01, 2012 8:36 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 21, 2013 11:11 PM
Points: 122, Visits: 234

I have a data base (testmining) with 2 tables in my engine service,
these 2 table are connected with customer_id column as a primary key in customer and foreign key in purchase
and i have a database (mining) in my analyses service on my sql server 2008 ,
so i create a mining model in my mining database on analyses services :
Create mining model MarketBasketModel
(
CustomerId long key,
Gender text discrete,
Income long continuous,
MemberCard text discrete,
Purchases table Predict_Only (
ProductName text key,
Quantity long continuous
)
)
Using Microsoft_Decision_Trees

so when i want to execute this command :

Insert into MarketBasketModel_Structure( CustomerId, Gender, Income, MemberCard,
Purchases( ProductName, Quantity) )
OpenRowset('SQLOLEDB', 'Server=EHSAN-PC;Integrated Security=SSPI',
'Shape
{ Select Customer_id, Gender, Income, member_cart From testmining.dbo.Customer }
Append (
{ Select Product_Name, Quantity From testmining.dbo.Purchase }
Relate testmining.dbo.Customer.Customer_Id to testmining.dbo.Purchase.Customer_id ) as Purchase')

i got this error :

OLE DB error: OLE DB or ODBC error: Syntax error or access violation; 42000

---------------------------------------------------
baaaaaaaaaaaaaleh!!! (Ehs_Akb)

Post #1276362

LutzM

Posted Sunday, April 01, 2012 8:42 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 3:17 PM
Points: 6,731, Visits: 12,131

duplicate post. No replies plese.
Please repond using the original thread

@Larry: Posting the same question multiple times does not only fragment the answers. It might also lead to duplicate answers (= waste of time for those of us answering questions).

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function

Post #1276363

Larry Page(Ehsan.Akbar)

Posted Sunday, April 01, 2012 10:16 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 21, 2013 11:11 PM
Points: 122, Visits: 234

sorry ,
i am asking this question for month but unfortunately i donot get any answer for that .and i have to ask this question in others part of forums .

---------------------------------------------------
baaaaaaaaaaaaaleh!!! (Ehs_Akb)

Post #1276393

« Prev Topic | Next Topic »

Permissions