When developers dynamically set connection properties (such as username and password) of the transaction object, these values are stored in plain text and may remain in memory, which could potentially be accessed from the client process.
PowerBuilder 2025 introduced the secure connection encryptor for generating and using encrypted database connection strings. The following scripts are supported in native client/server applications in version 2025 and later, and are now also supported in PowerServer installable cloud applications starting from version 2025 R2.
sqlca.EnableSecureConnection (true)
sqlca.SetSecureConnectionString("xqRAXnVg6rXmXbnDh0KDONUBU1rnnrjoD91RyPElnxrf0l9SnSlfpVvBhjVILLH9+mvvHhYexk0niM+N17rdZQLFCEW0x7z89qnNpVpIDgbhKHB7tvPyM2CaoFc6gsdvifEmUh0ICExJAyfzAA+GcA==")
sqlca.SetSecureConnectionProperty("logid", "appeon")
sqlca.AutoCommit = false
connect;