Adobe Acrobat PDF DataBase Connection

[Guest]

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

[Guest]

Hi Everybody,

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

Thanks,

Manjeet

[Guest]

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

[Bernd Alheit]

ADBC isn't available in the actual version of Adobe Acrobat.

[Guest]

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

[Dave Merchant]

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.

[Guest]

Hi Dave,

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

Thanks,

Manjeet

[Test Screen Name]

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.

[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.

[stburden77]

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

[arunap15154166]

Hi,

I'm trying to connect Adobe live cycle PDF form to SQL server database. In my PDF Form, I had drop down list and it's get value from data base. don't know how do this. I'm a beginner for this. Could you please tell me, how to done this and share sample link or demo.

And also i have question like " whether the accessing DB need to be installed in all user system"?. please advise this question.

This is very urgent. Please advise me

[Thom Parker]

Database access requires "something" to connect the PDF form to the DB. LiveCycle forms make this something a bit easier to come by because Acrobat implements some common Windows based DB connections, such as ODBC. In this case the something is an OCBC driver. So the question is, can you get an ODBC driver that will connect to the SQL server?  If so then all you have to do is setup the driver.

Otherwise, the common methodology is to write a server side script to send the PDF data in one of the common PDF data formats through an HTTP response. For an LC form this would be XDP.