Installation guide

CHAPTER 5 Configuring Open Client and ODBC for EAServer
Installation Guide 73
Creating a unixODBC connection cache
When you create a unixODBC connection cache, you must define the “Server
Name” with the ODBC data source name. You can obtain the data source name
from the odbc.ini file, which is located in $JAGUAR/unixodbc.
Using ODBC to connect to ASA
Adaptive Server Anywhere is installed as part of both a typical and a full
installation. The installation includes the ODBC driver to connect to ASA
databases. For example, to connect to the
jagdemo sample database, specify the
absolute path to the ASA ODBC driver in the data source’s driver entry of the
$JAGUAR/unixodbc/odbcinist.ini file.
1 Use a text editor to modify the ODBC driver information in
$JAGUAR/unixodbc/odbcinst.ini.
For example:
[SYBASA]
Description = Sybase ASA9.0 ODBC Driver
Driver = $JAGUAR/SYBSasa9/lib/libdbodbc9.so
Setup = $JAGUAR/unixodbc/lib/libtdsS.so
TDS_Version = 5
UsageCount = 3
CPTimeout =
CPReuse =
2 Add ODBC data source information to $JAGUAR/unixodbc/odbc.ini. For
example:
[EAS Demo DB V10]
Driver = SYBASA
Trace = no
Tracefile = sql.log
Port = 2640
ServerName = easdemodb10
TDS_version = 5.0
The name of the driver must be the same as that defined in odbcinst.ini.
The server name is the database name without the extension.
To verify whether the connection is correct, go to
$JAGUAR/unixodbc/bin, and use the
isql command-line tool to execute:
./isql -v “EAS Demo DB V10” user password