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

    Please help! Error: this operation violates your permission configuration


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





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



      = "text"


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

      //Reopen the Dataconnection




      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!