Skip to main content
K
KomputerMan_com-L7dcfe
Inspiring
September 21, 2016
Answered

Connect to Oracle Database

  • September 21, 2016
  • 3 replies
  • 1289 views

     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 has been closed for replies.
Correct answer Priyank Shrivastava.

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

3 replies

K
KomputerMan_com-L7dcfeAuthor
Inspiring
September 21, 2016

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.

Priyank Shrivastava.
Community Manager
Priyank Shrivastava.Community ManagerCorrect answer
Community Manager
September 21, 2016

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
    K
    KomputerMan_com-L7dcfeAuthor
    Inspiring
    September 21, 2016

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

    Priyank Shrivastava.
    Community Manager
    Priyank Shrivastava.Community Manager
    Community Manager
    September 21, 2016

    Hi,

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

    Thanks,

    Priyank

    Thanks, Priyank Shrivastava
    WolfShade
    WolfShade
    Legend
    September 21, 2016

    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,

    ^_^

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