I am trying to pre-populate an Adobe form with SQL Data and view it in Reader or Acrobat, but am getting the error of "Connection for Source DataConnection failed because the environment is not trusted" error.
I can see the data from within LiveCycle. I've saved it as both Dynamic XML and Static PDF forms and neither one connects in order to display the data from the table. They both display what the data was at the time the pdf was saved in LiveCycle.
Check out Stefan Cameron's blog, in particular:
http://forms.stefcameron.com/2006/10/12/displaying-all-records-from-an-odbc-data-connection/
Hope this helps,
Niall
Assure Dynamics