Priyank, you said "Yes, you can use Oracle thin driver and connection string to connect to ColdFusion standard. I didn't say, you cannot connect Oracle, all I am saying is driver option is not there when you click on drop down."
Why is it so hard to find the details on how to do that? What files do I need to download from Oracle, where do I put them, and then how do I configure the DSN from within CF Server Administrator?
It shouldn't be this hard to do!!!
Hi,
Since it's a 3rd party driver, you don't find it in drop down. Please follow the instructions below.
1. Download the think driver from Oracle's website.
2. You can copy the driver in \ColdFusion\cfusion\lib or ColdFusion\cfusion\wwwroot\WEB-INF\lib
3. Restart ColdFusion service.
4. Login to CFadmin>Datasources>Add Datasource name and from the drop down select as "Other".
5. URL for connecting to Oracle are
a. If you have configured SID, follow the below URL
jdbc:oracle:thin:@//{HOSTNAME}:{PORT}/SID
b. If you have configured service name, follow the below URL
jdbc:oracle:thin:@//{HOSTNAME}:{PORT};servicename={servicename}
6. Driver Class: oracle.jdbc.driver.OracleDriver
7. Enter username and password and Submit.
Hope this helps.
Thanks,
Priyank
AdChoices