Basic ODBC Application Steps

This section describes the general flow of ODBC applications. It is unlikely that any application calls all of these functions in exactly this order. However, most applications use some variation of these steps. The basic application steps are shown in the following illustration.

This section contains the following topics.

• Step 1: Connect to the Data Source

• Step 2: Initialize the Application

• Step 3: Build and Execute an SQL Statement

• Step 4a: Fetch the Results

• Step 4b: Fetch the Row Count

• Step 5: Commit the Transaction

• Step 6: Disconnect from the Data Source