I'm curious what the "common practice" is around which MSSQL driver to use with ACF (2021, specifically). A couple years ago we switched to the Microsoft JDBC driver for SQL Server. We hit some issues and we had read this article about problems with the built in driver. We've been happy with the MS driver up until we applied ColdFusion Update 11 where queries are not returning GENERATEDKEY (previous discussion in this channel). We'll do our own testing of course, but I'm curious if people are generally happy with the built-in driver these days. cc @Marc Funaro

I'm just one data point but we have used the Microsoft SQL Server JDBC driver exclusively going back to somewhere in the CF11 days and have had zero issues with it up to present on CF 2021. We stay current with their releases (e.g., we are testing 12.6.0 released yesterday on our dev servers as of this morning). I will also add that we specifically disable retrieval of autogenerated keys in the configuration of each of our datasources, so if there were issues around that with one of the updates, we dodged those issues.

I've used the built in one for as long as I remember. I did have to do a little finagling connecting to Azure SQL at one point (weird time-out errors that I'm still not sure about, but were almost certainly on Azure's side). At that point we ended up changing out to a different driver but later returned to the native one and it now worked without fail.

Built in ones since I started w CF, long ago, on my own and with several companies with multiple devs. What were the drivers for going with the MS one?