Connect to Oracle Database

[KomputerMan_com-L7dcfe]

     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...  😠

[WolfShade]

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,

^_^

[Priyank Shrivastava.]

Hi,

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

Thanks,

Priyank

[KomputerMan_com-L7dcfe]

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. · Accepted solution]

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

[KomputerMan_com-L7dcfe]

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