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

PDF forms and Databases

segun
Registered: Aug 13 2007
Posts: 4

I have been working with Adobe Acrobat Proessional 7 to create and
design online PDF forms for sometime now and I must confess it is a wonderful experience. I have been able to connect my PDF forms to
Databases such as Microsoft Access, SQL Server and MySQL on my local
system. I can comfortably save data from my PDF forms into these
databases locally on my system. But I need to migrate those forms to
the internet and allow users to fill such forms and submit their
data online. This has been a major problem.
 
Therefore, I need clarification on these two issues;
 
1. I want to be able to save data from my PDF forms into MySQL
database online. How do I go about this? I have read a lot of articles on this, but none has answered my question as effectively
as I would want. I need practical examples to solving this problem.
 
2. In terms of connecting PDF forms to online Databases, which is
better; Adobe LiveCycle or Adobe Acrobat Pro?
 
I look forward to a very prompt response to my questions.
 
Thank you,
 
Segun

My Product Information:
Acrobat Pro 7.0.0, Windows
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
Acrobat was not really built for this sort of thing. Online access is best handled by looser connections, like HTTP Request/Response. Synchronous DB access is possible, but not ideal.

And there is another problem, DB access requires special Reader Enabling Rights in order for it to work on Reader. Either you're users all have to have Acrobat Standard/Professional, or you have to get an Adobe Rights Server.

But I already answered this question at:

[url=http://www.acrobatusers.com/forums/ask_an_expert/questions/view/2746/]http://www.acrobatusers.com/forums/ask_an_expert/questions/view/2746/[/url]

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script