skip to main content
OpenEdge Data Management: DataServer for ODBC
Programming Considerations
 

Programming Considerations

An application developed in the OpenEdge Studio can use the DataServer for ODBC to access data from multiple sources transparently. With the DataServer, your applications can access information in both OpenEdge databases and supported foreign ODBC data sources.
This chapter discusses the differences between OpenEdge databases and supported ODBC data sources that you must consider when you plan your applications and design your databases. The chapter also describes DataServer strategies for resolving these differences, which your application might need to accommodate. Follow these guidelines carefully when you develop your application to ensure that it can access OpenEdge databases and ODBC data sources transparently.
The material in this chapter is also of interest to users who plan to migrate an OpenEdge database to an ODBC data source. However, such a migration raises additional issues that you must consider when designing your application. For details, see Running the OpenEdge DB-to-ODBC utility.
In this section: 
* Database design issues
* Record creation
* Data-source record locking
* Transactions
* Error handling
* Cursors
* ABL issues
* Stored procedures
* Enhancing DataServer performance