Encryption (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / WLanguage properties / HFSQL properties

ExtendedInfo property and connection

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HFSQL properties

Encryption (Property)

In french: Cryptage

Not available with these kinds of connection

Warning
From version 28 (75), CryptMethod is kept for backward compatibility. This property has been replaced with Encryption.

The Encryption property allows you to manage the type of encryption used between Client computers and an HFSQL server. You can:

Get the type of encryption used for an HFSQL Client/Server connection.
Define the type of encryption used for an HFSQL Client/Server connection. In this case, if the connection is currently open, it will be closed and opened again with the new parameters when first accessing a data file that uses this connection.

Note: The connection can correspond:

a connection defined in the data model editor,
a connection defined with HConnect, HDescribeConnection or HOpenConnection.
a connection defined with a variable of type Connection.

Example

MaConnexion is Connection
// Description de la connexion
MaConnexion.User = "USER"
MaConnexion.MotDePasse = "PASSWORD"
MaConnexion.Server = "MONSERVEUR" 
MaConnexion.Database = "Base de données"
MaConnexion.Encryption = hEncryptionRC5_16
MaConnexion.Provider = hAccessHFClientServer
MaConnexion.Access = hOReadWrite
MaConnexion.ExtendedInfo = "Infos étendues"
HOpenConnection(MaConnexion)

Syntax

Getting the type of encryption for an HFSQL Client/Server connection Hide the details

<Type of encryption> = <Connection used>.Encryption

<Type of encryption>: Constant

Returns the type of encryption for the connection:
hEncryptionAES128 The connection between the server and the client computers is encrypted using a 128-bit AES algorithm with the Output Feedback (OFB) mode.
hEncryptionAES192 The connection between the server and the client computers is encrypted using a 192-bit AES algorithm with the Output Feedback (OFB) mode.
hEncryptionAES256 The connection between the server and the client computers is encrypted using a 256-bit AES algorithm with the Output Feedback (OFB) mode.
hEncryptionNO No encryption is performed.
hEncryptionRC5_16 The connection between the server and the client computers is encrypted using an optimized 16-round RC5 algorithm with a 128-bit key.
hEncryptionStandard The connection between the server and the client computers is encrypted using an optimized 128-bit algorithm.

<Connection used>: Connection name

Name of the connection used. This name is defined:
in the data model editor,
with the HDescribeConnection and HOpenConnection functions,
with the Connection type.

Defining the type of encryption for a connection Hide the details

<Connection used>.Encryption = <Type of encryption>

<Connection used>: Connection name

Name of the connection used. This name is defined:
in the data model editor,
with the HDescribeConnection and HOpenConnection functions,
with the Connection type.

<Type of encryption>: Constant

Defines the type of encryption for the connection:
hEncryptionAES128 The connection between the server and the client computers is encrypted using a 128-bit AES algorithm with the Output Feedback (OFB) mode.
hEncryptionAES192 The connection between the server and the client computers is encrypted using a 192-bit AES algorithm with the Output Feedback (OFB) mode.
hEncryptionAES256 The connection between the server and the client computers is encrypted using a 256-bit AES algorithm with the Output Feedback (OFB) mode.
hEncryptionNO No encryption is performed.
hEncryptionRC5_16 The connection between the server and the client computers is encrypted using an optimized 16-round RC5 algorithm with a 128-bit key.
hEncryptionStandard The connection between the server and the client computers is encrypted using an optimized 128-bit algorithm.

Remarks

ExtendedInfo property and connection

Changing the encryption information of an HFSQL Client/Server connection with the ExtendedInfo property automatically updates the information returned by the Encryption property and vice versa.

Therefore, the following line of code:

MaConnexion.Cryptage = hEncryptionRC5_16

will modify the ENCRYPTION option in the extended information string.

Similarly, the following line of code:

MaConnexion.InfosEtendues = "CRYPTAGE=RC5_16"

will modify the Encryption property.

Example In the following code, assigning the extended information removes the encryption:

MaConnexion.Cryptage = hEncryptionRC5_16
MaConnexion.InfosEtendues = "BDD_EXISTE"

The correct code to use is:

MaConnexion.InfosEtendues = "BDD_EXISTE"
MaConnexion.Cryptage = hEncryptionRC5_16

or:

MaConnexion.Cryptage = hEncryptionRC5_16
MaConnexion.InfosEtendues += [";"]+"BDD_EXISTE"