Preparing to use the Adaptive Server database
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
If you install PowerBuilder using the PowerBuilder Installer (an online setup program), the Adaptive Server Enterprise (ASE
or SYC) database interface is automatically installed.
If you install PowerBuilder using the downloaded installation package (an offline setup program), select Native Database Interfaces | Adaptive Server Enterprise (ASE
or SYC) database interface from the list of components.
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.