Purpose

Determines whether data is encrypted and decrypted when it is transmitted over the network between the driver and database server.

Valid Values

noEncryption | SSL | requestSSL | loginSSL

Behavior

If set to noEncryption, data is not encrypted or decrypted.

If set to SSL, data is encrypted using SSL. If the database server does not support SSL, the connection fails and the driver throws an exception.

If set to requestSSL, the login request and data is encrypted using SSL. If the database server does not support SSL, the driver establishes an unencrypted connection.

If set to loginSSL, the login request is encrypted using SSL. Data is encrypted using SSL If the database server is configured to require SSL. If the database server does not require SSL, data is not encrypted and only the login request is encrypted.

Notes

  • Connection hangs can occur when the driver is configured for SSL and the database server does not support SSL. You may want to set a login timeout using the LoginTimeout property to avoid problems when connecting to a server that does not support SSL.
  • If SSL is enabled, the driver communicates with database protocol packets that are set by the server’s default packet size. Any value set by the PacketSize property is ignored.
  • If SSL is enabled, the following properties also apply:

    CryptoProtocolVersion

    HostNameInCertificate

    TrustStore

    TrustStorePassword

    ValidateServerCertificate

Default

noEncryption

Data Type

String

See also

Data Encryption

Performance Considerations