March 22, 2012 at 6:34 am
i created a mining model and when i want to execute this code :
Insert into MINING STRUCTURE [MemberCard_Prediction_Structure]
( CustomerId, Gender, Age, Profession, Income, HouseOwner, MemberCard)
OpenRowset('SQLOLEDB', 'Server=EHSAN-PC;Integrated Security=SSPI',
'Select Customer_id, Gender, Age, Profession, Income, houseOwner,
member_cart From testmining.Customer')
--------------------------------
a got this error:
Executing the query ...
Error (Data mining): Ad hoc connections as specified in OPENROWSET clauses cannot be used on this server.
Execution complete
-------------------------------
I already adjusted the SQL Server Setting for Key
"Ad Hoc Distributed Queries" to 1
-> this was one of the common problems I found during my research, but it didn't help.
What else do I have to change or setup?
---------------------------------------------------
baaaaaaaaaaaaaleh!!! (Ehs_Akb)
March 22, 2012 at 6:39 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1270783-147-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply