Registering a JDBC Driver

To connect to a database at design time from within the Query Database task, you must first register the JDBC driver.

1. Navigate to the Data Source Explorer tab.
2. Right-click Database Connections and select New... .
   The Connection Profile pane displays.
3. Select the driver from the list of Connection Profile Types and click Next.
   The Specify and Driver and Connection Details pane displays.
4. Click the New Driver Definition icon location to the right of the Drivers drop-down list.
   The New Driver Definition dialog box displays.
5. Select the JDBC Driver in the Available driver templates list of the Name/Type tab.
6. Navigate to the Jar List tab.
   The jar file for the selected database is listed in the list of driver files..
7. Select the JAR file (generated according to the selected JDBC driver) and click Remove JAR/Zip.
8. Click Add JAR/Zip.
9. In the Select the file dialog box select the driver appropriate for your database, and click Open.
10. Click OK.