Select the Connection Type 'ODBC Connections' and the Odbc Driver Type of 'Microsoft ODBC for Oracle'.
The Server is the host name or IP address of the machine running Oracle.
Uid is your username, and Pwd your password.
Missing IBM DB2 Provider for .NET 4.0
If you attempt to use the IBM DB2 Provider for .NET 4.0 and you don't have it installed, you will receive an error directing you to the driver download location.
The message will say:
The DB2 .NET Data Provider cannot be found. Please ensure you have the driver installed and configured correctly.
Contact your system administrator or you can download directly from here:
http://www.ibm.com/support/docview.wss?uid=swg21385217
This driver must be installed on the server where the DataConnect Runtime service is installed.
After installing this driver, you may need to reboot the server.