Prepare to Install › Central Management Server Database Requirements and Preparation › Use a Supported Database Server › Set up an Empty Database for the CMS › Sybase Database Requirements › Verify Sybase Native Connectivity Through a Server Name (UNIX Only)

Verify Sybase Native Connectivity Through a Server Name (UNIX Only)

To verify Sybase native connectivity through a server name

1. Log in to the UNIX server with the user account and password which you will use to do your install.

   Note: This account should already be set up. See Create an Account, a Home Directory, and a Login Environment for more information about setting up a UNIX account to use when you install BusinessObjects Enterprise.

2. Echo the following environment variables and ensure that their values correspond to your database client software installation.
   • SYBASE

     This variable contains the path to the root directory of your Sybase client installation (one level above the SYBASE_OCS version directory).

   • SYBASE_OCS

     This variable contains the name of the Sybase version directory (one level above the Sybase bin and lib directories).

   • library path

     The library search path (LD_LIBRARY_PATH on Solaris and Linux, LIBPATH on AIX) must include the lib directory of your Sybase client installation.

   • PATH

     The search path must include the bin directory of your Sybase client installation.

   This example checks the required variables, and shows sample output values:

   $ echo $SYBASE
   /opt/sybase/12.0
   $ echo $SYBASE_OCS
   OCS-12_O
   $ echo $LD_LIBRARY_PATH
   /export/home/sybase/12.0/OCS-12_0/lib
   $ echo $PATH
   /usr/bin:/usr/ucb:/etc:.:/export/home/sybase/12.0/OCS-
   12_0/bin
   

3. Issue the following command to run the Sybase SQL tool and connect to the database server:

   isql -U user -P password -S servername
   

   Replace user, password, and servername with the appropriate values. If the shell environment has been configured correctly, you are connected to Sybase.

4. Issue the following command to ensure that the account has permission to create tables:

   use aps
   go
   create table sampletable (def_field char(10))
   go
   sp_help sampletable
   go
   

5. Issue the following command to ensure that the account has permission to delete tables:

   drop table sampletable
   go
   sp_help sampletable
   go
   

6. Type quit.