I currently design PDF forms with Adobe Acrobat 7. I have been able to connect my forms to Access and MySQL databases on my local system.The question is how do I connect my PDF forms to MySQL database online?
2. Which is better in terms of online database connection; Adobe Acrobat Professional and Adobe LiveCycle?
Thank you.
Submitting PDF data online to MySQL Database
2007-08-13 06:02:05
My Product Information:
Acrobat Pro 7.0.0, Windows
Acrobat Pro 7.0.0, Windows
2008-02-05 09:01:34
#2
Hello,
I am looking your response and would like to know how you can do to the PDF file with javascript talk with the .aspx file that contain the DB connection??
Also I need to know how you can do to send the information of the fields of the PDF Form so you can insert the information with the .aspx file.
Thank you in advand and regards.
Javier.
I am looking your response and would like to know how you can do to the PDF file with javascript talk with the .aspx file that contain the DB connection??
Also I need to know how you can do to send the information of the fields of the PDF Form so you can insert the information with the .aspx file.
Thank you in advand and regards.
Javier.
The "ADBE" object in Acrobat JavaScript uses ODBC to connect to a Database. If you have an ODBC Driver for a DB then you can connect to it. It has nothing to do with Acrobat or PDF.The data connections in LiveCycle use OLEDB drivers, again, if you have a driver for it you can connect to it. It's go nothing to do with Acrobat.
There is another way to do this, and probably a better one than using Acrobat's built-in DB support. Since the DB is online you could put all of the DB access code into a server side script. Then use "submitForm()" calls on the PDF to communicate with the DB through the server script. You can make this technique work for any platform and any forms technology. The built in DB access methods are limited, and depend on client side software.
There is another way to do this, and probably a better one than using Acrobat's built-in DB support. Since the DB is online you could put all of the DB access code into a server side script. Then use "submitForm()" calls on the PDF to communicate with the DB through the server script. You can make this technique work for any platform and any forms technology. The built in DB access methods are limited, and depend on client side software.
2009-02-16 19:49:27
#3
Am waiting Thomp or anybody Repply for this question. thanks
2009-02-16 20:27:27
#4
Acrobat forms can be set up to submit to a web server in various formats, including "HTML", FDF (Adobe's Forms Data Format), XFDF (XML version of a subset of FDF), XML, XDP, PDF, etc.
Most ASP programs that are used to process form submissions would be expecting the data to be in "HTML" format or some type of XML. So you server-side program just needs to know what format to expect and then parse the incoming data and take it from there.
Programming a web server is beyond the scope of these forums, but it you have a question about setting up an PDF form to submit data to a web server, it's best to be as specific as you can. The basics include either using a "Submit a form" action or using the submitForm JavaScript method. The submitForm JavaScript method is documented in the Acrobat JavaScript reference.
George
Most ASP programs that are used to process form submissions would be expecting the data to be in "HTML" format or some type of XML. So you server-side program just needs to know what format to expect and then parse the incoming data and take it from there.
Programming a web server is beyond the scope of these forums, but it you have a question about setting up an PDF form to submit data to a web server, it's best to be as specific as you can. The basics include either using a "Submit a form" action or using the submitForm JavaScript method. The submitForm JavaScript method is documented in the Acrobat JavaScript reference.
George
The data connections in LiveCycle use OLEDB drivers, again, if you have a driver for it you can connect to it. It's go nothing to do with Acrobat.
There is another way to do this, and probably a better one than using Acrobat's built-in DB support. Since the DB is online you could put all of the DB access code into a server side script. Then use "submitForm()" calls on the PDF to communicate with the DB through the server script. You can make this technique work for any platform and any forms technology. The built in DB access methods are limited, and depend on client side software.
Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script