Home / server / Questions / 1086129
Accepted
peter cooke
Asked: 2021-12-13 19:14:41 +0800 CST

windows bat needs to determine the version of the msql odbc library

  • 772

Hi I need to build a bat possible power shell on standard windows 10 instance.
I need a programmatic way to set an environment variable with the version string of the latest msodbcsql library at https://packages.microsoft.com/rhel/8/prod/

the current latest version is https://packages.microsoft.com/rhel/8/prod/msodbcsql17-17.8.1.2-1.x86_64.rpm but this changes every couple of months.

I thought of something like the following PSEUDO CODE

set msodbcver=Invoke-WebRequest -Uri  https://packages.microsoft.com/rhel/8/prod/ | grep msodbcsq | sort

but my windows system cannot find Invoke-WebRequest in either cmd.exe or powershell. Yes I am a unix guy trying to figure out equivilent MS scripting

windows powershell windows-batch

1 Answers

  1. Best Answer

    If you are running a modern version of Powershell (v3 or above) you can do this with:

    $env:msodbcver = (Invoke-WebRequest -Uri https://packages.microsoft.com/rhel/8/prod/).Links.Href | Select-string msodbcsq | Sort-Object -Descending | Select-Object -First 1
    • 1