a customer is going to update their Oracle and announced they are setting SQLNET.ALLOWED_LOGON_VERSION_SERVER to 12. This means the client driver has to be version 11.2 or later.
In previous discussions I always sad simply use a recent Thin driver and everything's fine.
I found this query that says which client you are on
SELECT DISTINCT s.client_version FROM v$session_connect_info s WHERE s.sid = SYS_CONTEXT('USERENV', 'SID')
I run it from a cfquery tag in a ColdFusion script and everything is fine when I use a recent Thin driver, they report back version 12 or 18 or something.
I also ran it in ColdFusion 2016 with Updater 10 installed. I connected to Oracle using the built in driver (Developer Edition/Enterprise). I got 126.96.36.199.0 as my client version. This is lower than the driver recommended to connect to Oracle 12 with (11.2).
Does anyone have a recent Oracle running and set ALLOWED_LOGON_VERSION_SERVER to a high value (at least 12)? Does this work with the driver ColdFusion 2016 comes with?