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.

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

Configuring the Open Client environment

1. “Set required environment variables”.

2. “Add server definitions to the interfaces file”.

3. “Verify connectivity using isql”.

Set 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 to the server environment when it starts.

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

1. Set the SYBASE environment variable to the full path of the EAServer openclient subdirectory. For example:

   setenv SYBASE /opt/Sybase/EAServer/openclient
   

2. Prefix the Open Client lib subdirectory 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

1. Create the file $JAGUAR/interfaces if it does not already exist.

2. 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 $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 rather than an error message, the connection is successful.