Testing the ODBC Connection

Make sure to test the ODBC connection to the Oracle database.

  1. After setting up the connections to the Oracle database, click Test Connection.

    The Oracle ODBC Driver Connect dialog box is displayed.

  2. (If applicable) Type your login information in the User Name and Password fields.
  3. Click OK.

    If the connection is successful, a message box indicating a successful connection is displayed. Otherwise, an error message is displayed advising you that the system is unable to connect.

    If there is an error, resolve the problems indicated in the error message, for example, invalid user name.

  4. Click OK.