ODBC Driver: Oracle
Oracle Driver Installation
This article is current only as of the last modified date.
The Pearson documentation, Oracle ODBC Configuration and Client Installation
Guide, contains more detailed information for installing and setting up these drivers.
Note:
This process is somewhat advanced and even advanced users have had some trouble installing Oracle’s drivers. These drivers are supported and distributed by Oracle and Discovery Software has no control over their stability nor the installation procedure of the Instant Client Drivers. Discovery Support can provide some assistance in installing these drivers, but we cannot be responsible for the software contained therein. When installing these drivers you will be required to accept the Oracle Technology Network Development and Distribution License Terms for Instant Client which can be found at: http://www.oracle.com/technology/software/popup-license/instant_client_lic.html
Oracle Instant Client software is available via download at:
http://www.oracle.com/technetwork/topics/winsoft-085727.html
If the link above does not work, oracle has changed the location, just do a search for “instant client basic download”.
Note: An Oracle account is required in order to download the software. The
account is free and does not require PowerSchool license or login information.
From the Oracle Instant Client Downloads page:
- Click on: Instant Client for Microsoft Windows (32-bit) (Windows XP, Vista 32 bit)
- If you are using Vista (64 bit) or Server 2008 (64 bit) you will still need to choose the 32-bit client.
- You may need to log on to the Oracle site at this point.
- Accept the user license agreement.
- Under Version 10.2.0.4:
- Download Instant Client Package – (Basic or Basic Lite)
- Download Instant Client Package – ODBC
- These two files are zip archives. You will need to extract them to your computer.
- Extract them into the same folder: eg. C:\Oracle\InstantClient\
- There is a help document in this folder in case you need more help: ODBC_IC_Readme_Win.html.
- Add this location to your PATH environment variable:
- Start->Settings->Control Panel->System
- Advanced Tab.
- Environment Variables
- Under System Variables find a variable called PATH or Path.
- Select it, and click Edit.
- In the Variable value add the path of the Instant Client Package to the current value, separated by semi-colons. eg. You may add this string if this was your saved location from step 6 above:
;C:\Oracle\InstantClient\instantclient_10_2
- Double click on the odbc_install.exe file in the Instant Client folder.
- Your Oracle Drivers should be installed.
If you have trouble with this installation, please consult your Pearson Documentation or
Oracle’s website for more information.
