Connecting to ODBC databases

The connection to an ODBC database is defined by selecting an ODBC driver using the ODBC Data Source Administrator. The steps to define a connection cannot be generalized since they are dependent on the database. Thus, it is necessary for the user to be familiar with creating an ODBC data source to the ODBC database, which will be accessed by OpenDB.

CAUTION:

At this time, record locking is not supported by OpenDB. Thus, if data is to be edited, inserted, updated, or deleted in the ODBC database, and not simply viewed, it is important to know that another user is not editing the data.

This section provides examples illustrating OpenDB connecting to and accessing data from ODBC databases.