7.3

Table Of Contents
Database Considerations (ODBC)
On 64-bit operating systems, the ODBCData Sources created by the Data Source (ODBC)icon in the Administrative
Tools will not appear here, as PlanetPress Suite is 32-bit and cannot access the 64-bit data sources. In order to create
an ODBCconnection visible by PlanetPress, you will need to access the 32-bit version of the ODBCmanager, avail-
able in C:\Windows\SysWOW64\odbcad32.exe .
The following considerations should be kept in mind while working with ODBCDatabases in PlanetPress Suite.
l Microsoft Access
l Database file (mdb)must be local to the PlanetPress Workflow computer. It cannot be located on a network
drive or another server.
l Total database size is limited to 4GBof 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 Plan-
etPress and the MySQLserver.
l MySQL's performance has been slower than SQLServer and SQLServer Express during our tests.
l By default, MySQLis configured not to allow any SQLrequest 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 Database can be in any location, but performance will depend on the speed of the connection between Plan-
etPress Production and the SQLserver.
l In the event where 2 requests are made simultaneously on the same record, SQLServer will drop the most com-
plex 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 Plan-
etPress 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 Cap-
ture License.
This window has the following options and controls:
l Top Toolbar:
l Read PGCFile:Click to display a file open dialog. Browse to an existing PGCfile, and open it. PlanetPress Cap-
ture will read the serial number from the PGCfile and register the pen.
l Print Pen Activation File:Click to print a page containing a special pattern. Any pen that writes on this pat-
tern and is then docked will be registered in the database.
l Save Pen Data into Database:Once all your pens are entered in this window, click to save the list of pens
in the database.
l Pen Data List: Displays a list of registered pens and those pens you just added.
l Pen ID:The serial number of pen, as written on the Anoto Digital Pen.You can double-click this area to edit the
Pen ID if necessary.
The PlanetPress Suite Workflow Tools Configuration Program
©2010 Objectif Lune Inc - 73 -