let's add "how do I know what architectures of a driver I have installed? There are x86 and x64 versions for all of this. How do we get a complete inventory?
Idea: Throw together a powershell script (that runs on 5.1) which will output a nice report with versions, paths, architectures, dates etc.
This helps a little.
[System.Diagnostics.FileVersionInfo]::GetVersionInfo("C:\Windows\System32\msoledbsql.dll")
[System.Diagnostics.FileVersionInfo]::GetVersionInfo("C:\Windows\System32\msodbcsql17.dll")
[System.Diagnostics.FileVersionInfo]::GetVersionInfo("C:\Windows\System32\msodbcsql18.dll")
[System.Diagnostics.FileVersionInfo]::GetVersionInfo("C:\Windows\System32\msodlebsql19.dll")
[System.Diagnostics.FileVersionInfo]::GetVersionInfo("C:\Windows\SysWow64\msoledbsql.dll")
[System.Diagnostics.FileVersionInfo]::GetVersionInfo("C:\Windows\SysWow64\msodbcsql17.dll")
[System.Diagnostics.FileVersionInfo]::GetVersionInfo("C:\Windows\SysWow64\msodbcsql18.dll")
[System.Diagnostics.FileVersionInfo]::GetVersionInfo("C:\Windows\SysWow64\msodlebsql19.dll")
Microsoft