PDA

View Full Version : ODBC Driver 18 for SQL Server



Peter van Mil
26-Mar-2022, 05:02 AM
Accidentally I found the new Microsoft ODBC Driver 18 for SQL Server. Currently this new version isn't recognized by the driver attribute DF_DRIVER_SQLSERVER_CLIENT_VERSION. Not a surprise, because this update is release a month ago. Still it is good when DAW is aware of this.

https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15

Stephen W. Meeley
26-Mar-2022, 08:25 AM
Peter,

We are aware of it and are planning to add support, but not for the pending 20.1 release. There is a complicating "breaking change" in that Microsoft has decided that encryption will be on by default. We are already planning on how best to embrace this change, but it's not something we feel comfortable trying to force in at the end of a release cycle.

The good news is that since our SQL driver doesn't yet recognise the ODBC 18 client, it won't try to use it (the driver always attempts to use the highest "known" Microsoft client). The only immediate impact of the ODBC 18 driver is that if it is the only Microsoft client installed on a machine, a known client (ODBC 17 or earlier) must be installed. We don't expect that condition to impact many people in the short term.

Peter van Mil
27-Mar-2022, 05:12 AM
Hi Stephen,

Thanks for the clarification.