Before you define the interface and connect to an Adaptive Server database in PowerBuilder, follow these steps to prepare the database for use:
-
Install and configure the required database server, network, and client software.
-
Install the Adaptive Server database interface.
-
Verify that you can connect to Adaptive Server outside PowerBuilder.
-
Install the required PowerBuilder stored procedures in the sybsystemprocs database.
Preparing an Adaptive Server database for use with PowerBuilder involves these four basic tasks.
Step 1: Install and configure the database server
You must install and configure the database server, network, and client software for Adaptive Server.
To install and configure the database server, network, and client software:
-
Make sure the Adaptive Server database software is installed on the server specified in your database profile.
You must obtain the database server software from SAP.
For installation instructions, see your Adaptive Server documentation.
-
Make sure the supported network software (for example, TCP/IP) is installed and running on your computer and is properly configured so that you can connect to the database server at your site.
You must install the network communication driver that supports the network protocol and operating system platform you are using. The driver is installed as part of the Net-Library client software.
For installation and configuration instructions, see your network or database administrator.
-
Install the required Open Client CT-Library (CT-Lib) software on each client computer on which PowerBuilder is installed.
You must obtain the Open Client software from SAP. Make sure the version of Open Client you install supports all of the following:
The operating system running on the client computer
The version of Adaptive Server that you want to access
The version of PowerBuilder that you are running
Required client software versions
To use the ASE Adaptive Server interface, you must install Open Client version 15.x or later. To use the SYC Adaptive Server interface, you must install Open Client version 11.x or later.
-
Make sure the Open Client software is properly configured so that you can connect to the database at your site.
Installing the Open Client software places the SQL.INI configuration file in the Adaptive Server directory on your computer.
SQL.INI provides information that Adaptive Server needs to find and connect to the database server at your site. You can enter and modify information in SQL.INI by using the configuration utility that comes with the Open Client software.
For information about setting up the SQL.INI or other required configuration file, see your Adaptive Server documentation.
-
If required by your operating system, make sure the directory containing the Open Client software is in your system path.
-
Make sure only one copy of each of the following files is installed on your client computer:
-
Adaptive Server interface DLL
-
Network communication DLL (for example, NLWNSCK.DLL for Windows Sockets-compliant TCP/IP)
-
Database vendor DLL (for example, LIBCT.DLL)
-
Step 2: Install the database interface
In the PowerBuilder Setup program, select the Typical install, or select the Custom install and select the Adaptive Server Enterprise (ASE or SYC) database interface.
Step 3: Verify the connection
Make sure you can connect to the Adaptive Server database server and log in to the database you want to access from outside PowerBuilder.
Some possible ways to verify the connection are by running the following tools:
-
Accessing the database server
Tools such as the Open Client/Open Server Configuration utility (or any Ping utility) check whether you can reach the database server from your computer.
-
Accessing the database
Tools such as ISQL (interactive SQL utility) check whether you can log in to the database and perform database operations. It is a good idea to specify the same connection parameters you plan to use in your PowerBuilder database profile to access the database.
Step 4: Install the PowerBuilder stored procedures
PowerBuilder requires you to install certain stored procedures in the sybsystemprocs database before you connect to an Adaptive Server database for the first time. PowerBuilder uses these stored procedures to get information about tables and columns from the DBMS system catalog.
Run the SQL script or scripts required to install the PowerBuilder stored procedures in the sybsystemprocs database.
For instructions, see Installing stored procedures in Adaptive Server databases.
