Progress
DataServer
for ODBC Guide


Creating a Schema Holder

A schema holder contains a schema image of the ODBC data source that your DataServer application accesses. The schema image contains the schema for your data source—that is, its data definitions—in a Progress format. Although Progress applications can access a data source directly by sending SQL statements through the DataServer, they cannot directly access its data definitions and must use the schema-image information instead.

When you decide where to build your schema holder, consider your business needs and deployment strategy. The schema holder can reside on the client machine or on any host in an enterprise configuration. Client schema holders improve performance for some applications. Host schema holders give you the flexibility of having them run as NT services. Additionally, host schema holders might be easier to maintain. In a WebSpeed configuration, placing the schema holder on the Transaction Server machine optimizes performance.

In general, you must do the following to create a schema holder:

  1. Establish the appropriate permissions for pulling the schema image into the schema holder.
  2. Perform some preparatory steps.
  3. Create and then connect an empty Progress database. This database becomes your schema holder and contains your schema image.
  4. Create the schema holder, which involves specifying connection parameters and pulling the schema from the data source.

The following sections describe these steps in detail.


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