Using UNIX-based query tools through ODBC

Applications that use ODBC connect to a software component called a driver manager, which provides a standard interface and a variety of basic services. The driver manager then connects to the specific ODBC driver, which accesses the requested data source. On Windows, the driver manager is a standard part of the environment. On UNIX or Linux, no standard ODBC driver manager is provided.

There are several ways driver manager functionality can be presented to an application. It is easiest to use the driver manager emulation capabilities provided by the Sybase IQ ODBC driver. Many tools (like Brio) that do not require extensive driver manager services can use the symbolic links provided with Sybase IQ to connect directly to the driver.

Some tools require the presence of a driver manager. Some (like Whitelight) ship with a driver manager, others do not. For information and recommendations about compatible driver managers available, see the documentation for the application.