How to read SQL DB from PDF form

jana
jana used Ask the Experts™
on
I have project where I need to access information from another database (SQL 2005) like customer, patients and items.

I understand that Adobe offers programming and would like to know from EE if this is possible and how can I start it.

The project consists of a series of PDF documents that the user has to manually enter each patient and customer names manually.  However this same info is also located in another application using SQL 2005 as database.

How can I read SQL and have the user to choose the customer in a drop-down window or something simiilar?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Check for "ADBC" (Adobe Database Connectivity) documentation on Adobe's website.
Just keep in mind that you need the full Acrobat version to do that. You can reader enable the forms, but it cannot be done with the functionality that's built into Acrobat. There is also SOAP connectivity, but it has the same limitations.

Author

Commented:
I have a full version of acrobat writer.

I can't find the "Adobe Database Connectivity", can you send me the link?

Also, would be possible to have a small example to see it?

Lastly, consulting this need with others, I was informed also thru java script this can be done and others say, that java don't access database (we i am really lost and decided to only follow EE advice here), so any info is greatly appreciated.  I am really constraint in time so I'll keep an eye on this question.  Thanx very much.
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

Do you have the Acrobat JavaScript Reference? You need to program in order to access a database:

You can access all the SDK documentation here:
http://livedocs.adobe.com/acrobat_sdk/9.1/Acrobat9_1_HTMLHelp/wwhelp/wwhimpl/common/html/wwhelp.htm?context=Acrobat9_HTMLHelp&file=JavaScript_SectionPage.70.1.html

ADBC is described here:
http://livedocs.adobe.com/acrobat_sdk/9.1/Acrobat9_1_HTMLHelp/JS_API_AcroJS.88.2.html

In both cases,  you need to click on the "Navigation bar" button in the upper left corner to display the table of contents.

Oh, and there is no product called the "Acrobat Writer" - the correct product name is "Adobe Acrobat" - the free Reader is the "Adobe Reader".

Author

Commented:
Thanx khkremer, you are right, its "Adobe Acrobat".  I'll get to work immediately.
Let me know if you run into any problems.

Author

Commented:
sure! Thanx!  

Author

Commented:
Hi i checked up on the links, but can't seem to fin any reference to open a connection to a Micrososft SQL database and less, a script to read the SQL DB.

Author

Commented:
Maybe you can point me to the proper link?

Thanx

Author

Commented:
Hi khkremer, you think you can point me to the proper link where it discussed connecting to a SQL database or ODBC?

Author

Commented:
Any suggestion to point me to the proper link where it discussed connecting to a SQL database or ODBC?
Sorry for the delay, but I was travelling.

When you go to the ADBC link that I posted, and you click on the icon in the upper left corner, you will enable the navigation pane. In here, you can then see all the API function that are available in Javascript (and more). When you then go to the newConnection function, you will find a sample for creating a new connection to a database.

After that, review the Connection object and the Statement object:
http://livedocs.adobe.com/acrobat_sdk/9.1/Acrobat9_1_HTMLHelp/JS_API_AcroJS.88.311.html
http://livedocs.adobe.com/acrobat_sdk/9.1/Acrobat9_1_HTMLHelp/JS_API_AcroJS.88.1200.html

The method descriptions have sample code.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial