Post reply

dmx help plz

  • March 22, 2012 at 6:34 am

    #255174

    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

    #1462657

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply