3 Replies Latest reply on Jan 3, 2010 9:12 PM by $Nith$

    Please help! Error: this operation violates your permission configuration

    VinodChattergee Level 1

      I wrote the below code in the button click...

       

      if

       

       

      (Len(Ltrim(Rtrim(txtFirstName.rawValue))) > 0) then

      $sourceSet.SQLServerDataConnection.#command.query.commandType

       

      = "text"

      $sourceSet.SQLServerDataConnection.#command.query.select.nodes.item(0).value

      = Concat("SELECT * FROM Mashreq_Customers WHERE SERIAL_NO = ", Ltrim(Rtrim(txtFirstName.rawValue)) ,"")

      //Reopen the Dataconnection

      $sourceSet.SQLServerDataConnection.open()

      endif

       

      and then when on preview when i click the button - application throws an error "Error: this operation violates your permission configuration". Please help me in fixing this.Is this because of the server permissions for the table inside sql server?

       

      providing here the link which i followed so far to done sql data extraction  "http://www.adobe.com/devnet/livecycle/articles/lc_designer_db_lookup_tip.pdf". But in the approach shown in this link has no login to connect to the database through DSN.But I am connecting the database through credential.

       

      example as in guide :

      Provider=MSDASQL.1;Persist Security Info=False;Data Source=DesignerTestingDB

       

      Connection string which i wrote in my application:

      Provider=MSDASQL.1;Persist Security Info=False;Data Source=DesignerTestingDB;UID=user1;pwd=pwd1

       

       

       

      Please help me out!

       

      Thanks,

      Vinod