ODBC worksheet

The ODBC interface runs in a network environment and uses the standard Windows ODBC configuration. The ODBC task is capable of data interchange between IWS and any database supporting this interface.

Note: In addition to configuring the ODBC worksheet, you must configure the Windows ODBC standard driver. IWS refers to the User DSN (Data Source Name), which you configure through the Control Panel. For more information, refer to your Windows documentation.

Also, the ODBC interface is not available for projects running on Windows Embedded target systems.

To create a new ODBC worksheet, do one of the following:

To edit an existing ODBC worksheet, double-click it in the Project Explorer.

A new worksheet displays, as follows.
Figure 1. ODBC worksheet

ODBC worksheets are executed under the ODBC Runtime task. However, creating a new worksheet does not automatically enable the task; you must use the Execution Tasks dialog (Tasks on the Home tab of the ribbon) to configure the task to start at runtime. For more information, please see Execution Tasks.

The ODBC worksheet is divided into two areas:
Use the Header parameters on this worksheet as follows:
Use the Body parameters on this worksheet as follows:
You must use the Windows Control Panel to set up the ODBC interface for Excel files. The procedure is as follows:
  1. Click the Start > Settings > Control Panel.
  2. When the Control Panel window displays, double-click on the ODBC icon to open the ODBC Data Source Administrator dialog.
  3. In the ODBC Data Source Administrator dialog, click Excel Files in the User Data Sources list, and then click the Configure button.
  4. When the ODBC Microsoft Excel Setup dialog displays, type the Windows configuration name to be used in the DSN field on ODBC worksheet into the Data Source Name field.
  5. Click the Select Workbook button to configure the Excel file you want to use.
  6. Return to the ODBC Data Source Administrator dialog and verify that your User DSN displays in the list. Click OK to close the dialog.
  7. After configuring the ODBC Windows interface, you must configure the project's ODBC worksheets.
  8. From the Tasks tab, insert a new ODBC worksheet.
  9. Be sure you set the ODBC Runtime to start automatically using the Execution Tasks dialog (Tasks on the Home tab of the ribbon).

To start this configuration, you simply need to run the project. Your project will handle the Select, Next, Insert, Delete, and Update triggers to allow data to exchange throughout rows in Excel and tags configured in the worksheet.

Consult your Windows documentation for the meaning of specific error codes.

The following is a list of IWS error codes: