Supports Strict encryption for SQL Server

The “Strict” encryption type is added to support TDS 8.0 in SQL
Server 2022.

You can select the Strict
encryption when configuring the SQL Server database connection in the
IDE (PowerServer project painter > Database page > Basic tab > More button > Advanced dialog).

Or specify “encrypt=Strict” in
the Applications.json file in the
compiled Web API > AppConfig
folder (or in the solution > UserExtensions project > AppConfig folder).

{
  "Applications": {
  ......
  },
  "Connections": {
    "Default": {
      "sales": {
        "ConnectionType": "SqlServer",
        ......
        "SecurityOptions": "<span><strong>encrypt=Strict</strong></span>",
        ......
      }
    }
  }
}

{

"Applications": {

......

"Connections": {

"Default": {

"sales": {

"ConnectionType": "SqlServer",

......

"SecurityOptions": "<span><strong>encrypt=Strict</strong></span>",

......

}

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2022

August 21, 2023

Was this article helpful?