Oracle JDBC Drivers for CF10 on Win Server 2008 R2 64bit

Question

I'm setting up CF10 on Windows Server 2008 R2 64bit. Trying to add a Datasource which is on Oracle 9i server.  I recall, from doing this a few years ago, that the datasource first had to be setup on the web server, then it could be selected in the CF Administrator.  So, I accessed the Oracle Client download page which has versions 10.2 to 11.2. I wonder which version of the Client will work with 9i and CF10. Any help?  BTW, my guess is that it is not unusual to Install CF10 in an environment like this.  How should I procede? Thanks.

Anonymous · Answer

I am now up and running. Several tips were found on both Adobe and Oracle sites that were helpful. Here is a brief summary of the steps:

Step 1, download* the Oracle Database11G release 2 Client for Microsoft Windows x64. (not the Instant Client). Follow the instructions provided on the download site. Select just the items you need from the custom install form.

Step 2, add your datasources using the Oracle Net Configuration Assistant**. Select Local Net Service Name Config. Follow the prompts, answer the questions.

Step 3, add your datasources on Windows 2008 Server with Administrative Tools Datasources. Similar to step 2.

Step 4, in CF10 Administrator set up your datasources. The first thing to do is set your Class Path to the location of the jdbc .jar files. When you configured the Oracle installation you specified the location of the files. Go there and look for the\jdbc\lib folder. It contains the jar files for your drivers. Example: C:\\Oracle\home\jdbc\lib\. Now add your datasources. Select Other from the drivers drop-down list. This may be the tricky part. You will need the database information for connecting, such as host name, port, user, password, etc. The connect url will look like: jdbc:oracle:thin@hostname:portnumber:servicename. Class: oracle.jdbc.OracleDriver Name: whatever

* download from: oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

** This utility should be selected as an item to install from step 1.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.