2022.2

Table Of Contents
2
Windows NT 4.0 uses NetBIOS over TCP/IP for file and printer sharing, while Windows 2000, Win-
dows XP, and Windows Server 2003 may be configured to use NetBIOS over TCP/IP or SMB over
TCP/IP. The operating system may use additional ports. Refer to the Windows documentation for fur-
ther information.
3
If the No source port range restriction option is checked (recommended), see footnote 1. If the
option is unchecked, the local port will be chosen from a range going from 721 to 731.
4
Contact your DBMS vendor to determine which ports are used by the ODBC driver for accessing a net-
work database.
Known Issues
Microsoft patch causing handling of XLS to fail
Some Windows updates from Microsoft have impacted the handling of XLS sources in PReS\Plan-
etPress Workflow 8.
The Microsoft updates concerned are as follows:
l
KB4041693 for Windows 8.1 and Windows Server 2012 R2
l
KB4041681 for Windows 7 and Windows Server 2008 R2
l
KB4041690 for Windows Server 2012 (no service pack)
Installing these updates may cause the application to fail when attempting to open or load XLS files via
a plugin or in a script. The following error message may appear: Unexpected error from external data-
base driver (1). (Microsoft JET Database Engine)".
Suggested resolution
Uninstall the Microsoft patches and wait for the issue to be fixed in a subsequent Microsoft patch.
Workarounds
l
For the Lookup in Microsoft Excel Documents plugin (found in the Connectors tab of the plugin
bar): Open the original .xls file and save it with the .xlsx format. That will force the Excel Lookup
plugin to switch drivers.
l
For the Database Query plugin (found in the Actions tab of the plugin bar) and when using
Excel/Access in PlanetPress Design: Change the ODBC driver used for Excel files from JET to
ACE (change the Data Source). As an example: in Windows 10: Change the Excel File ODBC
driver from ODBCJT32.dll to ACEODBC.dll. (Naming may vary from versions of the OS but the
basics stay the same.) Important: Before switching from JET to ACE, install the latest MS
Access Database Engine 2016 Redistributable (https://www.microsoft.com/en-us/-
download/details.aspx?id=54920). Otherwise, using ACE in one or more self-replicating pro-
cesses in a Workflow configuration can cause Workflow to crash.
Page 27