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 a secure connection feature to generate and use the encrypted connection string for database connections.
PowerServer now supports the following scripts as well.
sqlca.EnableSecureConnection (true)
sqlca.SetSecureConnectionString("xqRAXnVg6rXmXbnDh0KDONUBU1rnnrjoD91RyPElnxrf0l9SnSlfpVvBhjVILLH9+mvvHhYexk0niM+N17rdZQLFCEW0x7z89qnNpVpIDgbhKHB7tvPyM2CaoFc6gsdvifEmUh0ICExJAyfzAA+GcA==")
sqlca.SetSecureConnectionProperty("logid", "appeon")
sqlca.AutoCommit = false
connect;