How to Configure Oracle 11g Data Source Drivers

Available in the Enterprise edition only.

To configure a data source for connecting to an Oracle 11g server, follow these steps:

  1. Go to http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html and download the Oracle 11g JDBC driver called ojdbc6.jar.
  2. Open the Preferences dialog box (Options > Preferences) and go to Data Sources.
  3. Click the New button in the Data Sources panel.

    The dialog box for configuring a data source is opened.

    Figure: Data Source Drivers Configuration Dialog Box

  4. Enter a unique name for the data source.
  5. Select Oracle in the driver Type drop-down menu.
  6. Click the Add Files button and select the Oracle driver file that you downloaded.
    The Oracle driver file is called ojdbc5.jar.
  7. Select the most appropriate Driver class.
  8. Click the OK button to finish the data source configuration.
  9. Continue on to configure your Oracle connection.