How to read SQL DB from PDF form
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?
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?
mohan_sekar
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.
ASKER
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.
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.
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".
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".
ASKER
Thanx khkremer, you are right, its "Adobe Acrobat". I'll get to work immediately.
Let me know if you run into any problems.
ASKER
sure! Thanx!
ASKER
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.
ASKER
Maybe you can point me to the proper link?
Thanx
Thanx
ASKER
Hi khkremer, you think you can point me to the proper link where it discussed connecting to a SQL database or ODBC?
ASKER
Any suggestion to point me to the proper link where it discussed connecting to a SQL database or ODBC?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.