• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 784
  • Last Modified:

Adobe Designer/Adobe Reader Compatibility Question (with Data Connection)

I have used Adobe Designer 7.0 to build a simple form to be used by our employees for Accounting classification. Within this form I have several drop down list boxes, some text boxes and a button. I have two data connections, connected using the OLEDB wizard, to an access database I have on a shared network drive. I pulled some code from the net that uses both Javascript and FormCalc to manipulate the data on the screen. On my desktop, where I have the full Adobe suite, the form functions as expected. The drop down boxes populate and the button will refresh the text boxes based on the list box selection. On another user's machine, I set up the ODBC data source, and tried opening the PDF document. The form opens fine (the Reader is 7.0) and populates the drop down boxes with data from my Access tables. However, when I click on the refresh button (which uses the FormCalc script), I get a scripting error:

Error: accessor '$sourceSet.DataConnection2.#command.query.CommandType' is unknown.

The full formcalc code block is as follows:

----- form1.#subform[0].Button1::click - (FormCalc, client) ----------------------------------------

if (Len(Ltrim(Rtrim(SelectField.rawValue))) > 0) then
      $sourceSet.DataConnection2.#command.query.commandType = "text"
      $sourceSet.DataConnection2.#command.query.select.nodes.item(0).value = Concat("Select * from none_AP_VENDOR Where NAME_KEY = ", "'", Ltrim(Rtrim(SelectField.rawValue)) ,"'")

      $sourceSet.DataConnection3.#command.query.commandType = "text"
                $sourceSet.DataConnection3.#command.query.select.nodes.item(0).value = Concat("Select * from none_GL_TRIAL_ACCT Where NAME_OF_ACCOUNT = ", "'", Ltrim(Rtrim(AccountDesc.rawValue)) ,"'")


Is this type of code supported by the Reader? Any help or guidance would be appreciated.


1 Solution

Acrobat Reader by default has certain extensions disabled reducing the functionality as a free product.
If you need to use the form on several systems and are not ready to purchase standard or pro licenses you may want to look into enabling reader extensions for your form.
The costly option is to purchase a Livecycle server ~$15,000 or verify whether enabling through a third party will accomplish your goal.
Here is the web link regarding LiveCycle Server: http://www.adobe.com/products/server/readerextensions/
Form Router Inc. offers the service of unlocking reader extensions without the server requirements:
They charge $150 per page and a $100 setup fee.
If the extension is the problem you may be able to use their service. Verify in advance that the function in error can be enabled in the reader through this service.

Good Luck
RandallKWrightAuthor Commented:
Thanks for the response. I had pretty much come to the conclusion that there was just enough functionality NOT available thru the reader to make my life difficult!!! We're a pretty small company right now, so I was able to come up with an alternate solution that works for us. I'll research the links you provided and use them for future reference. Thank you again.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now