Encryption connection parameter [ENC]

Function

To encrypt packets sent between the client application and the server.

Usage

For ECC_TLS (Certicom), RSA_TLS, TCP/IP only.

For NONE or SIMPLE, anywhere.

Values

String

Default

NONE

If an Encryption value is not set, encryption is controlled by the setting on the server, which defaults to no encryption.

Description

You can use this parameter if you are concerned about the security of network packets. Encryption does affect performance marginally. The Encryption (ENC) connection parameter accepts the following arguments:

WARNING! The sample certificate should be used for testing purposes only. The sample certificate provides no security in deployed situations because it and the corresponding password are widely distributed with Sybase software. To protect your system, you must create your own certificate.

You can use the connection_property system function to retrieve the encryption settings for the current connection. The function returns one of three values: none, simple, or Certicom, depending which type of encryption is being used.

See also

-ec server command-line switch in “Starting the database server” in Sybase IQ Utility Guide

“CONNECTION_PROPERTY function [System]” in Sybase IQ Reference Manual

Examples