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.
-
GetSecureConnectionString -- Gets the encrypted string used in the database 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.
