7.6

Table Of Contents
The ODBCSettings dialog
The following settings are available:
l Name:Click to displays and choose from a drop-down of each DSN(Data Source Name)available on the system,
along with it's source (User DSNor System DSN) and the driver it uses (database type).
l Type:Click to display a drop-down of supported database types. This must correspond to the database type of the
DSNchosen in the previous option.
l Username:If the database is secured with a username and password, enter the username here.
l Password:If the database is secured with a username and password, enter the password here.
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)
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 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 Plan-
etPress and the MySQLserver.
l MySQL's performance has been slower than SQLServer and SQLServer Express during our tests.
l By default, MySQLis configured not to allow any SQLrequest larger than 16 megs.
The PlanetPress Suite Workflow Tools Configuration Program