Problem: When using the encryption/security features of Oracle, CF5 will connect correctly, CF MX will not.
Situation: While the Oracle thin client supports encryption, it does so only when using the JDBC driver manager directly. ColdFusion MX uses the datasource object to connect which doesn’t support the encryption.
Solution: Use Oracles JDBC oci driver, which requires the oci libraries. This driver will pick up the encryption properties from the sqlnet.ora file. Download the driver and libraries from oracle. Use Type other to configure the driver in ColdFusion MX. The class name is oracle.jdbc.driver.OracleDriver and a sample url is jdbc:oracle:oci8:@oracle_server
