Skip to main content
KomputerMan_com-L7dcfe
Inspiring
Sep 21, 2016 4:45 PM UTC
Answered

Connect to Oracle Database

     Is there any "good" documentation out there showing me what I have to do, step by step would be nice, to configure CF to work with an Oracle DB?

I've never worked with Oracle before so I'm not familiar with any of their ODBC drivers or how to configure them.  One would think there is some sort of tutorial out there somewhere to do this!  Getting frustrated...  😠

This topic is closed to new replies. Start a new post to keep the conversation going.
Priyank Shrivastava.
Priyank Shrivastava.Correct answer
Inspiring
Sep 21, 2016 6:04 PM UTC

Hi,

ColdFusion Standard doesn't have Oracle driver, you have to use Oracle thin driver which supports Oracle version that you are running in your environment.

1. Download the thin driver and copy it in \ColdFusion9\lib.

2. Restart ColdFusion service so it will load the driver class.

3. Login to CF Admin>Datasources> Add a new DB>Select Other from drop down.

4. URL =jdbc:oracle:thin:@//{HostName}:<port>/SID="{SID_NAME}"

5. Driver Class: oracle.jdbc.driver.OracleDriver

Hope this helps.

Thanks,

Priyank

Thanks, Priyank Shrivastava
View reply

5 replies

KomputerMan_com-L7dcfeAuthor
Inspiring
Sep 21, 2016 5:47 PM UTC

My bad...   CF 9 Standard edition.  I'm hopeful the agency I work for will upgrade one of these days but till then this is what I got to deal with.

Translate
Priyank Shrivastava.
Priyank Shrivastava.Correct answer
Inspiring
Sep 21, 2016 6:04 PM UTC

Hi,

ColdFusion Standard doesn't have Oracle driver, you have to use Oracle thin driver which supports Oracle version that you are running in your environment.

1. Download the thin driver and copy it in \ColdFusion9\lib.

2. Restart ColdFusion service so it will load the driver class.

3. Login to CF Admin>Datasources> Add a new DB>Select Other from drop down.

4. URL =jdbc:oracle:thin:@//{HostName}:<port>/SID="{SID_NAME}"

5. Driver Class: oracle.jdbc.driver.OracleDriver

Hope this helps.

Thanks,

Priyank

Translate
Thanks, Priyank Shrivastava
    KomputerMan_com-L7dcfeAuthor
    Inspiring
    Sep 21, 2016 7:05 PM UTC

    Just that EZ huh?  OK...  I'll give it a go and let ya know tomorrow when I can restart the service.  Thanks!

    Translate
    Priyank Shrivastava.
    Priyank Shrivastava.
    Inspiring
    Sep 21, 2016 4:53 PM UTC

    Hi,

    Could you please let me know if you are running Enterprise edition or Standard.

    Thanks,

    Priyank

    Translate
    Thanks, Priyank Shrivastava
    WolfShade
    WolfShade
    Legend
    Sep 21, 2016 4:52 PM UTC

    You don't mention what version of CF you are referring to.  Is this CF10, 11, 2016?

    I'm running CF10, and when I click on Driver, Oracle is near the bottom of the select list.

    V/r,

    ^_^

    Translate
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices