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:
- Go to http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html and download the Oracle 11g JDBC driver
called
ojdbc6.jar. - Open the Preferences dialog box and go to Data Sources.
- Click the
New button in the
Data Sources panel.The dialog box for configuring a data source is opened.
Data Source Drivers Configuration Dialog Box
- Enter a unique name for the data source.
- Select Oracle in the driver Type drop-down menu.
- Click the Add Files button and select the Oracle driver file
that you downloaded.The Oracle driver file is called
ojdbc5.jar. - Select the most appropriate Driver class.
- Click the OK button to finish the data source configuration.
- Continue on to configure your Oracle connection.