9 Replies Latest reply: Dec 24, 2012 3:19 PM by stburden77

Adobe Acrobat PDF DataBase Connection

manjeete Aug 17, 2012 2:17 AM

Hi Everybody,

Is it possible to connect an acrobat pdf forms to DataBase? Actually i want that whenever a form filler will fill the data in forms and when he/she click on the Submit button, all the datas must be inserted in to the DataBase. Please help me in this regard.

Thanks,

Manjeet

1. Re: Adobe Acrobat PDF DataBase Connection

manjeete Aug 17, 2012 3:22 AM (in response to manjeete)

Hi Everybody,

Can i use SQL Server as my database? How PDF form will be connected to the database?

Thanks,
Manjeet
Like Show 0 Likes (0)

Actions
2. Re: Adobe Acrobat PDF DataBase Connection

manjeete Aug 17, 2012 4:08 AM (in response to manjeete)

Hi Everbody,

I got a good article explaing PDF Forms + DataBase Connection. Follow the below link.
http://www.aces.edu/ctu/techref/software/acrobat/5.x/ADBC.pdf

Regards,
Manjeet
Like Show 0 Likes (0)

Actions
3. Re: Adobe Acrobat PDF DataBase Connection

Bernd Alheit Aug 17, 2012 11:24 AM (in response to manjeete)

ADBC isn't available in the actual version of Adobe Acrobat.
Like Show 0 Likes (0)

Actions
4. Re: Adobe Acrobat PDF DataBase Connection

manjeete Sep 3, 2012 11:53 PM (in response to Bernd Alheit)

Hi Bernd,

Can you please tell me, How an acrobat pdf forms will be connected to the sql server database?

Is it possible or not? If possible, can you please provide any sample or links?

Thanks,
Manjeet
Like Show 0 Likes (0)

Actions
5. Re: Adobe Acrobat PDF DataBase Connection

Dave Merchant Sep 4, 2012 12:14 AM (in response to manjeete)

ADBC was depreciated in Acrobat 9 and removed completely in Acrobat X.

If you want users of Adobe Reader X to open database-connected forms you must use XFA and LiveCycle Designer to create them. If you intend to use Acrobat forms, the only database system available is SOAP (implemented via JavaScript) and that must be activated in Adobe Reader via the LiveCycle ES3 Reader Extensions server application - not with Acrobat.
Like Show 0 Likes (0)

Actions
6. Re: Adobe Acrobat PDF DataBase Connection

manjeete Sep 4, 2012 12:36 AM (in response to Dave Merchant)

Hi Dave,

Thanks for replying. Can you provide any link for SOAP database system?

Thanks,
Manjeet
Like Show 0 Likes (0)

Actions
7. Re: Adobe Acrobat PDF DataBase Connection

Test Screen Name Sep 4, 2012 12:42 AM (in response to manjeete)

SOAP is not actually a kind of database, it's a kind of network connection. You'd need (as well as LiveCycle Reader Extensions, please check pricing) a database which offers SOAP connections, or you'd write a server process for your database which offered SOAP connections.
Like Show 0 Likes (0)

Actions
8. Re: Adobe Acrobat PDF DataBase Connection

Test Screen Name Sep 4, 2012 12:44 AM (in response to Test Screen Name)

Acrually, what you describe is a normal and very typical thing to do, and it is not done the way you describe. Forget all idea of directly writing the database on the user's computer unless your needs are very special and unusual.

Submitting a form means to connect to a web script (CGI, ASP, PHP...) on your web server, just like for any HTML form. The web script is responsible for adding to the database.
Like Show 0 Likes (0)

Actions
9. Re: Adobe Acrobat PDF DataBase Connection

stburden77 Dec 24, 2012 3:19 PM (in response to Test Screen Name)

Happy Holidays To All:

I also need to connect an acrobat pdf form to a SQL Server database and LiveCycle is not an option.

We have a document manage software package that allows me to create pdf fillable forms for our users. The following is what I'd like to accomplish:

When the form loads, a "vendor name" dropdown box will be populated with distinct "vendor names" from our SQL Server database. The reason for this is so they don't key in different variations of the same vendor name. Currently, I'm using adobe pro X to create my forms and can upgrade to adobe pro XI if necessary.

Best regards
Like Show 0 Likes (0)

Actions