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 Technical Library Web site.

The Open Client files are installed in the openclient subdirectory of your EAServer installation.

Setting required environment variables

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

After you run the setup script, set the SYBASE and SHLIB_PATH environment variables manually.

Set the SYBASE environment variable to the full path of the EAServer openclient subdirectory. For example:
```
setenv SYBASE /opt/Sybase/EAServer/openclient
```
Prefix the Open Client lib subdirectory to the SHLIB_PATH environment variable. For example:
```
setenv SHLIB_PATH $SYBASE/lib:$SHLIB_PATH
```

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

Create the file $JAGUAR/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.

Verifying connectivity using isql

Run the Open Client isql tool to verify the configuration:
```
$SYBASE/bin/isql -I $JAGUAR/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.