Progress
DataServer
for ODBC Guide
Guidelines for Using the DataServer
Progress supports many capabilities not found in other database management systems, such as backward scrolling cursors and the ability to find the previous or last record in a table. The DataServer supports these and other programming and database features to ensure that your applications work with both Progress databases and ODBC data sources.
The DataServer allows you to use Progress features as extensions to your data source. Some of the Progress programming and database design techniques that you can implement on your ODBC data source using the DataServer are:
For access to some of these features, you might have to make minor modifications to how your ODBC data source or application is organized. For a discussion of these issues and instructions for modifying your data source, see Programming Considerations."
If you create an ODBC data source from an existing Progress database with the Progress-to-ODBC migration utility and select the Create Extended 4GL Objects option, you can use the FIND PREV/LAST statements, and case-insensitive indexes with the resulting ODBC data source, in addition to taking advantage of Progress-like cursor behavior.
How you use the DataServer depends on whether you plan to access information in a data source through a Progress application, migrate a Progress database to an ODBC data source, or upgrade to the Version 9 DataServer for ODBC. The following sections summarize what you must do and point you to the information you need in this manual.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |