• Products >
• Support >
• Solutions
• Company
• Blog

• < Back
• ODBC drivers >
• JDBC drivers >
• Bridges, gateways >
• Other >
• All products

• < Back
• JDBC-ODBC Bridge
• JDBC-Access Gateway

• < Back
• ODBC-ODBC Bridge
• ODBC-JDBC Gateway
• dbExpress-ODBC Gateway
• XML-ODBC Server

• < Back
• ODBC-ODBC Join Engine
• SDK
• Consultancy
• Roadmap

SQL Workbench/J

SQL Workbench/J is a free SQL query, import, export, and diff tool for various databases.

SQL Workbench/J supports JDBC, enabling it to connect to databases for which a JDBC driver is available. The Easysoft JDBC-ODBC Bridge extends the number of databases that are available to SQL Workbench/J by bridging between JDBC and ODBC. You can then also work with data from back ends for which an ODBC driver is available. For example, you can connect SQL Workbench/J to Microsoft Access by using the Easysoft JDBC-ODBC Bridge and the ODBC driver for Microsoft Access.

These steps show how to work with ODBC data in SQL Workbench/J on Windows:

1. Configure a system ODBC data source for the database that you want to connect to in SQL Workbench/J.

   To do this, use the 32-bit version of ODBC Data Source Administrator on your SQL Workbench/J machine. On some versions of Windows, this is located in Control Panel > Administrative Tools. On some version of Windows, you need to search for "ODBC" in the taskbar search box. The 32-bit version of ODBC Data Source Administrator should be clearly labelled. If in doubt, in the Windows Run dialog box, enter:

   %windir%\syswow64\odbcad32.exe

2. Download the Easysoft JDBC-ODBC Bridge.
3. Install and license the Easysoft JDBC-ODBC Bridge on the machine where you created the data source.

   For installation instructions, refer to the Easysoft JDBC-ODBC Bridge documentation.

4. In SQL Workbench/J, choose File > Manage Drivers.

   The Manage Drivers dialog box is displayed.

5. Choose new entry button at the top left of the dialog box.
6. Complete the dialog box fields:

   Setting	Value
   Name	JOB
   Class	easysoft.sql.jobDriver
   Library	Browse to and select the Easysoft JDBC-ODBC Bridge JAR file, EJOB.jar. EJOB.jar is installed in the following location on the machine where you installed the Easysoft JDBC-ODBC Bridge: easysoft_install\Jars On 64-bit Windows, the default location for easysoft_install is drive:\Program Files (x86)\Easysoft Limited\Easysoft JDBC-ODBC Bridge. If necessary, copy EJOB.jar to the machine where you have installed SQL Workbench/J.
   Sample URL	jdbc:easysoft://my_job_machine/my_odbc_data_source:logonuser=my_windows_user:logonpassword=my_windows_password

7. Choose OK.
8. Choose File > New Connect Window.

   The Select Connection Profile dialog box is displayed.

9. Choose JOB (easysoft.sql.jobDriver) from the Driver list.
10. Choose OK from the Driver list.
11. Execute a SQL query against the new database connection in the statement. For example:

    SELECT * FROM Suppliers