The Progress® DataDirect Connect® Series for ODBC™ provides ODBC drivers for a number of leading databases, as well as flat-file database systems. The drivers are compliant with the Open Database Connectivity (ODBC) specification and compatible with ODBC 3.8 applications. The drivers are tested and supported across numerous platforms. Progress DataDirect Connect Series for ODBC includes the following products:

  • DataDirect Connect for ODBC
  • DataDirect Connect64 for ODBC
  • DataDirect Connect XE (Extended Edition) for ODBC
  • DataDirect Connect64 XE for ODBC
Note: This guide contains information for the 7.1.6 version of the ODBC drivers. For 8.0 and higher version of the drivers, documentation is available at the Progress DataDirect Connectors Documentation page.

The content of this guide assumes that you are familiar with your operating system and its commands. It contains the following information:

  • Quick Start Connect explains the basics for quickly configuring and testing the drivers.
  • General Information on Using Connect Drivers explains the drivers and ODBC, and discusses environment-specific subjects.
  • Advanced Features explains at a general level advanced driver features such as failover, security, connection pooling, and bulk load.
  • Configuring the Product on UNIX/Linux discusses UNIX and Linux environment variables and configuration of the drivers. It also provides a sample system information file, as well as discussing other driver tools for UNIX and Linux.
  • A chapter for each database driver. Each driver’s chapter is structured in the same way. First, it lists which versions of the databases the driver supports, the operating environments in which the driver runs, and the driver requirements for your operating environment. Next, it explains how to configure a data source and how to connect to that data source. Finally, the chapter provides information about data types, ODBC conformance levels, isolation and lock levels supported, and other driver-specific information.

The documentation for DataDirect Connect Series for ODBC drivers also includes the Progress DataDirect for ODBC Drivers Reference. The reference provides general reference information for all DataDirect drivers for ODBC, including content on troubleshooting and supported functions. For the complete documentation set, visit the Progress DataDirect Connectors Documentation Hub.

If you are writing programs to access ODBC drivers, you need to obtain a copy of the ODBC Programmer’s Reference for the Microsoft Open Database Connectivity Software Development Kit, available from Microsoft Corporation.

For the latest information about the specific drivers available for your platform, refer to the readme file in your software package.

Database drivers are continually being added to each operating environment. For the latest information about the specific drivers available for your platform, refer to the readme file in your software package, or refer to the DataDirect Product Compatibility Guide at the DataDirect Product Compatibility Guide.

Note: This guide refers the reader to Web pages using URLs for more information about specific topics, including Web URLs not maintained by Progress DataDirect. Because it is the nature of Web content to change frequently, Progress DataDirect can guarantee only that the URLs referenced in this guide were correct at the time of publication.