8.8

Table Of Contents
Settings
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 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)
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 PReS Suite is 32-bit
and cannot access the 64-bit data sources. In order to create an ODBCconnection visible
by PReS, 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
PReS 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.
Page 738