Preparing the Sybase Environment

In this section:

In order to use the Adapter for Sybase, you must set Sybase and platform-specific environment variables prior to starting the server. Check with your system administrator to see if these values have already been set for you.


Top of page

x
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:

SYBASE=/usr/sybase
PATH=$PATH:$SYBASE/bin
export SYBASE PATH

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

x
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:



x
Procedure: How to Specify the Sybase Server Name
DSQUERY=server 
export DSQUERY

where:

server

Is the name of the Sybase database server.


Top of page

x
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

x
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 chararcter 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

x
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.


iWay Software