Where I can find detailed information on the process of sending data from pdf form stored on the website to the sql database stored on web server ?? Where I can find some samples I could use to build my form and related script(s).
Thanks for advice.
If you want the form to contact the DB directly you will have to set up a DSN on each of the machines that will run the form. Note that this wil only work on Windows machines. Also the form must be launched for the script to run (you mentioned the PDF was stored on the web server). I have some samples that show how to deal with a DB but the attachments do not seem to be working correctly on the forum yet. If you cannot retrieve them post your email and I will email them to you directly.
If you are looking to submit the data from the form to a web service it is very straight forward. You need a field to hold the data (and also to bind the WS parameter to). In your web service you woudl define a string (to hold the data) as an input paramater. Then create a field on the form (make it invisible so the user does not see it). Then bind that input param to the field. Now when you are ready to call your web service populate the field using this command InvisibleFieldName.rawValue = xfa.datasets.data.saveXML("pretty") then you can execute the WS.
Hope that helps
I woudl recommend using web services to do this but it will depend on the database as well as if you have a server we can submit the data to. Otherwise I cannot do it unless you put something on each machine. As well how many users woudl be using this?
I know this thread has been since 2007 but please help. I need to send form field data to a database.
How can I do this without installing anything on the user's PCs.
Do you have any sample form I can use?
I currently use Acrobat X and Livecycle ES.
A DataSet Name (DSN) is a description of the connection that windows uses to contact your database. Acrobat/Reader will use this DSN to communicate through Windows to the DB. It needs to be on each machine that will execute the form....otherwise Acrobat/Reader has no means of talking to the DB.
I agree ad for that reason we do not recommend using direct access to the DB from the form (unless there is a small controlled group of users). Other Customers will submit the form to a central location (a web server) and then have the web server update the DB. Others will email it to a central program and have that update the DB. One other way is to email back to a common person (who does have a DSN set up) and have that person open the form with their version then update the form. You will notice a common theme of sending info back to a central location and having the DB updated in a single spot. The volume of forms shoudl be considered in the decision as to which way to go.
Hope that helps
BTW I sent tthe sample files anyways.
Thank you very much for your quick response. I can not retrieve your
attachments, so please send them by email. Thank you.
What does it mean that DSN has to be set up on each machine which will run
the form ??? Does it mean for each person who will use the form ?? or
rather once on the server where the form is hosted ??? It will be a bit
difficult to use if it will have to be installed on each user computers as
some users may not be happy to do it. If this is the case do you have any
solution you would recommend which will collect the data from the form
without asking users to do anything special on their computers ????
Broadmeadow NSW 2292
Direct: +61 2 9492 1277
Facsimile: +61 2 9462 1383
Mobile: +61 403 399 167
22/04/2009 10:31 PM
Please respond to
Tony Pluta <firstname.lastname@example.org>
If you want the form to contact the DB directly you will have to set up a
DSN on each of the machines that will run the form. Note that this wil
only work on Windows machines. Also the form must be launched for the
script to run (you mentioned the PDF was stored on the web server). I have
some samples that show how to deal with a DB but the attachments do not
seem to be working correctly on the forum yet. If you cannot retrieve them
post your email and I will email them to you directly.