Install latest version of Oracle ODBC

To install latest version of Oracle ODBC:

Go to to download:

  • Instant Client Package – Basic
  • Instant Client Package – ODBC

Unzip both of them into the same folder (e.g. c:\oracle).

  • Add that folder name into the PATH environment variable (right click my computer, manage, system properties, advanced tab, environment variables)
  • Create a new environment variable called TNS_ADMIN and set it to that folder name.
  • Create a file tnsnames.ora in that folder with your target database details.
  • Run odb_install.exe

You can then add and test oracle odbc connections in Control Panel Administrative Tools.

June 17, 2010

Leave a Reply

Your email address will not be published. Required fields are marked *