Drivers :: Getting Started (Database Toolbox)

Database Toolbox

Drivers

For Windows platforms, the Database Toolbox supports Open Database Connectivity (ODBC) drivers used with the supported databases. For UNIX and Windows platforms, the Database Toolbox supports Java Database Connectivity (JDBC) drivers. If you use JDBC drivers on a Windows platform, you cannot use the Visual Query Builder.

The driver for your database must be installed in order to use the Database Toolbox. Most users (or their database administrators) install the driver when they install the database. Consult your database documentation if you need instructions to install a database driver. If your database does not ship with JDBC drivers, you can download drivers from the Sun JDBC web site, http://industry.java.sun.com/products/jdbc/drivers.

About Drivers for the Database Toolbox

An ODBC driver is a standard PC interface that enables communication between database management systems and SQL-based applications. A JDBC driver is a standard interface that enables communication between Java-based applications and database management systems.

The Database Toolbox is a Java-based application. To connect the Database Toolbox to a database's ODBC driver, the toolbox uses a JDBC/ODBC bridge, which is supplied and automatically installed as part of the toolbox.

The following illustrates the use of drivers with the Database Toolbox.

Databases Structured Query Language (SQL)