Testing connection fails during DB Type Profile configuration

In PowerServer Toolkit Configuration, when creating or modifying a DB Type profile after specifying an Oracle database as the data source for the DB Type profile, testing the connection will fail for the profile. However, the data source can be successfully connected in the ODBC Data Source Administrator.

Cause: The ODBC driver used for the data source is not a dedicated driver for connecting to an Oracle database.

Solution: Use either of these drivers for connecting to an Oracle database: Oracle in OraHome920 or Microsoft ODBC for Oracle.