7 thoughts

  1. Any idea on how to get CF connected to the DB?
    I got the db up and running, but am unable to connect with CF, and resources are scarce at best.

  2. Steve – I was able to get connected using the native drivers. My problem stemmed from the fact that I did not know how to fid out SID of the server. After poking around the Oracle web based amdin, I discovered that the ‘name’ (found under the setting page) should be used for SID in the datasource.

  3. ColdFusion MX 7.01 release notes state support for Oracle 10g and ships Macromedia driver version 3.3 which is the same as CFMX 7.0. However, you may want to consider using the Oracle JDBC driver matching the database version, especially since there is a 10g Release 2 JDBC driver available from Oracle which seems perfectly paired for the XE release. I’ll look into the question further.

  4. I have not had a chance to just try this but am curious would these instructions work with the standard version of CF or does one need to step up to the enterprise? Was considering maybing trying XE with CF 7.01 std for a small intranet is why I am asking.

  5. I was able to set up an Oracle datsource in CF without installing a new driver. I think I chose Oracle as my driver, then put XE as the SID name. I left the Server field blank and left the Port field as the default 1521. I like the Express Edition of Oracle much better for development here at home because it’s not nearly as big as the full version.
    Cheers,
    Peter

Leave a Reply