How to Configure a JDBC-ODBC Connection
To configure a connection to an ODBC data source, follow these steps:
- Open the Preferences dialog box and go to Data Sources.
-
Click the New button in the Connections panel.
The dialog box for configuring a database connection is displayed.
- Enter a unique name for the connection.
- Select JDBC-ODBC Bridge in the Data Source drop-down list.
-
Enter the connection details.
- Enter the URL of the ODBC source.
- Enter the user name of the ODBC source.
- Enter the password of the ODBC source.
- Click the OK button to finish the connection configuration.
- To view your connection, go to the Data Source Explorer view (if the view is not displayed, it can be opened by selecting it from the or switch to the menu)Database perspective.