Installation guide

Configuring ODBC

EAServer

If isql shows a command prompt and not an error message, the connection

is successful.

Using ODBC to connect to ASE

If you are using ASE as a data source, and FreeTDS as the database driver, you

must configure the EAServer.

1 Add the data source information to $JAGUAR/freetds/etc/freetds.conf file.

For example, to connect to the

MySybase sample database, enter:

[MySybase]

host = ASE hostname

port = 5000

tds version = 5.0

where:

• host – is the server machine’s host name or IP address.

• port – is the database server’s TDS listener port.

Test the connection to

MySybase using the command-line tool in

$JAGUAR/freetds/bin/tsql.

./tsql -S MySybase -U dba -P dba

If the connection is successful, the data source name should be the same

as the ASE database name. This implies that FreeTDS is working

correctly.

2 Modify the odbcinst.ini file in $JAGUAR/unixodbc to include the ODBC

data source information. Add an ODBC driver item to include the

FreeTDS ODBC library. For example:

[SYBASE]

Description = Sybase ASE ODBC Driver

Driver = $JAGUAR/freetds/lib/libtdsodbc.so

Setup = $JAGUAR/unixodbc/lib/libtdsS.so

TDS_Version = 5

UsageCount = 3

CPTimeout =

CPReuse =

3 Add the ODBC data source information to $JAGUAR/unixodbc/odbc.ini.

For example:

[testase]