Unable to Connect Database When Creating FDM Application

Symptoms:

• When attempting to create FDM application it will throw the following error

• Unable to connect to target database, please check the database details or contact Administrator.

Cause: 

• The ORACLE_HOME was set to the 64-bit Oracle Home.

Solution: 

• Remove the ORACLE_HOME setting, it was trying to force the 32-bit Oracle ODBC Driver to use the 64-bit Oracle client and bequeath adapter.
• Remove it (ORACLE_HOME) then will allow to use the 32-bit Oracle client.