Stefan Cameron on Forms
Building intelligent forms using Adobe LiveCycle Designer

ADBC Now Disabled by Default

Ever since the release of Acrobat 8.0 last November and, more recently, the Acrobat 7.0.9 update (for those still using Acrobat 7.x), I’ve had a few inquires about forms using ADBC (Acrobat DataBase Connectivity) that suddenly stop working.

The source of the problem is likely the fact that Acrobat 7.0.9 and 8.0 now disable ADBC by default, regardless of whether you were using it prior to the update or not. The reason behind this change is that ADBC poses a sizeable security risk as it doesn’t provide any mechanism to protect the databases it accesses from malicious use.

Although I wish the installation programs for Acrobat 7.0.9 and 8.0 would’ve warned users that ADBC was being disabled and provided them with information on re-enabling it rather than silently disabling it and causing people a lot of grief, I think disabling ADBC when it isn’t needed is much safer than leaving it enabled in case you ever need it.

Alternatively, you may choose to migrate to ODBC data connections in XFA forms (which you can save as PDF files for use in Acrobat). Since these are still enabled in Acrobat 7.0.9/8.0 and also make use of DSNs to locate and access databases, the migration should be relatively seamless to the people using your forms. Please note, however, that exposing a database to any type of audience always creates a certain security risk which should be assessed and addressed accordingly. You might consider creating a web service to act as the bridge between the database and your form (where your form retrieves data from and pushes data into a database via methods provided by a web service), thereby restricting access to your database’s structure and data.

For those needing to (re-)enable ADBC, the Acrobat 8 SDK Readme contains information on how to do that. For your convenience, here is the excerpt which contains the instructions (as they were stated on December 13, 2006):

ADBC Support

Acrobat Database Connectivity (ADBC) can now be turned on and off via a registry setting. To activate ADBC, create a registry key of type DWORD with the name “bJSEnable” and a value of “true” (1) in the following location:

HKEY_CURRENT_USER\SOFTWARE\Adobe\Adobe Acrobat\8.0\ADBC

This activates ADBC in Acrobat 8.0. In previous releases of Acrobat, ADBC was active by default. In Acrobat 8.0, this setting has been changed to require user intervention to activate ADBC because most users do not want to have ADBC accessible from PDF.

Windows shell command to activate ADBC:

reg add “HKEY_CURRENT_USER\SOFTWARE\Adobe\Adobe Acrobat\8.0\ADBC” /v bJSEnable /t REG_DWORD /d 1

For Acrobat 7.0.9 users, simply change all instances of "8.0" to "7.0" in the above instructions.

Please note that since ADBC poses a security risk (as outlined earlier), Adobe does not recommend modifying the registry to re-enable this feature. Also note that ADBC is still only available via Acrobat Standard or Professional and on Windows only. The Adobe Reader does not have the ability to use ADBC.


Posted by Stefan Cameron on March 7th, 2007
Filed under Acrobat,Scripting
Both comments and pings are currently closed.

3 Responses to “ADBC Now Disabled by Default”

  1. Carm Scaffidi on March 14th, 2007

    Stefan, thank you for this valuable information. I just stumbled on this problem when I tried using a Rights Enabled PDF (XFA form) with Adobe Reader 8.
    I was stumped at why the Rights Enabled PDF (XFA form) would work in Acrobat 7.x or Acrobat 8.x but it would not work with Adobe Reader 7.0.9 or 8.x.
    If you can would you please confirm that its not possible to use Adobe Reader and a Rights Enabled PDF to access a DSN to locate and access databases?
    /Carm Scaffidi
    A very happy Adobe (previously employed at Adobe Ottawa) Software user and Adobe Product promoter :)

  2. Stefan Cameron on March 19th, 2007

    Carm,

    You’re welcome. I’m glad you found this article useful.

    Since the Adobe Reader does not support ADBC, there’s nothing you can do to the PDF (i.e. extending/rights-enabling) that will let it use ADBC in Reader.

    The same is not true for ODBC data connections to databases in XFA forms saved as PDF: Adobe Reader supports XFA data connections however you are required to reader-extend (i.e. rights-enable) the PDF in that case. The PDF does not need to be extended if it’s used in Acrobat Standard or Professional.

  3. ASIF on January 19th, 2009

    Sir i edit my regisertry but ADBC is not enable why?