Preparing to use the Adaptive Server database – PB Docs 126

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:

  1. Install and configure the required
    database server, network, and client software.

  2. Install the Adaptive Server database interface.

  3. Verify that you can connect to Adaptive Server outside PowerBuilder.

  4. 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.

proc.png To install and configure the database server,
network, and client software:

  1. 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.

  2. 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.

  3. 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 Sybase. 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

    note.png 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.

  4. 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.

  5. If required by your operating system, make sure
    the directory containing the Open Client software is in your system
    path.

  6. 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.

If you work with PowerBuilder and EAServer,
you should also select the Adaptive Server interface for EAServer (SYJ).

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”
.


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x