FreeTDS User Guide: A Guide to Installing, Configuring, and Running FreeTDS
Prev | Chapter 7. How to get what works with it working | Next

# SybSQL

SybSQL is a Qt-based GUI interface to Sybase databases that uses the db-lib API.

SybSQL has a fairly basic build process that simply uses a Makefile. In order for SybSQL to find Qt and FreeTDS you need to define `QTDIR` and `SYBASE` environment variables. If you have Qt installed, you may have `QTDIR` defined already. To verify, type echo $QTDIR at the shell prompt. This example uses my own installation path of `qt-2.3.1` (from RedHat 7.2), YMMV.

    $ export QTDIR=/usr/lib/qt-2.3.1
    $ export SYBASE=/usr/local
    $ make

When finished you'll have an executable named `sybsql` that you can run.

One caveat to the way in which SybSQL and FreeTDS interact is that SybSQL expects to be running under OpenClient, and makes the assumption that a valid `$SYBASE``/interfaces` file exists. Since FreeTDS has deprecated use of the `interfaces` file in favor of the `freetds.conf` config file, you may have to create a `interfaces` file just to satisfy SybSQL.

By defining `SYBASE` to the parent directory of the `interfaces` file, you may put it wherever you like; it does not have to be in `/usr/local`. When using `freetds.conf`, FreeTDS does not rely on the `SYBASE` variable for finding its own components, so it is safe to point it elsewhere.

Prev | Home | Next
PHP | Up | Python