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

Posted on 2006-05-12
Last Modified: 2013-12-03
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"
      $ = Concat("Select * from none_AP_VENDOR Where NAME_KEY = ", "'", Ltrim(Rtrim(SelectField.rawValue)) ,"'")

      $sourceSet.DataConnection3.#command.query.commandType = "text"
                $ = 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.


Question by:RandallKWright
    LVL 1

    Accepted 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:
    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

    Author Comment

    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.


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Update 21-May-2015: I temporarily removed the source code to make major changes to the program. Regards, Joe INTRODUCTION This article presents a solution to a question (…
    PaperPort is a popular document imaging/management product from Nuance Communications ( It is in widespread use by both individuals ( and businesses (http:/…
    In this second video of the Xpdf series, we discuss and demonstrate the PDFimages utility, which, in a single command, is able to extract all the images from a PDF file and save each one in a separate image file (PBM, PPM, or JPG). Download and inst…
    In this third video of the Xpdf series, we discuss and demonstrate the PDFtoText utility, which converts PDF files into plain text files. Download and install the software.: You may have already downloaded and installed the Xpdf tools while watching…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now