Description

PowerBuilder and InfoMaker 6.0 provide several new DBParm parameters that enable Sybase Open Client 11.1 network-based security services in your application. You can set the security services DBParm parameters when accessing SQL Server 10.x or 11.x with one of the following Powersoft database interfaces:

Purpose

If you are using the required database, security, and PowerBuilder or InfoMaker software, you can build applications that take advantage of Sybase Open Client 11.1 network-based security services.

Open Client 11.1 security services allow you to use a supported third-party security mechanism (such as CyberSAFE Kerberos) to provide login authentication and per-packet security for your application. Login authentication establishes a secure connection, and per-packet security protects the data transmitted across the network.

Using third-party security mechanisms

For information about the third-party security mechanisms and operating system platforms Powersoft has tested with Open Client 11.1 security services, see the Release Notes.

Usage

To use any of the DBParm parameters supporting Open Client 11.1 security services, you must meet certain requirements for using security services in your PowerBuilder or InfoMaker application.

As with any other DBParm parameter, you can set the security services DBParms in the Database Profile Setup dialog box for your connection or in a PowerBuilder application script.

You must specify values for the security services DBParms before connecting to the database in PowerBuilder or InfoMaker.

DBParm parameters

There are two categories of DBParm parameters that support Open Client 11.1 security services:

• Login authentication  DBParms in this category correspond to Sybase Open Client Client-Library (CT-Lib) 11.1 connection properties that allow an application to establish a secure connection.
• Per-packet security services  DBParms in this category correspond to CT-Lib 11.1 connection properties that protect each packet of data transmitted across a network. Note, however, that per-packet security services create extra overhead for communications between the client and server.

The following DBParm parameters have been added to PowerBuilder and InfoMaker to support Sybase Open Client 11.1 security services. For each DBParm, the table lists the corresponding CT-Lib 11.1 connection property. Click the DBParm name for a complete description.