Description
The Sybase SQL Server Systems 10 and 11 database interface on Windows and UNIX has been enhanced to support new features in Sybase Open Client 11.1. This support includes several new DBParm parameters that enable Open Client 11.1 security and directory services in your PowerBuilder or InfoMaker application.
Supported database interfaces and platforms
To use Open Client 11.1 security and directory services in your application, you must connect to the database through one of the following Powersoft database interfaces:
The Sybase Systems 10 and 11 interface on Windows and Solaris were available in previous releases of PowerBuilder and InfoMaker and have been enhanced in Version 6.0 to support Open Client 11.1 features. The Sybase Systems 10 and 11 distributed application interface on UNIX is new in this release.
Purpose
Support for Sybase Open Client 11.1 features provides two important benefits for PowerBuilder and InfoMaker users:
- Applications can take advantage of security and directory services (on Windows and UNIX)
Open Client 11.1 provides support for network-based security and directory services. If you access a SQL Server 10.x or 11.x database server in PowerBuilder or InfoMaker with one of the supported database interfaces, you can set several new DBParm parameters to take advantage of Open Client 11.1 security services and directory services in your application.
- Sybase Systems 10 and 11 distributed application interface works with thread-safe version of Open Client 11.1 (on UNIX only)
The Sybase Systems 10 and 11 distributed application interface is the first Sybase SQL Server interface on the UNIX platform that works with the thread-safe version of the Open Client 11.1 libraries. This allows you to build distributed PowerBuilder applications on UNIX that access SQL Server 10.x or 11.x databases.
Usage
The information in Connecting to Your Database about using the Sybase Systems 10 and 11 interface also applies when you are using Open Client 11.1 features in your application, with the following differences:
Required client software To use one of the Powersoft database interfaces that supports Open Client 11.1 features, make sure the following software is installed on the client machine as appropriate for your operating system platform:
- Sybase Open Client (see table for required version)
- PowerBuilder or InfoMaker Version 6.0 or higher
- Supported Sybase Systems 10 and 11 interface for your platform (see table)
You need the following versions of Sybase Open Client software to use each interface:
|
Platform
|
Powersoft database interface
|
Open Client software
|
|
Windows
|
Sybase System 10 and System 11
|
Sybase Open Client 10.0.1, 10.0.03, 10.0.04, or 11.1.1 or higher
|
|
UNIX
|
Sybase System 10 and System 11
or
|
Sybase Open Client 10.0.1, 10.0.03, 10.0.04, or 11.1.1 or higher
|
|
Sybase Systems 10 and 11 distributed application interface
|
Sybase Open Client 11.1.1 or higher (includes thread-safe version of libraries)
|
DBMS identifier When you specify connection parameters in a PowerBuilder application script, you must use the following DBMS identifier for each interface. (You no longer need to specify the DBMS identifier in a database profile. When you create a new profile for any installed Powersoft database interface, PowerBuilder or InfoMaker generates the correct DBMS connection syntax automatically.)
For more information
Click any of the following topics for details about support for Open Client 11.1 features in your application:
Sybase Systems 10 and 11 distributed application interface on UNIX
Release DBParm parameter for Sybase SQL Server 10 and 11
DBParm parameters for Sybase Open Client 11.1 security services
DBParm parameters for Sybase Open Client 11.1 directory services
|
