20751-12 Rev.5 4-3
ODBC Driver Managers
For performance reasons, depending on the database management system software used,
some API functions may bypass the driver manager and access the ODBC driver directly.
ODBC Driver Manager Functions
The driver manager handles a number of functions that all ODBC applications need, regard-
less of the particular ODBC driver they use or the data source they access. The functions of
the driver manager include the following:
Loading into memory the ODBC driver required by the application and the data source
it is accessing.
Unloading from memory ODBC drivers when they are no longer needed.
Passing ODBC API function calls from the application to an appropriate ODBC driver.
Performing any required ODBC API function call conversions. For example, if an ODBC
application issues ODBC 2.5 function calls and is using an ODBC 3.0 driver, the driver
manager converts ODBC 2.5 function calls to their ODBC 3.0 equivalents when
necessary.
Performing error checking and validation functions on ODBC API function calls before
passing them to the ODBC driver.
Performing some character set conversions. For example, if the application uses an
8-bit ASCII character set, and the ODBC driver and DBMS work with character data in
16-bit Unicode format, the driver manager does the necessary character conversions.
Note: The driver manager component is used only with ODBC. There is no separate driver
manager component in the JDBC architecture. With JDBC, all driver manager functions are
performed in the Java application environment.
Windows Driver Managers
Microsoft provides a driver manager for the Windows environment. The ODBC driver man-
ager is part of the Microsoft Data Access Component (MDAC) and, as such, is part of the
Windows operating system. Therefore, you do not have to install a driver manager in the
Windows environment to use the Netezza ODBC drivers.
Linux/UNIX Driver Managers
To use the Netezza ODBC drivers in a Linux/UNIX environment, you must install an appro-
priate driver manager. You can get driver manager components from a number of sources.
Open Source — There are a number of driver managers available on the Web from open
source software projects. Netezza supports the unixODBC driver manager component
for Linux/UNIX platforms. You can find information about unixODBC at the following:
http://www.unixodbc.org
Commercial — A number of commercial software vendors develop and market ODBC
components, including driver managers. Netezza has licensed and provides support for
the DataDirect driver manager from DataDirect Technologies. It is included with your
system on it's own CD. The DataDirect driver manager component comes with some
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentáře k této Příručce