Easysoft ODBC-JDBC Gateway Getting Started Guide
This guide shows you how to download, install, and license the Easysoft ODBC-JDBC Gateway.
At the end, you'll be able to access your Java database from any Windows application that supports ODBC.
If you're installing to evaluate the ODBC-JDBC Gateway, the guide shows you how to obtain a free trial license with no restrictions for a period of 14 days.
Assumptions
- You're installing the ODBC-JDBC Gateway on a Windows system for which you have administrative privileges.
- You have a Java Virtual Machine (JVM) installed. If this is not the case, install a Java Runtime Environment (JRE) before proceeding. You can download a JRE (which includes a JVM) from either Oracle or IBM, both of which have been tested with the ODBC-JDBC Gateway.
To use the ODBC-JDBC Gateway with a 64-bit application, you need to install a 64-bit JVM. Likewise, to use the ODBC-JDBC Gateway with a 32-bit application, you need to install a 32-bit JVM.
- You have the necessary configuration details to access your target JDBC driver (a valid database user name and password, the driver class, the
CLASSPATH, and the JDBC URL). If don't have these values, refer to the documentation for your JDBC driver, contact your database administrator, or email . - You have unrestricted access to the Internet in order to complete the licensing part of the installation. If you're not online, you can get a license from Easysoft by telephone or email. For further information, refer to the Easysoft Licensing documentation (HTML or PDF).
Step 1: Download the ODBC-JDBC Gateway software
- Download the ODBC-JDBC Gateway for Windows.
- Save the distribution file to a temporary directory on your Windows machine.
Step 2: Install and license the ODBC-JDBC Gateway
- On your Windows machine, change into the directory where you saved the ODBC-JDBC Gateway distribution.
- Double-click the distribution file to start the installation.
- In the Easysoft License Manager, supply your contact details, then choose Request License. Choose Trial and then choose ODBC-JDBC Gateway from the product list. Choose Next and then choose On-line Request if your Windows machine is connected to the Internet. Otherwise, choose View Request and email the contents of the license request screen to .
- Choose Finish to exit the License Manager.
Step 3: Test your JVM
- In the Easysoft Start menu group, choose Configure Java Interface (64-bit) if your application is 64-bit. Otherwise, choose Configure Java Interface.
- Choose the ... button and then browse to you JVM.
- Choose the Test and Save if OK button.
Step 4: Configure an ODBC data source
- Start the Microsoft ODBC Data Source Administrator.
There is both a 32-bit and a 64-bit version of ODBC Data Source Administrator. To configure an ODBC data source for use with a 64-bit application, use the 64-bit version of ODBC Data Source Administrator. To run the 64-bit version, in the Windows Run dialog box, enter:
odbcad32.exe
To configure an ODBC data source for use with a 32-bit application, use the 32-bit version of ODBC Data Source Administrator. To run the 64-bit version, in the Windows Run dialog box, enter:
%windir%\syswow64\odbcad32.exe
If you're not sure whether your application is 32-bit or 64-bit, run the application and open Task Manager (right-click the taskbar, and then click Task Manager). If the application process has
*32after its name, it is a 32-bit application. Otherwise, it is a 64-bit application. - Click the System DSN tab and then click Add.
- Choose the ODBC-JDBC Gateway from the list of drivers and then click Finish. The Easysoft ODBC-JDBC Gateway DSN Setup dialog box is displayed.
- Complete the required fields and choose Test to validate your configuration.
Step 4: Access your data source
These steps use Microsoft Access as an example application:
- Open your Microsoft Access database.
- Do one of the following:
- For Microsoft Access 2003 and earlier, on the File menu, choose Get External Data > Link Tables.
The Link dialog box is displayed.
- For Microsoft Access 2007, on the External Data tab, choose More > ODBC Database.
The Get External Data wizard starts.
- For Microsoft Access 2010 and later, on the External Data tab, choose ODBC Database.
The Get External Data wizard starts.
- For Microsoft Access 2003 and earlier, on the File menu, choose Get External Data > Link Tables.
- Do one of the following:
- For Microsoft Access 2003 and earlier, choose ODBC Databases from the Files of type list.
- For Microsoft Access 2007 and later, choose Link to the data source by creating a linked table, and then choose OK.
The Select Data Source dialog box is displayed.
- Choose your ODBC-JDBC Gateway data source from the Machine Data Source list, and then choose OK.
The Link Tables dialog box is displayed.
- Choose the table that you want to link and then choose OK.
- Choose the linked table in Microsoft Access, and then choose RETURN to work with the linked data.
What next?
- You're now ready to use the ODBC-JDBC Gateway with your own applications or development tools.
Further support
- The ODBC-JDBC Gateway manual (HTML or PDF).
- The ODBC-JDBC Gateway Knowledge Base.
- You can email questions to .
