EAServer 6.1 is designed to use OpenClient version 12.5.1 and later. Earlier versions of OpenClient use the SYBASE environment variable. More recent versions use the environment variables SYBASE and SYBASE_OCS. The default installation of OpenClient 12.5.1 sets:
SYBASE=c:\sybase
SYBASE_OCS=OCS_12-5-1
These two variables are defined in the setup scripts for EAServer 6.1. You must ensure that your global OpenClient sets them correctly.
You can also use the local-setenv.bat script to locally define which installation of OpenClient to use.
Add the OpenClient DLL and BIN subdirectories to the PATH environment variable.
Adding server definitions to the SQL.INI file
The SQL.INI file in the OpenClient INI subdirectory defines server names and addresses. Add an entry for each EAServer or database server to which you intend to connect.
Create the file %SYBASE%\INI\SQL.INI if it does not already exist.
Open the SQL.INI file in a text editor and add an entry in this format:
[server_name]
master=TCP,host,tds_port
query=TCP,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 database server’s TDS listener port number.
Another method
You
can also use the OpenClient dsedit tool to edit
the SQL.INI file. For information about using dsedit,
see the OpenClient Server Configuration Guide for Desktop
Platforms in the latest OpenClient Server (Installation
and Configuration) collection, available at the Product Manuals Web site.
Verifying OpenClient connectivity
to the server
Run the OpenClient isql tool to verify the configuration:
%SYBASE%\BIN\ISQL -S server_name -U user -P password
where:
server_name – is the server name you defined in the SQL.INI file.
user – is a valid user name for the EAServer or database server.
password – is the password that accompanies the user name.
The connection is successful if isql displays a command prompt instead of an error message.
