March 22, 2012 at 6:33 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:38 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
March 22, 2012 at 6:41 am
apologize
my connection got a problem and didin't know my text is posted
---------------------------------------------------
baaaaaaaaaaaaaleh!!! (Ehs_Akb)
March 22, 2012 at 7:00 am
i figured out
In SQL Server 2005, the OpenRowset statement is turned off
by default. If you want to issue OpenRowset queries for date mining, you need
to set the Analysis Services server property AllowAdhocOpenRowsetQueries to
be True.
---------------------------------------------------
baaaaaaaaaaaaaleh!!! (Ehs_Akb)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply