Progress
DataServer
for ODBC Guide


DataServer for ODBC Logic

The flow chart in Figure 1–2 illustrates the DataServer’s internal logic.

Figure 1–2: DataServer Logic

As shown in Figure 1–2, when you execute an application that accesses a supported data source, the Compiler translates Progress 4GL or SpeedScript statements into their SQL equivalents. The DataServer then issues the SQL statements to the appropriate ODBC driver through the ODBC API. The driver, which provides the software mechanisms for accessing and controlling the data source, processes the SQL statements, transfers them to the data source manager, and returns the results to Progress through the ODBC API.

In order to facilitate the flow of statements between client and server, the DataServer places Progress equivalents for data definitions from a supported data source into a schema holder (a repository for data definitions for one or more ODBC data sources). When the Progress client or WebSpeed Agent executes statements and retrieves information from the data source, it relies on data definitions in the schema holder.


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