[Bug]: MicrosoftODBCDriverForSQLServer & MicrosoftOLEDBDriverForSQLServer not offering latest versions about evergreen HOT 8 OPEN

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

from evergreen.

@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

from evergreen.

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

from evergreen.

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.

from evergreen.

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)

from evergreen.

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

from evergreen.

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

from evergreen.

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

from evergreen.