Configuring ODBC Connections for Oracle

The procedures for creating connections for Oracle and SQL are similar.

Before you begin

To launch the ODBC Data Source Administrator from Windows, in the system folder, Control Panel > Administrative Tools > Data Sources (ODBC) For easy access, create a shortcut to the ODBC executable file.

Procedure

  1. Open the ODBC Data Source Administrator.
  2. On the System DSN tab, click Add.
    The Create New Data Source dialog is displayed.
  3. Choose Microsoft ODBC for Oracle from the list.
  4. Click Finish.

    The Microsoft ODBC for Oracle Setup dialog is displayed.

  5. In the Name and Description fields, type an appropriate name and description for the data source, and then type the Oracle SID of the database.
  6. Click OK.
  7. In the ODBC Data Source Administrator dialog, click OK to complete the connection.

    For more information on the ODBC, please refer to the appropriate vendor documentation.