[Bug]: MicrosoftODBCDriverForSQLServer & MicrosoftOLEDBDriverForSQLServer not offering latest versions

[AScott-WWF]

What happened?

Get-EvergreenApp MicrosoftODBCDriverForSQLServer is currently returning v18.3.1.1, where as the latest version v18.3.2.0 was released during this months patch Tuesday (10th October 2023)
https://learn.microsoft.com/en-us/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view=sql-server-ver16

The same issue is occuring with Get-EvergreenApp MicrosoftOLEDBDriverForSQLServer is currently returning v19.3.1.0, where as the latest version v19.3.2.0 was released during this months patch Tuesday (10th October 2023)
https://learn.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?view=sql-server-ver16

I can only assume the update source Evergreen relies on has not been updated? (thanks Microsoft! (facepalm))

Version

2310.868

What PowerShell edition/s are you running Evergreen on?

PowerShell Core, Windows PowerShell

Which operating system/s are you running Evergreen on?

Windows 10+

Have you reviewed the documentation?

• Troubleshooting at: https://stealthpuppy.com/evergreen/troubleshoot/
• Known issues at: https://stealthpuppy.com/evergreen/issues/

Verbose output

Get-EvergreenApp MicrosoftOLEDBDriverForSQLServer -Verbose
VERBOSE: Function path: C:\Program Files\WindowsPowerShell\Modules\Evergreen\2310.868\Apps\Get-MicrosoftOLEDBDriverForSQLServer.ps1
VERBOSE: Function exists: C:\Program Files\WindowsPowerShell\Modules\Evergreen\2310.868\Apps\Get-MicrosoftOLEDBDriverForSQLServer.ps1.
VERBOSE: Dot sourcing: C:\Program Files\WindowsPowerShell\Modules\Evergreen\2310.868\Apps\Get-MicrosoftOLEDBDriverForSQLServer.ps1.
VERBOSE: Get-FunctionResource: read application resource strings from [C:\Program Files\WindowsPowerShell\Modules\Evergreen\2310.868\Manifests\MicrosoftOLEDBDriverForSQLServer.json]
VERBOSE: Calling: Get-MicrosoftOLEDBDriverForSQLServer.
VERBOSE: Resolve-SystemNetWebRequest: Attempting to resolve: https://go.microsoft.com/fwlink/?linkid=2238602.
VERBOSE: Resolve-SystemNetWebRequest: Resolved to: [https://download.microsoft.com/download/f/1/3/f13ce329-0835-44e7-b110-44decd29b0ad/en-US/19.3.1.0/x64/msoledbsql.msi].
VERBOSE: Get-FileType: found extension: [msi]
VERBOSE: Resolve-SystemNetWebRequest: Attempting to resolve: https://go.microsoft.com/fwlink/?linkid=2238512.
VERBOSE: Resolve-SystemNetWebRequest: Resolved to: [https://download.microsoft.com/download/f/1/3/f13ce329-0835-44e7-b110-44decd29b0ad/en-US/19.3.1.0/x86/msoledbsql.msi].
VERBOSE: Get-FileType: found extension: [msi]
VERBOSE: Resolve-SystemNetWebRequest: Attempting to resolve: https://go.microsoft.com/fwlink/?linkid=2238411.
VERBOSE: Resolve-SystemNetWebRequest: Resolved to: [https://download.microsoft.com/download/f/1/3/f13ce329-0835-44e7-b110-44decd29b0ad/en-US/19.3.1.0/arm64/msoledbsql.msi].
VERBOSE: Get-FileType: found extension: [msi]

Version      : 19.3.1.0
Date         : 14/06/2023 18:26:40
Size         : 4993024
Architecture : x64
Type         : msi
URI          : https://download.microsoft.com/download/f/1/3/f13ce329-0835-44e7-b110-44decd29b0ad/en-US/19.3.1.0/x64/msoledbsql.msi

Version      : 19.3.1.0
Date         : 14/06/2023 18:26:41
Size         : 2850816
Architecture : x86
Type         : msi
URI          : https://download.microsoft.com/download/f/1/3/f13ce329-0835-44e7-b110-44decd29b0ad/en-US/19.3.1.0/x86/msoledbsql.msi

Version      : 19.3.1.0
Date         : 14/06/2023 18:26:36
Size         : 3026944
Architecture : ARM64
Type         : msi
URI          : https://download.microsoft.com/download/f/1/3/f13ce329-0835-44e7-b110-44decd29b0ad/en-US/19.3.1.0/arm64/msoledbsql.msi

[aaronparker]

Correct. We're limited by what MS is providing via the download URL

[GMichu]

@aaronparker is it the same reason MicrosoftSsms is offered in very old version?
E: My bad it shows old version number but downloads the latest it seems

[aaronparker]

With MicrosoftSsms the display version and actual product version are different. I'd love to be able to explain why.

[aaronparker]

For these apps, if we can find an evergreen URL that always points to the latest version, we should be able to fix this issue.

I can see on the releases page that the go.microsoft.com/fwlink link changes with each release.

[AScott-WWF]

Without getting too off subject with SSMS, I think when downloading the very latest Microsoft SSMS (v19.1) the build and app version are the same (Finally - Thank you Microsoft!):
19.1 (Build: 19.1.56.0)

(Or at least the Major and Minor version parts)

[AScott-WWF]

Returning to the original issue here,
It appears that with each version release Microsoft change the 'evergreen' urls for these downloads, therefore I believe the quick fix is to update the URLs held in each of the EverGreen manifest files (Until Microsoft do this properly and store the download urls in a json file that can be downloaded / interrogated).
So, for the Microsoft OLE DB Driver For SQL Server manifest (\Manifests\MicrosoftOLEDBDriverForSQLServer.json) - this should be updated from (lines 10 to 12) to:

                "https://go.microsoft.com/fwlink/?linkid=2248728",
                "https://go.microsoft.com/fwlink/?linkid=2249102",
                "https://go.microsoft.com/fwlink/?linkid=2249103"

This will ensure that the latest current version 19.3.2 (as of 22nd Jan 2024) is served by EverGreen

and for the Microsoft ODBC Driver For SQL Server manifest (\Manifests\MicrosoftODBCDriverForSQLServer.json) - this should be updated from (lines 10 to 12) to:

                "https://go.microsoft.com/fwlink/?linkid=2249006",
                "https://go.microsoft.com/fwlink/?linkid=2249005",
                "https://go.microsoft.com/fwlink/?linkid=2248720"

This will ensure that the latest current version 18.3.2.1 (as of 22nd Jan 2024) is served by EverGreen

[AScott-WWF]

I believe this issue is now resolved (for now!)
Well until Microsoft release newer versions and the 'Evergreen' urls change again

[AScott-WWF]

New versions released today (Security updates for April 2024 Patch Tuesday release) for both Microsoft OLE DB Driver For SQL Server and Microsoft ODBC Driver For SQL Server, I'm guessing the manifest needs the URLs updating again.

Links for the latest versions release notes are here (manifest links found by following each link):
Microsoft OLE DB Driver 19 For SQL Server v19.3.3: https://learn.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?view=sql-server-ver16#1933
Microsoft ODBC Driver 18 For SQL Server v18.3.3: https://learn.microsoft.com/en-us/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view=sql-server-ver16#1833

Plus links for the 'latest' version of the previous channel are here (manifest links found by following each link):
Microsoft OLE DB Driver 18 For SQL Server v18.7.2: https://learn.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?view=sql-server-ver16#1872
Microsoft ODBC Driver 17 For SQL Server v17.1.6: https://learn.microsoft.com/en-us/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view=sql-server-ver16#17106