About This Book

This book describes how to use Caché ODBC, which enables you to connect to Caché from an external application (such as a development tool or report writer) via ODBC, and allows Caché to access external ODBC data sources.

In order to use this book, you should be reasonably familiar with your operating system. If you are performing custom configuration of the Caché ODBC driver on UNIX®, you should also be familiar with using UNIX®, compiling and linking code, writing shell scripts, and other such tasks.

This book is organized as follows:

• The chapter “Overview” provides an overview of Caché ODBC.

• The chapter “Using Caché as an ODBC Data Source on Windows” describes how to use Caché as a ODBC data source on Windows.

• The chapter “Using Caché as an ODBC Data Source on UNIX®” describes how to use Caché as a ODBC data source on UNIX®.

• The chapter “Using the Caché SQL Gateway with ODBC” describes how to use ODBC and the SQL Gateway to link to an external table or stored procedure, and how to migrate data from an external table.

• The chapter “Logging” describes how to enable logging for both Caché and ODBC.

• The chapter “ODBC Environment Variables” describes the environment variables that control the Caché ODBC client driver.

For more information, try the following sources:

• The book Using Caché with JDBC includes information on JDBC connectivity to Caché from external data sources (the JDBC equivalent of what is described in this manual).

• The chapter on “Using the Caché SQL Gateway” in Using Caché SQL provides an overview of how the SQL Gateway works with both ODBC and JDBC.

In addition, any technical bookstore offers a wide selection of books on SQL and ODBC.