IBM GC09-2830-00 manual Platform Specic Details for CLI/ODBC Access

Platform Speci®c Details for CLI/ODBC Access

The platform speci®c details on how to give DB2 CLI and ODBC applications access to DB2 are divided into the following categories:

vªWindows 32-bit operating systems Client Access to DB2 using CLI/ODBCº

vªOS/2 Client Access to DB2 using CLI/ODBCº on page 125

Windows 32-bit operating systems Client Access to DB2 using CLI/ODBC

Before DB2 CLI and ODBC applications can successfully access a DB2 database from a Windows client, perform the following steps on the client system:

Step 1. The DB2 database (and node if the database is remote) must be cataloged. To do so, use the CCA (or the command line processor).

For more information refer to the on-line help in the CCA (or the CATALOG DATABASE and CATALOG NODE commands in the Command Reference).

Step 2. Verify that the Microsoft ODBC Driver Manager and the DB2 CLI/ODBC driver are installed. On Windows 32-bit operating systems they are both installed with DB2 unless the ODBC component is manually unselected during the install.

To verify that they both exist on the machine:

a.Run the Microsoft ODBC Administrator from the icon in the Control Panel, or issue the appropriate command from the command line: odbcad32.exe.

b.Click on the ODBC Drivers tab.

c.Verify that ²IBM DB2 ODBC DRIVER² is shown in the list.

If either the Microsoft ODBC Driver Manager or the IBM DB2 CLI/ODBC driver is not installed, then rerun the DB2 install and select the ODBC component on Windows 32-bit operating systems.

Step 3. Register the DB2 database with the ODBC driver manager as a data source. On Windows 32-bit operating systems you can make the data source available to all users of the system (a system data source), or only the current user (a user data source). Use either of these methods to add the data source:

vUsing the CCA:

a.Select the DB2 database alias that you want to add as a data source.

b.Click on the Properties push button. The Database Properties window opens.

c.Select the Register this database for ODBC check box.

Chapter 10. Running Your Own Applications 123