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 Technical Library 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.
Installing new ODBC system files
The Merant DataDirect Connect ODBC Driver for Sybase Databases version 4.10 is included with your installation. This is an ODBC version 3.5 driver and requires ODBC version 3.5 system files.
Check the version of your ODBC system files in Windows ODBC Administrator. The About tab displays the version number of the driver manager and other components. If the version is not 3.5 or later, you must install new ODBC system files.
If the ODBC system files are a lower version, you can install them from the Microsoft data access components bundle (MDAC), available for download from Microsoft. Download MDAC version 2.5 from the Microsoft Web page.
Run the Windows ODBC Administrator to define data sources that use the new driver.
In the ODBC Administrator, the driver is identified as PB DataDirect OEM 4.10 Sybase ASE Wire Protocol. The driver files are installed in the shared components directory, in the DataDirectODBC subdirectory.
