Installing Oracle Odbc Drivers

Posted on by

Windows utilizes named data sources (DSNs) for connecting ODBC-based client applications to Snowflake.

In this Topic:

Data Connection to Oracle DB easily fails due to OLEDB or ODBC driver issue.This article has included a document explains that "Installing the full Oracle OLEDB and ODBC drivers"The attached document describes how to install the full Oracle OLEDB and ODBC drivers for Qlik Products. 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.

Installing

Prerequisites¶

Operating System¶

For a list of the operating systems supported by Snowflake clients, see Operating System Support.

Administrator Privileges¶

To install the ODBC driver, you need administrator-level privileges sothat the driver can be installed in the C:ProgramFiles directory.

Visual C++ Redistributable for Visual Studio 2015¶

To use Snowflake ODBC Driver in a Windows environment, you have to first install Visual C++ Redistributable for Visual Studio 2015. The installation file is available for download from:

Step 1: Install the ODBC Driver¶

  1. If you haven’t already downloaded the latest driver version, download it now. For details, see Downloading the ODBC Driver.

  2. Double-click on the downloaded .msi file:

Step 2: Configure the ODBC Driver¶

To configure the ODBC driver in a Windows environment, create a DSN for the driver:

Install Oracle Odbc Driver Ubuntu

  1. Launch the Windows Data Source Administration Tool:

    Search on your Windows machine for the launcher for the ODBC Data Source Administration Tool:

    Once you find the ODBC administration tool, click on the tool to launch it and display the set up window.

  2. Verify that the Snowflake ODBC driver is installed:

    Navigate to the Drivers tab in the set up window and verify that the driver (SnowflakeDSIIDriver) appears:

    If you do not see SnowflakeDSIIDriver, then the Snowflake ODBC driver installation did not complete successfully and you need to re-install it.

  3. Create a new DSN:

    1. Navigate to the User DSN or System DSN tab and click the Add button:

    2. Select SnowflakeDSIIDriver from the list of installed drivers.

    3. Enter the connection parameters for the driver.

      In the fields provided in Snowflake Configuration dialog, enter the parameters for the DSN:

      When entering parameters, note the following:

      • Data Source, User and Server are the only parameters required to create a DSN.

      • All other parameters in the dialog are optional. In particular, theproxy-related parameters should be specified only if you are using a proxy, and theAuthenticator should be changed from the default (“snowflake”) only if needed.For more details about ODBC Data Source parameters, seeODBC Configuration and Connection Parametersand, in particular, Optional Connection Parameters.

      • The Password field accepts a value, but does not store the value. This is a security precaution to ensure passwords are never stored directly in the driver.

      Note

      • The ODBC driver supports additional parameters that are not displayed in the dialog. These parameters can only be set in the Windows registry using regedit.

        For descriptions of all the parameters, see ODBC Configuration and Connection Parameters.

      • Specifying a value in the Authenticator field is only required if you are using federated authentication. For more information, see the authenticator parameter description in ODBC Configuration and Connection Parameters.

    4. Click OK to create the DSN.

You can now reference this DSN in ODBC-based client applications for connecting to Snowflake.

It is ridiculously difficult and ambiguous how you’re supposed to get the Oracle ODBC driver installed on your Windows machine. It’s certainly not a simple task. Well, since I figured it out today I thought I would document it.

First you need to download all three of these files from oracle
1) instantclient-basic-win-x86-64-11.1.0.7.0
3) instantclient-sdk-win-x86-64-11.1.0.7.0
Extract the contents of all the above into a single directory called D:OracleOra11
That directory doesn’t exist and you’ll have to create it first.
Now with all the files copied in there, create the following windows environment variables:
1) OCI_LIB64 = C:OracleOra11
3) TNS_ADMIN = C:OracleOra11
Also, add “C:OracleOra11” to your PATH variable.
At this point you MUST reboot. No other way around it. Simply restarting the explorer task won’t do.
After the reboot, create the following directory: C:OracleOra11NetworkAdmin
Place your tnsnames.ora file inside this new directory.

Installing Oracle Odbc Driver Windows 7

Open a cmd prompt as administrator.

Installing Oracle Odbc Drivers Windows 10

On the command prompt type the following command:
odbc_install.exe
You should receive a message that says: “Oracle ODBC Driver is installed successfully.”
The new ODBC driver is only in the ODBC 64-bit data sources.

Oracle Odbc Drivers Not Installing

Just remember that your tnsnames.ora file must contain the service you’re trying to connect to.