Preparing the Sybase Environment

In this section:

The Adapter for Sybase requires the installation of the Sybase Open Client (CT-Library). The Sybase client allows you to connect to a local or remote Sybase database server after the platform-specific environment variables are set. After installation, the client must be configured to allow you to connect to a local or remote Sybase database server.

Top of page

Identifying the Location of the Interfaces File

If you are using Sybase inherent distributed access, you must set the SYBASE environment variable to identify the directory where the interfaces file resides. The Windows equivalent of the UNIX interfaces file is the sql.ini file.

The interfaces file is required for both local and remote access. If you do not set the SYBASE environment variable, Sybase searches /etc/passwd for the login directory of the user named Sybase and accesses the interfaces file in that directory.

Note that the UNIX PATH must include the location of the Sybase executables. For example, specify the PATH entry as follows for Sybase:


You can export the SYBASE environment variable from the UNIX shell or in the UNIX profile of the user's machine that starts the server.

For information about other environment variables needed for Sybase executables and components, see the Sybase installation and configuration documentation.

Top of page

Specifying the Sybase Server Name

How to:

Use the DSQUERY environment variable to specify the Sybase Server name. The server uses this value only if:

Procedure: How to Specify the Sybase Server Name
export DSQUERY



Is the name of the Sybase database server.

Top of page

Accessing a Remote Sybase Server

Using the standard rules for deploying the Sybase Client, the server supports connections to:

New entries in the interfaces file may be made using the Sybase tool DSEDIT. Entries may also be made automatically using the sybinstall facility. For details, see the Sybase documentation.

Top of page

Unicode Support

For ASE, beginning with Sybase ASE version 15.0, the adapter supports Unicode data in Sybase ASE databases that have been created with the UTF-8 character set.

For IQ, beginning with Sybase IQ version 12.7, the adapter supports Unicode data in Sybase IQ databases that have been created with the UTF-8 character set.

You must set the LANG and NLS_LANG environment variables in the edastart file or in a separate shell file before starting the server.

For example, for American English, you would export the following variables:

export LANG=EN_US.UTF-8
export NLS_LANG=American_America.UTF8

Note: To take advantage of the adapter support for Unicode data, the Reporting Server must be configured with UTF-8 code page 65001.

Top of page

XA Support(ASE)

Read/write applications accessing Sybase data sources are able to perform transactions managed in XA-compliant mode.

To activate the XA Transaction Management feature, the server has to be configured in Transaction Coordination Mode, using the Web console configuration functions. Using Transaction Coordination Mode guarantees the integrity of data modification on all of the involved DBMSs and protects part of the data modifications from being committed on one DBMS and terminated on another.

For complete documentation on XA compliance, see XA Support.