I need to add a dB connection to our new ColdFusion 2016 Enterprise server to an Oracle 12 dB using the service name instead of a SID. If I put the service name into the SID field or leave the SID field blank I get an error. Does anyone know how this is done?
Connection refused, the specified SID (XXXXXX) was not recognized by the
Copy link to clipboard
I got the following info from Adobe which appears to work (so far anyway). I have added it here in the hope that it helps others out whom may run into the same issue.
From: CF Install
Sent: Thursday, March 02, 2017 8:02 AM
To: Carroll, James F
Cc: CF Install
Subject: CF2016-Service name mapping
Navigate to Data
& Services > Datasources > Other and Specify the following settings: