Please help! Error: this operation violates your permission configuration

[VinodChattergee]

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

[_Nith_]

Try to apply Usage Rights and give it a try.

Nith

[VinodChattergee]

Hi Nith,

Thanks for the reply, but please let me know how to apply usage rights!

[_Nith_]

If you are using stand-alone PDF, try this URL:

http://localhost:8080/ReaderExtensions

or, If you are rendering PDF/XDP in workspace, edit the Render Service being used by the process and add a "Apply Usage Rights" component at the end (i.e as the last component in the render service).

Nith