Description
PowerBuilder provides a new Sybase Systems 10 and 11 distributed application interface on the UNIX platform. This interface works with the thread-safe libraries provided by Sybase Open Client 11.1, thereby allowing you to build distributed applications on UNIX that access Sybase SQL Server 10.x and 11.x database servers.
With the addition of this interface, PowerBuilder provides two Sybase Systems 10 and 11 database interfaces on UNIX. The main difference between the two interfaces is that when building distributed PowerBuilder applications that access SQL Server 10.x or 11.x databases, you must use pbsyd60.dll.
|
Interface
|
Accesses
|
Client software
|
When to use
|
|
Sybase System 10 and System 11 (pbsyc60.dll)
|
SQL Server 10.x and 11.x
|
Sybase Open Client 10.0.1, 10.0.03, 10.0.04, or 11.1.1 or higher
|
To build nondistributed PowerBuilder applications
|
|
Sybase Systems 10 and 11 distributed application interface (pbsyd60.dll)
|
SQL Server 10.x and 11.x
|
Sybase Open Client 11.1.1 or higher thread-safe libraries
|
To build distributed PowerBuilder applications
|
Purpose
On UNIX, Open Client 11.1 provides a thread-safe version of the client library. When building a distributed PowerBuilder server application that accesses the database through an API, you must use a thread-safe client library.
The pbsyd60 interface is the first Sybase SQL Server interface on UNIX that works with the thread-safe version of Open Client 11.1. Therefore, you must use the pbsyd60 interface if you are building a distributed PowerBuilder application on UNIX that accesses a SQL Server 10.x or 11.x database.
Usage
The information in Connecting to Your Database about using the Sybase Systems 10 and 11 interface on UNIX also applies when you are using the Sybase Systems 10 and 11 distributed application interface on UNIX, with the following differences:
Required client software To use the Sybase Systems 10 and 11 distributed application interface, make sure the following software is installed on the UNIX client machine:
- Sybase Open Client Version 11.1.1 or higher thread-safe libraries
- PowerBuilder for UNIX Version 6.0 or higher
- Sybase Systems 10 and 11 distributed application interface (pbsyd60.dll) that comes with PowerBuilder
DBMS identifier When you specify the DBMS identifier in a PowerBuilder application script, you must use SYD to connect to the database through the Sybase Systems 10 and 11 distributed application 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.)
- To specify the SYD DBMS identifier in a PowerBuilder script:
Type the following in your PowerBuilder application script:
SQLCA.DBMS="SYD"
When you select the SYD interface in the Database Profiles dialog box and click New to create a new profile, this syntax displays on the Preview tab in the Database Profile Setup dialog box. You can then copy the syntax from the Preview tab into your script.
For more information
Click any of the following topics for details about using Sybase Open Client 11.1 security and directory services in your application:
Support for Sybase Open Client 11.1 features
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
|
