HomeInfoMakerAppeon Documentation Center

Supports Strict encryption for SQL Server

A new encryption type "Strict" is added to the Encrypt Data option in the DB profile. The "Strict" encryption type enables SQL Server 2022 to leverage TDS 8.0.

"Strict" is available when you select the following SQL Server drivers:

  • OLE DB Driver for SQL Server (MSOLEDBSQL 19.x)

    SQLCA.DBMS = "MSOLEDBSQL SQL Server"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Provider='MSOLEDBSQL19',Encrypt=2"

  • ADO.NET provider for SQL Server

    SQLCA.DBMS = "ADO.Net"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Provider='SQL Server',PROVIDERSTRING='Encrypt=Strict;'"

  • MSOLEDBSQL 18.x and SNC SQL Native Client do NOT support the "Strict" type.

Prev  Up  Next
Supports identity column for Oracle  Home  Enables NativePDF option for application