Description
When you access an SAP Adaptive Server Enterprise database in PowerBuilder through Open Client, Sec_Mechanism is one of several parameters that support login authentication for network-based security services. (For other login authentication parameters, see the See Also section.)
When you use Open Client security services, you must specify the name of the security mechanism you want to use in the Open Client/Open Server Configuration utility so that the required drivers can be loaded. The default security mechanism is the one currently specified as active in the Configuration utility.
Sec_Mechanism lets you specify a security mechanism name listed in the Open Client/Open Server Configuration utility other than the default (active) mechanism.
You must specify a value for Sec_Mechanism before connecting to the database in PowerBuilder.
Using third-party security mechanisms
For information about the third-party security mechanisms and operating system platforms that has been tested with Open Client security services, see the Open Client documentation.
Applies to
ASE, SYC SAP Adaptive Server Enterprise
Syntax
Sec_Mechanism='mechanism_name'
|
Parameter |
Description |
|---|---|
|
mechanism_name |
The security mechanism name you want to use to establish a connection. The security mechanism name is case sensitive. You must specify it exactly as it appears in the Open Client/Open Server Configuration utility. |
Default value
The default value for Sec_Mechanism is the security mechanism name currently specified as active in the Open Client/Open Server Configuration utility. If there is no security mechanism specified, no security service is used to establish the connection.
Usage
When to use
Set Sec_Mechanism to use a security mechanism specified in the Open Client/Open Server Configuration utility other than the default (active) security mechanism. For instructions on using the Open Client/Open Server Configuration utility, see your SAP Sybase Open Client/Server configuration guide.
Set Release parameter
For this parameter to take effect, you must also set the Release parameter to 11 or higher to specify that your application should use the appropriate version of SAP Sybase Open Client Client-Library (CT-Lib) behavior. See the description of the Release parameter for more information.
Requirements for use
To use Sec_Mechanism 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 the section called “Requirements for using Open Client security services” in Connecting to Your Database.
Corresponding CT-Lib connection property
Specifying a value for Sec_Mechanism sets the corresponding SAP Sybase CT-Lib connection property named CS_SEC_MECHANISM.
Examples
To specify KERBEROS as your security mechanism name:
-
Database profile
Type the following in the Security Mechanism box on the Security page in the Database Profile Setup dialog box:
KERBEROS
-
Application
Type the following in code:
SQLCA.DBParm="Sec_Mechanism='KERBEROS';Release=15"
See also
