All Open Server applications require the following basic configuration information obtained during initialization and connection
Location of the Sybase installation directory
Locale name
Localized message and character set files
Name of the target server
Target server’s network address
In a heterogeneous environment that uses applications built for versions 10.x and later, you must explicitly set the SYBASE, SYBASE_OCS, and PATH environment variables at the command prompt, to point to the current version of the Open Client and Open Server installation.
For example, for applications using 15.0 products, installed in C:\SYBASE, open a command prompt and set the following environment variables:
set SYBASE=C:\SYBASE
set SYBASE_OCS=OCS-15_0
set PATH=%PATH%;%SYBASE%\%SYBASE_OCS%\bin; %SYBASE%\%SYBASE_OCS%\dll
Open Server uses the values of the following POSIX environment variables as locale names:
LC_ALL
LANG, if LC_ALL is not defined
Open Server later uses this value to obtain localization information from the locales.dat file. If neither environment variable is defined, Open Server uses “default” as the locale name.
Open Server looks in the locales.dat file for an entry whose name matches the locale name determined in step 2. Open Server then loads the localized messages and character set files specified in the locales.dat file.
Name of the target server. Open Server obtains the name of the Open Server application from one of the following sources, in the order listed:
The Open Server application, which can provide the server name in the call to srv_init
The DSLISTEN environment variable, if the application does not specify its name
The default name SYBASE, if DSLISTEN is not set
Target server’s network address. Open Server gets the target server’s addresses from the directory service or from sql.ini:
Directory service – Open Server looks for an entry in the [NT_DIRECTORY] section of the libtcl.cfg file to determine where to look up server address information. The setting of the CS_DS_PROVIDER property determines which [NT_DIRECTORY] entry the application searches for, or defaults to the first entry of the [NT_DIRECTORY] section.
sql.ini file – if a directory service is not used, or if it is used and fails, Open Server searches for the SERVERNAME entry in sql.ini that matches the name as determined in step 4 and uses the corresponding target address.
In a heterogeneous environment that uses applications built for releases 10.0.x and later, you can maintain a single sql.ini file by passing the address file name explicitly to each application, for example:
isql -Usa -P -Sconnect50 -Ic:\sybase\ini\sql.ini
When a client requests a connection that uses a network-based security mechanism, Open Server looks up the corresponding security driver in the [SECURITY] section of libtcl.cfg.
