Hey everyone, yesterday I started working with Acrobat 9 Pro and LiveDesigner ES. I created a PDF Form that connects to our SQL database on the intranet server and pulls from a table. Whenever I open the PDF file in LiveDesigner, I get the message "Connection Source failed because the environment is not trusted", And it won't populate the textboxes I have setup that should be displaying table data. It also doesn;t work when just opening in reader, but there is no error message in that case. When setting up the data connection it works and tests OK. I have researched this and found that some people suggest using ODBC and/or certifying / digitaling signing the document. Due to my employeer's company standards I cannnot use ODBC, and I have tried certifying but it does nothing. The error message occurs wether I use the Microsoft SQL Database OLEDB or the Native SQL OLEDB.
This has been very frustrating for me. Any help would be appreciated. The connection string if it will help:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;User ID=myusername;Initial Catalog=TestTable;Data Source=serverYYY;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=mycomputername;Use Encryption for Data=False;Tag with column collation when possible=False
