Question
ColdFusion 2016 Enterprise: dB Connection to Oracle 12 via Service Name (no SID)
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?
ORA-12505
Connection refused, the specified SID (XXXXXX) was not recognized by the
Oracle server.
