Installing Oracle Odbc Drivers

Oracle ODBC driver on IBM AIX is certified with ODBC Driver Manager 2.3.4. To use ODBC with Oracle Database, you must also install the following package: Copy gcc 4.2.1 or later.

Odbc

4.1.1 Installing the Windows Connector/ODBC Driver Using the Zipped DLL Package

If you have downloaded the zipped DLL package:

  1. Unzip the installation files.

  2. Run the included batch file to perform an installation to the default locations.

  3. Alternatively, install the individual files required for Connector/ODBC operation manually.

Install Oracle Odbc Driver Windows Server 2016

The following instructions only work for 32-bit Windows systems. If you have a 64-bit Windows system, use the MSI installer, which installs both the 32-bit and 64-bit drivers to the correct locations.

To install using the batch file:

  • Download the desired package from OTN for your operating system and follow the installation instructions on the download page. For example, unzip the package to C:instantclient193 on Windows, unzip to /opt/oracle/instantclient193 on Linux or other platforms, or use yum to install the RPM packages on Linux.
  • Using other drivers. For Linux and MacOS, ODBC drivers should be compiled against unixODBC.Drivers compiled against iODBC may also work, but are not fully supported. After installation of the driver manager and driver, you will have to register the driver in a odbcinst.ini file for it to appear in odbc::odbcListDrivers.

  1. Unzip the Connector/ODBC zipped DLL package.

  2. Open a command prompt.

  3. Change to the directory created when you unzipped the Connector/ODBC zipped DLL package.

  4. Run Install.bat:

    This copies the necessary files into the default location, and then registers the Connector/ODBC driver with the Windows ODBC manager.

Changing or adding a new DSN (data source name) may be accomplished using either the GUI, or from the command-line using myodbc-installer.exe.

Although Oracle recommends installing these files in the standard location, you can also copy the files by hand to an alternative location - for example, to run or test different versions of the Connector/ODBC driver on the same machine. To copy the files to a location of your choice, use the following steps:

  1. Unzip the Connector/ODBC zipped DLL package.

  2. Open a command prompt.

  3. Change to the directory created when you unzipped the Connector/ODBC zipped DLL package.

  4. Copy the library files to a suitable directory. The default location is the default Windows system directory WindowsSystem32:

    For Connector/ODBC 8.x:

    For Connector/ODBC 5.x:

  5. Copy the Connector/ODBC tools. These must be placed in a directory that is in the system %PATH%. The default is to install these into the Windows system directory WindowsSystem32:

  6. Optionally, copy the help files. For these files to be accessible through the help system, they must be installed in the Windows system directory:

  7. Finally, register the Connector/ODBC driver with the ODBC manager:

    For Connector/ODBC 8.x:

    For Connector/ODBC 5.3:

    If you installed these files into a non-default location, change the references to the DLL files and command location in the above statement

Last updated on MAY 28, 2019

Applies to:

Install oracle odbc driver on sql server Oracle Provider for OLE DB - Version 10.2.0.1 and later
Oracle ODBC Driver - Version 10.2.0.1 and later
Oracle Data Provider for .NET - Version 10.2.0.1.0 and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)Odbc

Purpose

To help guide customers on how to install, configure, and test both the 32-bit and 64-bit Oracle Data Provider for .Net (ODP), Oracle Provider for OLE DB (OLEDB), and Oracle ODBC Driver (ODBC) Oracle Software on 64-bit Windows.

This bulletin will discuss the following:

  1. Facts/Tips
  2. How & What to Install for 32-bit and 64-bit Oracle Clients.
  3. How to Test The 64-bit ODP, OLEDB, and ODBC
  4. How to Test The 32-bit ODP, OLEDB, and ODBC

Scope

This is intended for users trying to use ODP, OLE DB, and ODBC on 64-bit Windows.

Details

Oracle Odbc Drivers Not Installing

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

Oracle

Install Oracle Odbc Drivers Windows 10

In this Document
Purpose

Install Oracle Odbc Driver Centos 7

Oracle
Scope
Details
References

Install Oracle Odbc Driver On Sql Server

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.