Using Open Client directory services

The Adaptive Server interfaces provide several DBParm parameters that support Open Client 11.1.x or later network-based directory services in your application. If you are using the required database, directory services, and PowerBuilder software, you can build applications that take advantage of Open Client directory services. 

What are Open Client directory services?

Open Client 11.1.x or later directory services allow you to use a supported third-party directory services product (such as the Windows Registry) as your directory service provider. Directory services provide centralized control and administration of the network entities (such as users, servers, and printers) in your environment.

Requirements for using Open Client directory services

For you to use Open Client directory services in your application, all of the following must be true:

  • You are accessing an Adaptive Server database server using Open Client Client-Library (CT-Lib) 11.x or later software

  • You have the required SAP-supported directory service provider software and SAP-supplied directory driver properly installed and configured for your environment. Depending on your operating system platform, examples of supported security mechanisms include the Windows Registry and Distributed Computing Environment Cell Directory Services (DCE/CDS).

    For information about the directory service providers and operating system platforms that Appeon has tested with Open Client directory services, see the Open Client documentation.

  • You must be able to access a secure Adaptive Server server using Open Client 11.1.x or later software from outside PowerBuilder.

    To verify the connection, use a tool such as ISQL or SQL Advantage to make sure you can connect to the server and log in to the database with the same connection parameters and directory service options you plan to use in your PowerBuilder application.

  • You are using the ASE or SYC Adaptive Server interface to access the database.

  • You must use the correct syntax as required by your directory service provider when specifying the server name in a database profile or PowerBuilder application script. Different providers require different syntax based on their format for specifying directory entry names.

    For information and examples for different directory service providers, see Specifying the server name with Open Client directory services.

  • You have set the Release DBParm to 11 or higher to specify that your application should use the behavior of the appropriate version of the Open Client CT-Lib software.

    For instructions, see Release database parameter in the section called “Release” in Connection Reference.

  • The directory service provider and driver you are using must support the service requested by the DBParm.

Specifying the server name with Open Client directory services

When you are using Open Client directory services in a PowerBuilder application, you must use the syntax required by your directory service provider when specifying the server name in a database profile or PowerBuilder application script to access the database.

Different directory service providers require different syntax based on the format they use for specifying directory entry names. Directory entry names can be fully qualified or relative to the default (active) Directory Information Tree base (DIT base) specified in the Open Client/Server configuration utility.

The DIT base is the starting node for directory searches. Specifying a DITbase is analogous to setting a current working directory for UNIX or MS-DOS file systems. (You can specify a nondefault DIT base with the DS_DitBase DBParm. For information, see "DS_DitBase".)

Windows registry server name example

This example shows typical server name syntax if your directory service provider is the Windows registry.

Node name: SALES:software\sybase\server\SYS12
DIT base: SALES:software\sybase\server
Server name: SYS12

To specify the server name in a database profile:

  • Type the following in the Server box on the Connection tab in the Database Profile Setup dialog box. Do not start the server name with a backslash (\).

    SYS12

To specify the server name in a PowerBuilder application script:

  • Type the following. Do not start the server name with a backslash (\).

    SQLCA.ServerName = "SYS12"

    If you specify a value in the Server box in your database profile, this syntax displays on the Preview tab in the Database Profile Setup dialog box. You can copy the syntax from the Preview tab into your script.

DCE/CDS server name example

This example shows typical server name syntax if your directory service provider is Distributed Computing Environment Cell Directory Services (DCE/CDS).

Node name: /.../boston.sales/dataservers/sybase/SYS12
DIT base: /../boston.sales/dataservers
Server name: sybase/SYS12

To specify the server name in a database profile:

  • Type the following in the Server box on the Connection tab in the Database Profile Setup dialog box. Do not start the server name with a slash (/).

    sybase/SYS12

To specify the server name in a PowerBuilder application script:

  • Type the following. Do not start the server name with CN=.

    SQLCA.ServerName = "SYS12"

    If you specify a value in the Server box in your database profile, this syntax displays on the Preview tab in the Database Profile Setup dialog box. You can copy the syntax from the Preview tab into your script.

Directory services DBParm parameters

If you have met the requirements described in Requirements for using Open Client security services, you can set the directory services DBParms in a database profile for your connection or in a PowerBuilder application script.

The following DBParms correspond to Open Client 11.1.x or later directory services connection parameters:

DS_Alias
DS_Copy
DS_DitBase
DS_Failover
DS_Password (Open Client 12.5 or later)
DS_Principal
DS_Provider
DS_TimeLimit

For instructions on setting these DBParms, see their descriptions in Database Parameters in Connection Reference.