Today I cannot open the tables view in PB21.  The reason, somehow some update installed version 19 on my computer.  If anyone starts to experience weirdness while working in the database view check for that.  I thought my drivers were corrupt and tried to reinstall version 18.  Was told a newer version existed.  Now going through the process of removing 19 to reinstall 18.  

Hi, Galina -

Make sure you do NOT try to use the current MSOLEDBSQL client from Microsoft (version 19), as this version of the MSO client does not work with PB and will not be supported until PB 2022. Instead, use version 18.6.3:

   https://docs.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?view=sql-server-ver16#previous-releases

Also important: You want the 32-bit (x86) installation in order to be able to use the MSO client from within the PB IDE. Only if you will be deploying your PB application(s) as 64-bit do you want to (also) install the 64-bit version.

When deploying the MSO client along with your PB app, please know that you must use the Microsoft-supplied msi to perform the installation... simply copying the MSO-related files will not be successful.

There is a way to perform the MSO installation silently, documented here:

   https://docs.microsoft.com/en-us/sql/connect/oledb/applications/installing-oledb-driver-for-sql-server?view=sql-server-ver16

Good luck!