Problems Integrating Database With Lotus Notes

From HotDocs Wiki

Jump to: navigation, search

Problem

When assembling a template where the fields in the template are mapped to fields in a Lotus Notes database file (.NSF), HotDocs displays an error message that says it is unable to retrieve the data from the database because of "invalid character" errors.

Solution

This problem happens because, by default, HotDocs encloses delimiting identifiers in SQL statements with quotation marks. However, these quotation marks are not recognized by Lotus Notes. To fix the problem, you can create a registry value that keeps HotDocs from quoting identifiers unless it needs to (because of spaces or other nontypical characters).

To set the registry

  1. Close HotDocs.
  2. In the System Registry, navigate to HKEY_CURRENT_USER\Software\HotDocs\HotDocs\Internal. (For versions of HotDocs prior to 10, go to HKEY_CURRENT_USER\Software\LexisNexis\HotDocs 6\Internal.) If the key Always Quote Identifiers is listed, delete it.
  3. Navigate to HKEY_LOCAL_MACHINE\Software\HotDocs\HotDocs\Internal (or prior to HotDocs 10, go to HKEY_LOCAL_MACHINE\Software\LexisNexis\HotDocs 6\Internal) and create a new String Value named Always Quote Identifiers and set its value to False.
  4. Restart HotDocs.