Encrypt – PB Docs 126

Encrypt database parameter

Description

Specifies that data should be encrypted before sending it
over the network.

note.png When to specify Encrypt

You must specify the Encrypt parameter before connecting
to the database.

Controls

  • SNC SQL Native Client for Microsoft SQL Server

Syntax

Parameter

Description

value

Specifies whether data should be encrypted.
This parameter is used in conjunction with the TrustServerCertificate DbParameter.
Values are:

  • 0

    (Default) No encryption occurs.

  • 1

    If TrustServerCertificate is not set, encryption occurs only
    if there is a verifiable server certificate. If TrustServerCertificate
    is set, encryption always occurs, but may use a self-signed server
    certificate.

Default

Encrypt=0

Usage

SQL Server 2005 always
encrypts network packets associated with logging in to the server.
If no certificate is provided on the server when it starts up, SQL Server generates a self-signed
certificate that is used to encrypt login packets.

SQL Server Configuration
Manager can be used to configure the SQL Native Client
to request an encrypted connection using the Secure Sockets Layer (SSL),
and to accept a self-signed certificate without validation. You
can also request encryption by setting the Encrypt DbParameter to
1, which sets the SQL Native
Client connection string keyword Encrypt. To enable encryption to
be used when a certificate has not been provided on the server,
set both Encrypt and TrustServerCertificate. The value of TrustServerCertificate
is ignored if Encrypt is not set.

Examples

To specify that PowerBuilder should encrypt data:

  • Database profile

    Select the Encrypt Data check box on the System page in the
    Database Profile Setup dialog box.

  • Application

    Type the following in code:

See Also

TrustServerCertificate


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x