OpenLink JDBC to ODBC Bridge Driver (Lite Edition) Installation and Configuration

Review Preinstallation Documentation: OpenLink JDBC to ODBC Bridge Driver (Lite Edition) Pre-Installation Requirements

Installation

The OpenLink JDBC to ODBC Bridge Driver for Mac OS X is distributed in a single disk image (.dmg) file, which contains a Macintosh Installer mpkg.

Double-click the mpkg to start the installation process.

You will encounter a warning message that will ask you if you are sure that you want to install the software click to continue.

The installer will display a Welcome message. Click "Continue."

The next screen will display the Read Me file, including any last- minute updates to these documents. Please read carefully and click "Continue" when finished.

The next screen will display the License Agreement for the OpenLink JDBC to ODBC Bridge Driver. Please read and click "Continue."

You will be prompted to "Agree" to continue the installation or "Disagree" to abort.

You will be asked to select a Destination Volume. Generally, this should be your Mac OS X boot volume. Click on the desired disk icon and then click "Continue."

You may now choose the Easy Install, or if you are an experienced user, you may Customize which components are installed. OpenLink generally recommends the Easy Install.

If you have installed OpenLink or iODBC components in the past, click "Upgrade" to continue. Otherwise, click "Install."

If you chose the custom option, select which of the following components to install.

You must have an Administration username and password to install the OpenLink driver. Enter your Mac OS X Username and Password.

You will be shown a graphical progress bar as the Installation progresses, followed by System Optimization.

You will need to locate the license file. Click "Try or Buy License" to obtain evaluation or commercial licenses from the OpenLink Web site. Click "Use Existing License" to select a license on the local file system.

When the process is complete, you will be told that the software was successfully installed. Click "Close" and your new database driver is ready for use.

Configuration

The OpenLink installer should set your CLASSPATH. You should have a pre-existing JAVA_HOME directory that points to the root of your JAVA installation. No further configuration should be needed.

• Driver File Name:

• Driver Class Name:

• Connection URL: jdbc:openlink://ODBC[/DSN][/UID][/PWD][/READONLY]

• /DSN- Local ODBC Data Source Name

• /UID- Database Username

• /PWD- Database Password

• /READONLY- Read-write or read-only session mode

Example:jdbc:openlink://ODBC/DSN=Local Oracle ODBC Data Source/UID=scott/PWD=tiger

Proceed to Commercial Licensing Documentation:

Should you decide to purchase a commercial license at the end of your evaluation period, be sure to consult our documentation which explains the placement and uptake of commercial license files and the use of our OpenLink License Manager technology: License Technology & Application