If you need to connect to an Oracle database from Coldfusion 9 the following are some recommendations on how to configure your connection.
1. Using Oracle JDBC with OID
If you choose to use the Oracle JDBC driver you will need to specify the "Other" Data Source when configuring Coldfusion via CFADMIN
It is not possible to specify more than one OID ldap server.
You'll also need need to disable "Sandbox Security" (it is unknown why this is a problem).
2. Using Macromedia with OID
If you choose to use the built-in Oracle driver you will need to use the Oid Lookup tool to retrieve the servername of the backend database. Please note that if the backend database moves you will need to update your connection information!
