Configuring DataDirect Wire Protocol Drivers in Windows

  To configure a data source name:

1. In the ODBC Data Source Administrator, click Add to open the Create New Data Source dialog box.

2. In the driver list box of the Create New Data Source dialog box, select the appropriate Wire Protocol driver for your RDBMS, and click Finish.

   The Wire Protocol Driver Setup dialog box for your RDBMS is displayed.

3. In the Data Source Name text box, type the name that you want to use for this data source connection.

   In the sample application, TBC is the data source name used to connect to the Data Source database called TBC; TBC_MD is the data source name used to connect to the sample OLAP Metadata Catalog database called TBC_MD.

4. Optional: If you want to record a description, in the Description text box, type a description that indicates how you use this data source name.

   For example, you might type the following to describe the My Business database:

   Customers, products, markets

   You might type the following to describe the sample application database:

   Sample relational data source 

   You might type the following to describe the sample OLAP Metadata Catalog database:

   Sample OLAP Metadata Catalog

5. Make the necessary entries to configure data source names by completing the set of steps appropriate to your RDBMS.

   Refer to the following sections for the specific configuration instructions for your RDBMS:

   • IBM DB2 UDB or DB2 OS/390

   • Oracle

6. Test the connection by following the procedures in Testing DataDirect Wire Protocol Drivers on Windows.