These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Database connection fails, environment not trusted

Forum Index > JavaScript > Database connection fails, environment not trusted
2008-08-14 05:34:12
Mr_Grump
Registered: Jul 17 2008
Posts: 27
Answered

Hi All

I've read through a lot of stuff on this site regarding the error "Connection for Source [something] failed because the environment is not trusted". I've tried reader extensions, I've certified the PDF and still get the same error. Here's what I've done.

I have a drop-down list that I want to connect to an Access database. I create a new database connection for a Jet database, set the database path, select the table to use. I then bind the drop-down list to the correct field. Up to now, there's no problems and the "Test Connection" works.

When I try and open the PDF, I get the "....not trusted" error and the drop-down is populated with the first item in the field. No other items are loaded.

I created a certificate in Acrobat 9 and signed/saved the form. Still, the same error. I didn't have this problem till I upgraded to 9 for some reason. The form was created in LiveCycle ES (part of Acrobat 9 Pro).

I'm at wits end folks. Please help me out if you can.

Thanks

Lane

My Product Information:
Acrobat Pro 9.0, Windows
Top
2008-12-02 14:11:24
#1
Jkeller
Registered: Dec 2 2008
Posts: 1
Hi Mr Gump.

I am having the same problem and have found no solution for it. My form works fine in Acrobat 8, but won't work in version 9. I get the same error message. If you found an answer please share it.
Top
2008-12-02 14:43:28
#2
Mr_Grump
Registered: Jul 17 2008
Posts: 27
Hi JKeller

I'd forgotten about this post. I did find a solution a while back but I'll have to give it some thought as to how I did it. I'll research it a bit and get back to you.

I do remember it involved creating another connection.

I'll post it here soon.

Regards

Lane
Top
2008-12-02 15:46:29
#3
Mr_Grump
Registered: Jul 17 2008
Posts: 27
I found some of the info I used to figure out the solution to my problem. It requires creating a System DSN. Use the following steps.

Control Panel
Adminstrative Tools
Data Sources (ODBC)
System DSN Tab
Add
Microsoft Access Driver (*.mdb)
Finish
Give it a name you'll remember
OK
Close ODBC Window

Create a new connection in LiveCycle Designer selecting the table of choice. I used Java in the Initialize of my Drop-Down lists to load the list. There are likely other/better solutions but this worked for me. The code is quite lengthy and I can't take credit for it. I found it somewhere.

If you'd like the code and a PDF I used as a guide to do this stuff email me. I'll attach the files and send them to you. If you have issues by the weekend, I'll try and find time to send you a more detailed explanation.

regards

Lane
Top