You must follow these procedures to configure Open Client and ODBC.
Setting required environment variables
Use the Environment tab in the Control Panel System window to set the SYBASE and PATH environment variables:
Set the SYBASE environment variable to the full path of the Open Client directory. Open Client is installed in Openclient subdirectory in the shared components directory that you selected during installation. For example:
C:\PROGRAM FILES\SYBASE\EASERVER\OPENCLIENT
Add the Open Client DLL and BIN subdirectories to the PATH environment variable.
Adding server definitions to the SQL.INI file
The SQL.INI file in the Open Client INI subdirectory defines server names and addresses. You must add an entry for each EAServer or database server you intend to connect to.
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 EAServer or database server’s TDS listener port number.
Another method
You
can also use the Open Client dsedit tool to edit
the SQL.INI file. For information about using dsedit,
see the Open Client Server Configuration Guide for Desktop
Platforms in the latest Open Client Server (Installation and
Configuration) collection, available at the Sybase Product Manuals Web site.
Verifying Open Client
connectivity to the server
Run the Open Client 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.
