EncryptPassword

Description

Specifies whether you want PowerBuilder to encrypt your password automatically when connecting to an OLE DB data provider.

When to specify EncryptPassword

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

Applies to

OLE DB

Syntax

EncryptPassword='value'

Parameter

Description

value

Specifies whether you want PowerBuilder to encrypt your password. Values are:

  • True

    Tells PowerBuilder to encrypt the password

  • False

    (Default) Tells PowerBuilder not to encrypt the password


Default value

EncryptPassword='False'

Examples

To tell PowerBuilder to encrypt your password when connecting to Microsoft SQL Server or an OLE DB data provider:

  • Database profile

    Select the Encrypt Password check box on the Security page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:

    SQLCA.DBParm="EncryptPassword='True'"

See also

DataLink

IntegratedSecurity

MaskPassword

PersistEncrypted