March 22, 2012 at 6:32 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 7:02 am
OpenRowset statement requires user to put
login and password in clear text if not using integrated security. This causes
security concerns. 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 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply