Sec_Confidential database parameter
When you access an SAP Adaptive Server Enterprise database
in PowerBuilder through Open Client, Sec_Confidential is
one of several parameters that support per-packet security for network-based
security services. (For other per-packet security parameters, see
the See Also section.)
Sec_Confidential controls whether transmitted data
is encrypted. When Sec_Confidential is set to 1, all requests
sent to the server and all results returned by the server are encrypted.
When Sec_Confidential is set to 0 (the default),
transmitted data is not encrypted.
You must specify a value for Sec_Confidential before connecting
to the database in PowerBuilder.
For information about the third-party security
mechanisms and operating system platforms that Sybase has tested
with Open Client security services, see the Open Client documentation.
ASE, SYC SAP Adaptive
Specifies whether transmitted data is
When to use
Encryption can protect your data if you are sending it over
a public network to a nonsecure server. In a networked environment,
you might want to set Sec_Confidential to 1 to ensure that
all requests sent to the server and all results returned by the
server are encrypted.
Set Release parameter
For this parameter to take effect, you must also
set the Release parameter to 11or higher to specify that your application
should use the appropriate version of Sybase Open Client Client–Library
(CT-Lib) behavior. See the description of the Release parameter
for more information.
Requirements for use
To use Sec_Confidential or any other parameter supporting
Open Client security services, you must meet certain requirements for
using security services in your PowerBuilder application. For details,
see “Requirements for using Open Client security services” in Connecting
to Your Database.
Corresponding CT-Lib connection property
Specifying a value for Sec_Confidential sets the
corresponding Sybase CT-Lib connection property named CS_SEC_CONFIDENTIALITY.
To specify that transmitted data is encrypted:
Select the Encrypt All Results check box on the Security page
in the Database Profile Setup dialog box.
Type the following in code:PowerBuilder1SQLCA.DbParameter="Sec_Confidential=1"