Update: Security hotfixes released for ODBC and OLE DB drivers for SQL Server

pmandad 

1. Ubuntu 24.04 support hasn't been officially added to the ODBC driver, yet. However, until it is, you can probably try the 23.04 package and see if it works for you. Instead of `curl https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list`, try `curl https://packages.microsoft.com/config/ubuntu/23.04/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list`.

Regards,

David

Hello DavidEngelMS 

Not sure if this an issue related to this new change but I am getting the following error when I am trying to install ODBC 18 driver with ubuntu 24.04.

The repository 'https://packages.microsoft.com/ubuntu/24.04/prod noble InRelease' is not signed.

I am following the steps mentioned in https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16&tabs=alpine18-install%2Calpine17-install%2Cdebian8-install%2Credhat7-13-install%2Crhel7-offline#18. 

If this is not the right place to post this, Can you please provide guidance on where I can raise this issue ? 

Thank you in advance

_xblane 

What are the OS version and platform (x64/x86/arm64) of systems that aren't offering the update? Are you sure they have opted in to Microsoft Update (as opposed to just Windows Update)? What are the registry values for PatchLevel and LCID under HKLM\Software\Microsoft\Microsoft OLE DB Driver for SQL Server\CurrentVersion and HKLM\Software\Microsoft\Microsoft OLE DB Driver 19 for SQL Server\CurrentVersion?

Hi DavidEngelMS 

We are experiencing similar symptoms, ie patches not being detected despite the appropriate registry keys being in place as described above.

Primarily we are seeing this with OLE DB Driver (7 / 53 hosts detecting the OLE DB driver update)

We've tried msiexec /faumv msoledbsql.msi just in case, but we already had registry values as described.

Any other thoughts regarding troubleshooting?

Cheers

Brian

Jay_Patel225 

1. Make sure you have enabled Microsoft Update (Receive updates from other Microsoft products). 
2. For ODBC 17, ensure the following registry entries exist:
   1. LCID (REG_DWORD) under HKLM\Software\Microsoft\Microsoft ODBC Driver 17 for SQL Server
   2. PatchLevel (REG_SZ) under HKLM\Software\Microsoft\Microsoft ODBC Driver 17 for SQL Server\CurrentVersion
      PatchLevel should be greater than 17.0.0.0 but less than the version of the update (17.10.6.1).
3. For ODBC 18, ensure the following registry entries exist:
   1. LCID (REG_DWORD) under HKLM\Software\Microsoft\Microsoft ODBC Driver 18 for SQL Server
   2. PatchLevel (REG_SZ) under HKLM\Software\Microsoft\Microsoft ODBC Driver 18 for SQL Server\CurrentVersion
      PatchLevel should be > 18.0.0.0 but less than the version of the update (18.3.3.1).
4. For OLE DB 18, ensure the following registry entries exist:
   1. LCID (REG_DWORD) under HKLM\Software\Microsoft\Microsoft OLE DB Driver for SQL Server\CurrentVersion
   2. PatchLevel (REG_SZ) under HKLM\Software\Microsoft\Microsoft OLE DB Driver for SQL Server\CurrentVersion
      PatchLevel should be > 18.0.0.0 but less than the version of the update (18.7.2.0).
5. For OLE DB 19, ensure the following registry entries exist:
   1. LCID (REG_DWORD) under HKLM\Software\Microsoft\Microsoft OLE DB Driver 19 for SQL Server\CurrentVersion
   2. PatchLevel (REG_SZ) under HKLM\Software\Microsoft\Microsoft OLE DB Driver 19 for SQL Server\CurrentVersion
      PatchLevel should be > 19.0.0.0 but less than the version of the update (19.3.3.0).

If the registry entries are missing, rather than add them manually, I would reinstall the drivers to ensure future updates are correctly offered. If a regular install doesn't do it, you can try additional msiexec options to force the installer to write out all files and settings. For example msiexec /faumv msodbcsql.msi

Regards,

David

Hello DavidEngelMS , Thank you for the informative article. We have noticed that half of the servers didn't receive an ODBC and OLE update through Microsoft Automatic Windows Update. We have double check the below path to make sure the ODBC or OLE Drivers are installed and properly registered in order for Windows Update to detect it properly. Is there any additional registry settings required in order to properly receive the updates through Windows Update? 

• Microsoft ODBC Driver 17 for SQL Server - %Windir%\system32\msodbcsql17.dll
• Microsoft ODBC Driver 18 for SQL Server - %Windir%\system32\msodbcsql18.dll
• Microsoft OLE DB Driver 18 for SQL Server - %Windir%\system32\msoledbsql.dll
• Microsoft OLE DB Driver 19 for SQL Server - %Windir%\system32\msodlebsql19.dll