Progress
DataServer for
Microsoft SQL Server
Guide


DataServer Components

The DataServer is a set of software components that allows Progress and WebSpeed applications to access data in the data source. The DataServer enables access by translating standard Progress and WebSpeed code into calls appropriate to the data source. The application can thus manipulate the data 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 SQL Server™
Personal DataServer for SQL Server™
A Progress software module that allows you to use Progress or WebSpeed.
ODBC Driver Manager
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 foreign data definitions.
ODBC driver
A software module that implements the ODBC Application Programming Interface (API) specification. The driver interfaces between the ODBC Driver Manager and the data source.
ODBC data source
A name that identifies a specific set of data and how to obtain it. You must register a SQL Server™ 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 MSS 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 SQL Server™.

Figure 1–1: Architecture for DataServer for SQL Server™

As shown in Figure 1–1, the components for the Personal DataServer for SQL Server™ are organized similarly 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 SQL Server™ database.

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