update - logged a call with IBM about this one - they asked me to install SQL Server Native Client 2012 which i did but it strangely didn’t seem to change any of the ODBC setting or add anything into the registry.
I ran te installer again - this time no errors but at the end of the install, when it’s starting the services - i get another ODBC error - again for SQL Server Native Client 11.0 - the install is stuck.
SO - i change the now again changed ODBC registry entry’s back to ODBC Driver 13 for SQL Server, and luckily the installer finishes and the upgrade has worked (of course i had to run the ibm bigfix administration tool to update the DB and also then run C:\Program Files (x86)\BigFix Enterprise\BES Server\BESReportsData> InitializeBESReportsDB.exe to update the webreports db). but that installer still has a bug. in the meantime 9.5.10 has been released. i’m wondering if the bug is still there? Anyone with a remote DB done the upgrade yet?