2018.1

Table Of Contents
l The recommended ideal setup is a dedicated SQLServer PC, accessed by PReS
Workflow through an ODBCconnection on the local network.
l
Microsoft Access
l Database file (mdb)must be local to the PReS Workflow computer. It cannot be
located on a network drive or another server.
l Total database size is limited to 4GBof data.
l Total size of a single table is 2GB.
l May be unstable in large implementations.
l
MySQL
l Database can be in any location, but performance will depend on the speed of the
connection between PReS and the MySQLserver.
l MySQL's performance has been slower than SQLServer and SQLServer Express
during our tests.
l By default, MySQLis configured not to allow any SQLrequest larger than 16 megs.
l In the event where 2 requests are made simultaneously on the same record,
MySQLwill queue one of the requests and execute it once the first one is done. In
extremely rare cases this may cause a timeout on very large requests.
l
MSSQL(Microsoft SQLServer)
l All versions of the SQLServer are supported, including all Express versions.
l Database can be in any location, but performance will depend on the speed of the
connection between PReS Production and the SQLserver.
l In the event where 2 requests are made simultaneously on the same record,
SQLServer will drop the most complex request. Resubmitting the PGCfor
processing should resolve this issue. This, however, should happen only rarely.
l When configuring the ODBCconnection, your must use the Microsoft version of the
driver, and not the Native SQLversion of the driver. This is due to a technical
limitation of the native driver that interferes with the PReS Suite database requests.
PlanetPress Capture Pen Management Tool
The Pen Management Tool screen is used to manage the pens that are registered in the
PlanetPress Capture Database. The number of Anoto Digital Pens you may register on this
screen depends on the licenses available within your PlanetPress Capture License.
Page 649