2020.1

l
Type: Click to display a drop-down of supported database types. This must correspond to
the database type of the DSN chosen in the previous option.
l
user name: If the database is secured with a user name and password, enter the user
name here.
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)
Note
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,
available in C:\Windows\SysWOW64\odbcad32.exe .
The following considerations should be kept in mind while working with ODBC Databases 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.
Page 763