Configuring Open Client

This section describes only the basic configuration steps to use Open Client with EAServer. For complete information on configuring Open Client, see the Open Client/Server Configuration Guide for UNIX on the Sybase Product Manuals Web site.

EAServer 6.2 supports Open Client versions 12.5.1 and 15.0, which are located in $DJC_HOME/openclient-12.5.1 and $DJC_HOME/openclient-15.0, respectively. Sybase recommends that you do not install Open Client in another location. By default, EAServer uses version 12.5.1.To use Open Client version 15.0, shut down EAServer, then run:

$DJC_HOME/bin/configure.sh ocs-15

To switch to version 12.5.1, shut down EAServer, then run:

$DJC_HOME/bin/configure.sh ocs-125

Configuring the Open Client environment

Set required environment variables

EAServer 6.2 is designed to use Open Client version 12.5.1 and later. Earlier versions of Open Client use the SYBASE environment variable. More recent versions use the environment variables SYBASE and SYBASE_OCS. The default installation of Open Client 12.5.1 sets:

SYBASE=/work/sybase
SYBASE_OCS=OCS_12-5-1

These two variables are defined in the setup scripts for EAServer 6.2. You must ensure that your global Open Client sets them correctly.

You can also use the local-setenv.sh script to locally define which installation of Open Client to use.

To set the environment variables, edit the local_setenv.sh setup script located in EAServer/bin. Create this file if it does not exist. Settings in this file are added to the server environment when it starts.

After you run the setup script, set the LD_LIBRARY_PATH environment variables manually.

Prefix the Open Client lib and bin subdirectories to the LD_LIBRARY_PATH environment variable. For example:

setenv LD_LIBRARY_PATH $SYBASE/lib:$LD_LIBRARY_PATH

Add server definitions to the interfaces file

The interfaces file in the Open Client installation directory is a text file that defines server names and addresses. You must add entries for each EAServer or database server to which you intend to connect.

Adding server entries to the file with a text editor

Create the file $DJC_HOME/interfaces if it does not already exist.
Open the file in your text editor and add an entry in this format:
```
server_name
		master tcp ether host, tds_port
		query tcp ether host, tds_port
```
where:
- server_name – is a logical name for the server, composed of letters, digits, and the underscore character.
- host – is the server machine’s host name or IP address.
- tds_port – is the EAServer or database server’s TDS listener port number.
The master and query lines must begin with a single tab and no spaces.

Verify connectivity using isql

Run the Open Client isql tool to verify the configuration:

$SYBASE/bin/isql -I $DJC_HOME/interfaces -S server_name -U user -P password

Where:

server_name – is the server you defined in the interfaces file.
user – is a valid user name for EAServer or the database server.
password – is the password that accompanies the user name.

If isql shows a command prompt and not an error message, the connection is successful.