Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

[AEM Gems Webinar] Accelerating Experience Manager as a Cloud Service development with Rapid Development Environments
Adobe Summit 2023 | Complete list of AEM Sessions & Labs

connect livecycle form to sql table


Level 1


Please pardon me if this is the wrong place to post this question.  I am new to creating data connections to backend servers and really need some help here.

I have a sql server table which I have full rights too.  I have created a system dsn called DataConnection back to the database.  That works fine.  I created a form in Livecycle Designer ES2 and successfully made a data connection in LiveCycle called 'DataConnection' back to the table called 'Facts'.  I'm able to generate the table fields on the form with no issue and I can see the first record populated when i do pdf preview.

Question 1 - Why is it if I dont have 'delayed open' checked on the connection properties I receive a message box 'connection for Source DataConnection failed because the environment is not trusted'?

Question 2 - For this test form, all I want to do is navigate and view the records  (ie go to next, go to previous).  I followed the sample from this page: ; and created my navigation buttons for previous and next.  However, when click the buttons I receive the error that the operation failed because there was no connection specified.  screenshot is attached.  Can I someone tell me what I am missing here?

Ultimately what I want is a form that will be available from a web server that people can navigate data through.  The data will be on a  sql table.   There is no need to update, add or delete records.  They will just view directly from this form .  Am I going in the right direction?

Any help is greatly appreciated.


1 Reply


Level 3

This is a LiveCycle Forms question rather than a LiveCycle Data Services question. Please repost your question in the LiveCycle Forms forum.