Microsoft OLE DB 18.7.5 cmdline issue

[L.A]

Hi!

The cmdline for the OLE DB install are as follow:
"IACCEPTMSOLEDBSQLLICENSETERMS=YES ADDLOCAL=ALL REBOOT=ReallySuppress /qn"   

But there seems to be a problem with the install, if you use "ADDLOCAL=ALL" it in some way clashes with "IACCEPTMSOLEDBSQLLICENSETERMS=YES" and will throw an 1603 error and exit.
In the MSOLEDB install log it will say that "IACCEPTMSOLEDBSQLLICENSETERMS=YES" must be supplied when "/qn" is used.

If you remove "ADDLOCAL=ALL" it works.

Best regards,

[Michiel (Patch My PC)]

Hi @L.A, thank you for bringing this to our attention! I have forwarded your comments to our application catalog team so they can look into this.

[Dan Gough (Patch My PC)]

Hi - we had the same issue reported by a handful of customers for ODBC several months ago, but we were unable to reproduce it. We resolved it there by using a pre-install script to remove the previous version with IACCEPTMSODBCSQLLICENSETERMS=YES before we install the new version.

I'm unable to reproduce it here either with OLE DB (whether or not I installed the previous version with ADDLOCAL=ALL), but we could potentially resolve the issue with a script in a similar way.

Could you tell us which OS version and language you're running please, just in case that has an impact?

[L.A]

Hi - we had the same issue reported by a handful of customers for ODBC several months ago, but we were unable to reproduce it. We resolved it there by using a pre-install script to remove the previous version with IACCEPTMSODBCSQLLICENSETERMS=YES before we install the new version.

I'm unable to reproduce it here either with OLE DB (whether or not I installed the previous version with ADDLOCAL=ALL), but we could potentially resolve the issue with a script in a similar way.

Could you tell us which OS version and language you're running please, just in case that has an impact?

Hi!

Thanks for getting back. Ye its a very strange problem, as the offical text from MS suggest that the cmdline should be this, as you do it .

We are using Windows 10 22H2 and Windows 11 23H2, Swedish language, i've also been trying it on my own PC which is eng with swedish pack installed ontop of it.

[Dan Gough (Patch My PC)]

Assuming you are looking at the English x64 variant here, you can try adding the following script to uninstall any previous versions before updating:

https://patchmypc.com/scupcatalog/downloads/scripts/Uninstall-Software.ps1

Script arguments:

Code Select Expand

-DisplayName \"Microsoft OLE DB Driver for SQL Server\" -VersionGreaterThan 18 -VersionLessThan 19 -Architecture x64 -HivesToSearch HKLM -WindowsInstaller 1 -AdditionalMSIArguments IACCEPTMSOLEDBSQLLICENSETERMS=YES -UninstallAll
If that makes an improvement for you we'll consider adding it to the catalog - however this update has been out since May and nobody else has reported it so far. Then again only a handful of customers reported the similar issue with the ODBC package that we could no reproduce either, so we haven't yet got to the bottom of this!