Progress
DataServer
for ODBC Guide


DataServer Components

The DataServer is a set of software components that allows Progress and WebSpeed applications to access data in a supported ODBC data source. The DataServer enables access by translating standard Progress and WebSpeed code into calls appropriate to the ODBC data source. The application can thus manipulate the data from all supported ODBC data sources as though it were Progress-based data.

The DataServer consists of the components described in Table 1–1.

Table 1–1: DataServer Architecture Components 
Component
Description
Enterprise DataServer for ODBC
Personal DataServer for ODBC
A Progress software module that allows you to use Progress or WebSpeed with a supported ODBC data source.
ODBC Driver Manager
(Windows platforms only)
A software module that manages the connection between an application and ODBC drivers. It is implemented on Windows by default as a Microsoft-supplied dynamic link library (DLL) module.
Schema holder
A repository for data definitions for one or more ODBC data sources.
ODBC driver
(Windows platforms only)
A software module that implements the ODBC Application Programming Interface (API) specification. The driver interfaces between the ODBC Driver Manager and the associated data source. A separate ODBC Driver is required for each data source.
ODBC data source
(Windows platforms only)
A name that identifies a specific set of data and how to obtain it. You must register a supported database as an ODBC data source.
ODBC Administrator
(Windows platforms only)
A Microsoft program for registering and configuring data sources. You register a data source by providing information that the ODBC driver needs through the ODBC Administrator. Note that this registration method is used only in Windows platforms.
DataServer ODBC utilities
A set of utilities that allows you to perform certain tasks related to the DataServer. You access them from the Progress Data Administration tool.

Figure 1–1 illustrates how the DataServer components are organized for both the Enterprise and the Personal DataServer for ODBC.

Figure 1–1: Architecture for DataServer for ODBC

As shown in Figure 1–1, the components for the Personal DataServer for ODBC are organized similar to the Enterprise edition except that the DataServer is embedded in the client rather than executing separately.

In either case, a Progress or WebSpeed application uses the DataServer to work with the ODBC Driver Manager, which accesses the desired ODBC driver. The driver then accesses the relevant ODBC data source manager, which in turn accesses the data in the associated ODBC data source. Note that there is a separate ODBC driver for each supported data source.

Some of the DataServer components are linked with elements of the standard Progress architecture, as described in the “DataServer Configurations” section.


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