Connect to Oracle Database

Engaged ,
Sep 21, 2016 Sep 21, 2016

Copy link to clipboard

Copied

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

Views

836

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct Answer

Adobe Employee , Sep 21, 2016 Sep 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.OracleDriverHope this helps.Thanks,Priyank

Likes

Translate

Translate
LEGEND ,
Sep 21, 2016 Sep 21, 2016

Copy link to clipboard

Copied

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,

^_^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Sep 21, 2016 Sep 21, 2016

Copy link to clipboard

Copied

Hi,

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

Thanks,

Priyank

Thanks,
Priyank Shrivastava

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Sep 21, 2016 Sep 21, 2016

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Sep 21, 2016 Sep 21, 2016

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Sep 21, 2016 Sep 21, 2016

Copy link to clipboard

Copied

LATEST

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines