To access Oracle databases, Oracle client software must be accessible via the dynamic link libraries (dll) located under the <oracle_home>\bin folder. The actual location of Oracle installation is usually stored in the ORACLE_HOME environment variable.
If you have installed the 64-bit version of Connect on 64-bit Windows, there are some important differences with respect to defining a Connect Task and running your application.