OpenLink ODBC Driver for Oracle 8 & 9 (Lite Edition) Installation and Configuration


Review Preinstallation Documentation: Pre-Installation Configuration for Oracle Single-Tier Drivers (Unix)

Installation

Login to your Unix or Linux client machine.

cd into the installation directory.

The installation files ship as an installation shell script, a driver and admin .taz file, and a license .lic file. The installation shell script should be ftp'd in ascii. The rest of the files should be ftp'd in binary, where applicable.

Use the su command to switch to your DBMS or DBMS native client userid, where appropriate.

Execute the .profile associated with the DBMS user.

Use the echo command to ensure that ORACLE_HOME and ORACLE_SID are set.

Run the following command to start the installation: sh install.sh

You must choose a TCP port on which to run your HTTP-based iODBC Data Sources Administrator. The default is 8000. You will need to know this port number and your local machine's IP address or hostname to access your Admistrator in a Web browser. This is how you call it: http://machine:portnumber

Log File? enables you to rename and relocate your Administrative Assistant's log file. It is best to go with the default.

You can choose to log all requests. This is not diagnostic-level odbc tracing or connection logging. The default is no.

You can change the iODBC Data Source Administrator's default username from "admin." This is the name that you will need to login to OpenLink's HTTP-based iODBC Data Sources Administrator.

You can change the iODBC Data Source Administrator's default password from "admin."

The installation is complete.

Configuration

Jump to manual configuration docs: Manually Configure Oracle 8 & 9 Connectivity

Execute the bash command to open a bash shell. If you do not have have the bash shell, substitute the sh command for the bash command. This will open the bourne shell.

Use the export command to set an OPL_LICENSE_DIR variable that points to the directory that contains your OpenLink license. This is typically the bin sub-directory of the OpenLink installation. However, you can put your license files in /etc/, the root of the installation, or virtually anywhere else.

Run the following command to set your ODBC environment variables: . ./openlink.sh

cd into the bin sub-directory of your OpenLink installation.

Use the ls command to display your files.

Note: I have an OpenLink License Manager currently running on my system. You need to manually start your own License Manager. Run this command: ./oplmgr +start

Run the following command to start your HTTP-based iODBC Data Sources Administrator: ./iodbc-admin-httpd.sh start

Open a Web browser on any computer and type the URL for your administrator in the address bar.

Click the Client Components Administration link in the left hand side navigation bar.

Click the Configure ODBC Data Sources link in the left hand side navigation bar.

Then, login with your username and password.

Click the Add button.

Click the OpenLink Oracle Lite Driver (multi-threaded). Then, click Create DSN.

Provide a descriptive name and optional description for your DSN. Then, click Next.

Pass the following values in the next dialog:

Click Next.

Set the following variables on the next dialog:

Click Next.

You can set the following, optional values on the fourth dialog:

Click Next.

Additional, optional parameters appear on the fifth, and final dialog:

Click Next.

Your new DSN is highlighted and persisted on the the Data Sources tab. Click the Test tab.

Type your password in the password field and click test.

You have established a connection.


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