Couple of things before you go down this path.
1. You will need to load the ODBC driver fro MySQL on your machine and each machine that will want to use that form.
2. Then you need a DSN that will create the connection between the MySQL DB table and your form.
3. If you are using Acrobat to run the form then you can proceed. If you are using Reader it does not support DB connections without Reader Extending the document using LiveCycle Reader Extensions Server.
Have you met all of these criteria?
That solved this one. I am also trying to configuer the same form with MS Access (on another PC), to compare and contrast the 2 methods. I set up the link the same way, and actually picked the tuples from the data view aspect of LifeCycle designer. Connection tested successful, location is correct, all fields match. But here is the crux: When I load the form in Adobe Acrobat 9 pro, it says: Connection for Source DataConnection failed because the environment is not trusted !
I am not sure how that can be, since I created the form as the admin and running everything same way. I did not implement any restrictions on any of the forms of the database. Any solutions for this one is greatly appreciated. If you need the forms adn the database, I can send them / attach them.
Where is the DB located ......on the same machine or on a different machine?
Is it an Acrobat dialog or a Windows dialog?
DB and PDF forms are on one machine (local). Software is Access 2007 (.accdb), Acrobat Pro 9 (.pdf), File was saved as static.
But I am not sure on the dialoge ( Acrobat vs. Windows). I used the MS Access 2007 connector. Connection checks out fine and so that the link,
since I can see and use the fields that were built in Access. Hence I use those fields, where the biding is automated for me.
When I save the form, there are no errors or warnings listed in LifeCycle designer - bottom window.
Just when opening the file in Adobe, it mentions that the access is somehow prohibited. Also, how does one send the data
to access once al the fields are filled out. I couldn't create or find a button for that?
Again, thanks for your help and input.
1 person found this helpful
The data connection is controlled by Windows ...we merely make a call through Windows. If I remember right there is a setting in IE that allows you to add the domain as a trusted site.
AS far as an update goes, it is much more complicated. I suggest that you do a serach for Stefan Cameron. He write a blog about forms and has covered this topic. Once you get to the blog page simply search for database and you will find a couple of entries on this topic.
I will check out the blog / site. But not sure why I need IE, since everything is running locally - local Access 2007 database & local PDF (Adobe). Both programs are fully installed on the system. No networking, no intranet, no file distribution or sharing, all local host (streight connection).
PS: I did however check out the IE tools - options - security - site - intranet options and made sure all pertinent things are enabled.