Progress
ODBC Driver Guide


Glossary

Add [an ODBC data source]

Make a data source available to ODBC through the Add operation of the ODBC Administrator. Adding a data source tells ODBC where a specific database resides and which ODBC driver to use to access it. Adding a data source also invokes a setup dialog box for the particular driver so you can provide other details the driver needs to connect to the database.

Client

In client/server systems, the part of the system that sends requests to servers and processes the results of those requests.

Data Source

See ODBC Data Source.

Delete [an ODBC data source]

Removes information about an ODBC data source through the Delete operation of the ODBC Administrator utility. Deleting a data source does not delete the database it corresponds to, but removes information about the database’s location from the \%WINDIR%\ODBC.INI file.

Delimited Identifiers

Names in SQL statements that are enclosed in double quotation marks ("). Enclosing a name in double quotation marks preserves the case of the name and allows it to include reserved words and special characters. Subsequent references to a delimited identifier must also use enclosing double quotation marks.

ODBC Administrator

Microsoft-supplied utility to add and delete ODBC data sources and drivers. The installation procedure installs the Administrator if it is not already present on a system. To invoke it, click on the ODBC icon in the Control Panel applications of the Windows Program Manager.

ODBC Application

Any program that calls ODBC functions and uses them to issue SQL statements. Many vendors have added ODBC capabilities to their existing Windows-based tools.

ODBC Data Source

In ODBC terminology, a specific combination of a database system, the operating system it uses, and any network software required to access it. Before applications can access a database through ODBC, you use the ODBC Administrator to add a data source—register information about the database and an ODBC driver that can connect to it—for that database. More than one data source name can refer to the same database, and deleting a data source does not delete the associated database.

ODBC Driver

Software that processes ODBC function calls for a specific data source. The driver connects to the data source, translates the standard SQL statements into syntax the data source can process, and returns data to the application.

ODBC Driver Manager

A Microsoft-supplied program that routes calls from an application to the appropriate ODBC driver for a data source.

SQL Engine

The core internal component of Progress SQL-92. The SQL engine receives requests from the Progress SQL-92 ODBC driver, processes them, and returns results.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095