Business Intelligence Tutorial

Registering a database with ODBC

There are several ways that you can register a database with ODBC. You can use the Client Configuration Assistant on Windows NT, the Command Line Processor, or the ODBC32 Data Source Administrator on Windows NT. In this exercise, you will use the Client Configuration Assistant.

For more information about the Command Line Processor, see the DB2 Universal Database Command Reference. For more information about the ODBC32 Data Source Administrator, see the online help in the Administrator.

To register the TUTWHS database with ODBC:

  1. Start the Client Configuration Assistant by clicking Start --> Programs --> IBM DB2 --> Client Configuration Assistant. The Client Configuration Assistant window opens.
  2. Select TUTWHS from the list of databases.
    Figure db2tu058 not displayed.
  3. Click Properties. The Database Properties window opens.
  4. Select Register this database for ODBC. Use the default selection of As a system data source, which means that the data is available to all users on the system.
    Figure db2tu059 not displayed.
  5. Click OK. All other fields are optional. The TUTWHS database is registered with ODBC.

    The Properties and Settings push buttons in the Client Configuration Assistant window are used to optimize your ODBC connections and configuration. You do not need to adjust these properties or settings for the tutorial, but there is online help available if you need to work with them in your daily environment.

  6. Click OK to close the DB2 Message window.
  7. Close the Client Configuration Assistant.


[ Top of Page | Previous Page | Next Page | Table of Contents ]