In ColdFusion 2018, we have a <cfquery> that performs an INSERT INTO a table. We return the result attribute and check for the GENERATEDKEY. From one environment, the GENERATEDKEY is returned in the result struct. From another environment (on a different server), pointing to the same SQL Server DB with the same datasource connection settings, the record is inserted but GENERATEDKEY is not returned in the result struct.
Given that both environments point to the same server, DB, and table and use the same datasource settings and have the latest ColdFusion update installed, I'm guessing (from lots of Googling) that maybe the faulty environment may have an out-of-date JDBC driver for SQL Server.
Is there a way to check the version of the JDBC driver for SQL Server, so I can compare them in the 2 environments? And how do I update that, if necessary?