We are using ADO.

Preview tab, if connection will be successful, will give you script you can use in application for connectivity:

// Profile my.server.ip
SQLCA.DBMS = "ADO.Net"
SQLCA.LogPass = <****************>
SQLCA.LogId = "myloginname"
SQLCA.AutoCommit = False
SQLCA.DBParm = "DataSource='my.server.ip',Database='my_db_name',Namespace='System.Data.SqlClient',PROVIDERSTRING='TrustServerCertificate=true;Encrypt=true'"

Hi, Benjamin - 

I'm not sure I understand your question. There are several PB/SQL Server drivers to choose from, all listed in the Database Profiles window: ADO.Net, MSOLEDBSQL (new in PB 2019 R3), ODBC, OLE DB, and SNC (deprecated by Microsoft, but it continues to work so far). Select the driver you wish to use by clicking on it (MSOLEDBSQL is highlighted in the screen shot you attached in your post), then click the "New..." button.

This opens another dialog window containing several tabs: For example:

You fill in the information as needed for your SQL Server installation... your SQL Server DBA can probably help you, if needed). The "Preview" tab will show you the transaction object property settings based on the information you have supplied on the other tabs, and it also has a "Test Connection" button that will try to connect to your SQL Server server instance and database.

HTH

Regards, John