All Open Client applications require some basic configuration information, obtained during initialization and connection, including:
Items 1-3 (do not apply to DB-Library)
occur when the Open Client Client-Library application calls the cs_ctx_alloc or cs_ctx_global routine. Items
4 through 6 occur when the Open Client application calls ct_connect.
The location of the Sybase installation directory as defined by the SYBASE environment variable.
A locale name. Open Client uses the values of the following POSIX environment variables as locale names:
LC_ALL
LANG, if LC_ALL is not defined
Open Client later uses this value to obtain localization information from the locales.dat file. If neither environment variable is defined, Open Client uses “default” as the locale name.
Localized message and character set files. Open Client looks in the locales.dat file for an entry whose name matches the locale name determined previously. Then, it loads the localized messages and character set files specified in the locales.dat file.
The name of the target server. Open Client obtains the name of the target server from one of the following sources, in this order:
The client application, which can provide the server name in the call to ct_connect (or dbopen). Some applications, such as isql, can specify the name of the target server through command line options.
The DSQUERY environment variable, if the application does not specify the target server.
The default name SYBASE, if DSQUERY is not set.
The target server’s network address. Open Client obtains the target server’s addresses from the directory service or from interfaces. DB-Library does not examine the libtcl.cfg file, it accesses the interfaces file:
Directory service – Open Client looks for an entry in the [DIRECTORY] section of libtcl.cfg to determine where to look up server address information. The setting of the CS_DS_PROVIDER property determines which [DIRECTORY] entry the application searches for, or defaults to the first entry of the [DIRECTORY] section.
interfaces – If a directory service is not used, or if it is used and fails, Open Client searches for the SERVERNAME entry in interfaces that matches the name as determined previously and uses the corresponding target address.
The name of the security service driver (does not apply to DB-Library). Open Client looks in the [SECURITY] section of libtcl.cfg to determine which security driver to load.
Refer to Chapter 6, “Using Security Services,” for more information on security services.
Adaptive Server version 15.0 can store data that has different limits than data stored in previous versions. The Client-Library clients can use the new limits, providing the version is set to CS_VERSION_150 at init time, but the DB-Library clients cannot. Clients also must be able to handle the new limits the data can use. Open Client version 15.0 supports Adaptive Server 15.0 limits. If you are using earlier versions of Open Client and Open Server, they cannot process the data if you:
Upgrade to Adaptive Server version 15.0
Drop and recreate the tables with wide columns
Insert wide data