An encryption tool is provided to encrypt the connection properties of the transaction object and generate an encrypted connection string for the database connection.
The following properties can be encrypted and included in the
encrypted connection string: servername,
logid, logpass, database,
userid, dbpass, lock,
dbparm, & dbms.
You can access the tool from the New window > Tool tab > Secure Connection Encryptor or by right-clicking the database profile and selecting Generate Secure Connection String from the popup menu.
Input the connection property values, click Encrypt to generate an encrypted string, and then use the string in the following code:
sqlca.EnableSecureConnection (true)
sqlca.SetSecureConnectionString("xqRAXnVg6rXmXbnDh0KDONUBU1rnnrjoD91RyPElnxrf0l9SnSlfpVvBhjVILLH9+mvvHhYexk0niM+N17rdZQLFCEW0x7z89qnNpVpIDgbhKHB7tvPyM2CaoFc6gsdvifEmUh0ICExJAyfzAA+GcA==")
sqlca.SetSecureConnectionProperty("logid", "appeon")
sqlca.AutoCommit = false
connect;
The Transaction object has been added with the following functions to support the secure connection:
-
EnableSecureConnection -- Enables the secure connection.
-
SetSecureConnectionString -- Specifies the encrypted string to be used during the database connection.
-
SetSecureConnectionProperty -- Changes the value of the transaction object property (including
servername,logid,logpass,database,userid,dbpass,lock,dbparm, &dbms) in the encrypted connection string.
Starting from Version 2025, you can connect with the PostgreSQL database using the PowerBuilder ADO.NET database interface. (In the previous versions, you can only connect with the PostgreSQL database using the PowerBuilder ODBC database interface.)
The .NET Core driver for PostgreSQL (npgsql.dll) is automatically included and installed with PowerBuilder.
A number of runtime files (including Appeon.DB.PostgreSql.dll) are required for supporting the connection at PowerBuilder runtime.
For more information, refer to Using the ADO.NET Interface in Connecting to Your Database.
