You'll have to use the PowerBuilder ODBC database connection type.

Install a version of the Microsoft ODBC Driver for SQL Server that is compatible with the version of SQL Server you have. The compatibility chart is here:

https://learn.microsoft.com/en-us/sql/connect/odbc/windows/system-requirements-installation-and-driver-files?view=sql-server-ver16

SQL Server 2019 is compatible with version 18.3 which you can download here:

https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16

The x64 / x32 version of the installer refers to the bitness of Windows, not the applications.

Hi ;

Yes, but ...

1. In SS 2019 and higher, Microsoft clanged the DB Client standard to use the new " "MSOLEDBSQL" DB client for SS DML interactions. This replaced the old SNI DB client used in older SS's (ie: SS 2012) as found in PB 12.6. Microsoft has now fully deprecated the SNI driver but you can still install that old SS DB Driver & use it for PB 12.6 for SS2019 interactions. However, the SNI DB client only has the mentality of supporting SS 2012 functionality. Thus, the new SS 2016, SS2019 (and higher SS versions) features could not be used.
2. The ODBC DB Client for SS 2019 was updated but PB IDE / Apps do not call it directly. The PB runtime loads an ODBC "Interface" driver that then talks to the real ODBC middle-ware layer (where the SS2019 DB Client actually resides). So the PB 12.6 ODBC Interface driver will have the same restrictions as in #1 DML functionality wise.
3. The ADO.net DB Client for SS 2019 was updated but PB IDE / Apps do not call it directly. The PB runtime loads an ADO.net "Interface" driver that then talks to the real ADO.net middle-ware layer (where the SS2019 ADO DB Client resides). So the PB 12.6 ADO Interface driver will have the same restrictions as in #1 DML functionality wise.
4. Microsoft replaced the SNI DB Client driver in SS 2019 with a completely new DB Client called " "MSOLEDBSQL". Unfortunately, PB 12.6 has no interface to that now new MS SS standard DB client driver. Only Appeon PB 2022 does. So that option is not available to you in PB 12.6 and thus, the same restrictions as in #1 DML functionality wise.

HTH

Regards ... Chris