Wind River Spas TORNADO Specifikace stáhnout pdf (Strana 33)

4-1

C H A P T E R 4

ODBC Drivers and Driver Managers

What’s in this chapter

 ODBC Drivers

 ODBC Driver Managers

This chapter explains ODBC drivers and driver managers.

You can have only one ODBC driver installed on your system at a time. If you need a differ-

ent driver, remove the installed driver and install the different one. For more information on

this procedure, see Chapter 3, “Installing and Uninstalling Client Tools.” For driver instal-

lation and configuration detail, see Chapter 5, “Installing and Configuring ODBC.”

ODBC Drivers

An ODBC driver uses a layer of code that translates the ODBC standard API calls the appli-

cation issues into vendor-specific functions. Netezza supplies different versions of the

ODBC driver for each supported platform, each vendor’s DBMS or data source type, each of

the major ODBC versions, and for each major release level of the Netezza appliance.

ODBC drivers expose the capabilities of the underlying data source, and each ODBC driver

is designed for a particular database management system. For example, an ODBC driver

designed to access a different vendor database cannot be used to access a Netezza

database.

ODBC Driver Functions

ODBC drivers do a variety of functions, including the following:

 Connecting to and disconnecting from data sources.

 Performing error checking functions.

 Submitting SQL statements to the database management system software for execu-

tion against a particular data source.

 Converting ODBC-standard SQL statements, if necessary, to DBMS-specific SQL

statements.

 Sending data to and retrieving data from a data source.

 Performing data conversion functions, as specified by the application.

 Returning information about the success or failure of an ODBC function.

1 2 ... 28 29 30 31 32 33 34 35 36 37 38 ... 77 78

Žádné komentáře

Wind River Spas TORNADO Specifikace Strana 33