Use an encrypted password in the database connection strings - Brainware for Transcripts - 24.1 - 24.1 - Ready - Brainware - external - Brainware/Brainware-for-Transcripts/24.1/Brainware-for-Transcripts-User-Guide/Configure-Brainware-for-Transcripts/Configure-Password-Encryption/Use-an-encrypted-password-in-the-database-connection-strings - 2024-10-28

Brainware for Transcripts User Guide
Platform
Brainware
Product
Brainware for Transcripts
Release
24.1
License

To use an encrypted password, complete the following steps.

  1. Generate an encrypted password from the Password_Encrypt.bat file. For more information on how to generate an encrypted password, refer to the Encrypt a password topic.
    Example: IPEnmmcqUfVudqwKxWzoJE/smb5H4L2KgJ7n2UjvUYZ5iZ+eHA+udol+rOp+DqkFPAuQ1aRPE0lcV868A75AzbFrnGWHv/oFae893qUwQZNTgjGBfRZAblqT4nsxBQld12XwAmKlP3qVhOwFlfas5/dbgX+lmx7zS/fzyzes7yY=
  2. Copy and paste the encrypted password to the Project.ini file, next to the corresponding SQL_VL_<Connection group number>_EncryptedPassword key.
  3. You can use the corresponding SQL_VL_<Connection group number>_ConnectionString without any password information. Remove the unencrypted password key-value pair from the connection strings if it already contains password information.

    Remove password information from the connection string.

    Note:

    The values in the Data Source and Password fields are fictitious and are for representation sake only.

    SQL_VL_01_ConnectionString=Provider=ORAOLEDB.ORACLE;Data Source=EXAMPLE;Password=EXAMPLE1;User ID=Hyland

    The final connection string looks like:

    SQL_VL_01_ConnectionString=Provider=ORAOLEDB.ORACLE;Data Source=EXAMPLE; User ID=Hyland
                            SQL_VL_01_EncryptedPassword= IPEnmmcqUfVudqwKxWzoJE/smb5H4L2KgJ7n2UjvUYZ5iZ+eHA+udol+rOp+DqkFPAuQ1aRPE0lcV868A75AzbFrnGWHv/oFae893qUwQZNTgjGBfRZAblqT4nsxBQld12XwAmKlP3qVhOwFlfas5/dbgX+lmx7zS/fzyzes7yY=