Testing DataDirect Wire Protocol Drivers on Windows

  To test a data source name connection:

1. Click Test Connect.

   The Login to Wire Protocol dialog box for your RDBMS is displayed.

2. In the User Name and Password text boxes, enter a valid user name and password for this data source connection, and click OK.

   If an error message is displayed, make the necessary corrections, and click Test Connect again.

   When no errors occur, a dialog box displays the message, Connection established!

3. In the message dialog box, click OK.

   You are returned to the ODBC Wire Protocol Driver Setup dialog box.

4. In the ODBC Wire Protocol Driver Setup dialog box, click OK.

   You are returned to the System DSN tab of the ODBC Data Source Administrator dialog box. The data source name that you entered and the driver that you mapped to the data source name are displayed in the System Data Sources list box.

5. Repeat Step 1 through Step 5 in Configuring DataDirect Wire Protocol Drivers in Windows to configure a data source name for an OLAP Metadata Catalog database.

6. When you have completed configuration of all needed data source names, click OK to close the ODBC Data Source Administrator dialog box.