April 1, 2012 at 12:02 am
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)
April 2, 2012 at 3:51 pm
I am not an Analysis Services expert but 42000 as an error seems to be a login failure of some type.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
April 2, 2012 at 4:01 pm
See if this thread will help
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply