Connection settings

The OLE DB driver connection settings are managed by Microsoft, version-specific:

https://learn.microsoft.com/en-us/sql/connect/oledb/applications/using-connection-string-keywords-with-oledb-driver-for-sql-server?view=sql-server-ver16

For example, for connection encryption, in case a test database server uses self-signed certificates: https://learn.microsoft.com/en-us/sql/connect/oledb/features/encryption-and-certificate-validation?view=sql-server-ver16

The settings are placed in iddb's registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Bravura Security\Bravura Security Fabric\instance-name\MSSQL

There are two String values to use: CustomOptions and CustomOptionsPooled.

If only one setting is needed, no quotes are required but both the connection setting and its value are provided.

In the example above, to bypass the certificate validation if trust cannot be established the normal way (and not for production instances), the values of both strings would be either TrustServerCertificate=True or for more security "HostNameInCertificate=hostname" "TrustServerCertificate=True". where hostname is the value used in the certificate used on the SQL database.