The method the driver uses to encrypt data sent between the driver and the database server.
Valid Values
0 | 1 | 6 | 7
Behavior
If set to 0 (None), data is not encrypted.
If set to 1 (SSL), data is encrypted using the SSL protocols specified in the Crypto Protocol Version connection option.
If set to 6 (RequestSSL), the login request and data are encrypted using SSL if the server is configured for SSL. If the server is not configured for SSL, an unencrypted connection is established. The SSL protocol used is determined by the setting of the Crypto Protocol Version connection option.
If set to 7 (LoginSSL), the login request is encrypted using SSL regardless of whether the server is configured for SSL. The data is encrypted using SSL if the server is configured for SSL, and the data is unencrypted if the server is not configured for SSL. The SSL protocol used is determined by the setting of the Crypto Protocol Version connection option.
This option can only be set to 1 when Authentication Method is set to 1.
Notes
When establishing a connection to Microsoft Azure Synapse Analytics or Microsoft Analytics Platform System, the driver will enable SSL data encryption by default (EncryptionMethod=1).
For values 1 through 7, the SSL protocol used is determined by the setting of the Crypto Protocol Version connection option.
The driver must use the server-specified packet size when using SSL encryption. If SSL is used, any value set for the Packet Size connection option is ignored.
When establishing a connection to Microsoft Azure Synapse Analytics or Microsoft Analytics Platform System, the driver will enable SSL data encryption by default (EncryptionMethod=1).