8.7

Table Of Contents
l Password:If the database is secured with a user name and password, enter the
password here.
Note
In order for the database connection to be functional, you must ensure that the database
Type correspond exactly to the one used by the DSN, and is part of the supported
database types.
Database Considerations (ODBC)
Technical
On 64-bit operating systems, the ODBCData 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 ODBCconnection
visible by PlanetPress, you will need to access the 32-bit version of the ODBCmanager,
available in C:\Windows\SysWOW64\odbcad32.exe .
The following considerations should be kept in mind while working with ODBCDatabases in
PlanetPress Suite.
l All databases
l
User Rights:During normal operation, Read/Write to tables should be sufficient.
However, during the initial setup, the Create/Drop tables rights is necessary.
l Minimum 100MBof database size is required as a minimum, but the space
requirement depends on the implementation. The more active documents in the
database, the more space is used - note that this progression is rather linear.
l Regular database maintenance is required, such as database compacting, is
required by a system administrator.
l It is recommended to create an ITprocess that backs up the database regularly.
l The recommended ideal setup is a dedicated SQLServer PC, accessed by
PlanetPress Workflow through an ODBCconnection on the local network.
Page 698