Chapter 5: Configuring Open Client and ODBC

Configuring Open Client and ODBC

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.

Configuring ODBC data sources

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.

View this book as PDF