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

Installing Oracle Odbc Driver Windows 7

1. Review the minimum supported ODBC driver releases, and install ODBC drivers of the following or later releases for all Linux distributions: Copy unixODBC-2.3.1 or later Parent topic: Installation Requirements for ODBC and LDAP.
2. At the University, installing the Oracle client and ODBC driver is basically a four or five step process: 1. Download the Oracle installation file. Decompress (i.e., unzip) the Oracle installation file. Optional: Run the Oracle Universal Installer to “uninstall” an earlier version of the Oracle client.

In this Topic:

Prerequisites¶

The oracle 11g client install is almost exactly the same as the oracle 12c client install. Download this app from microsoft store for windows 10 mobile, windows phone 8.1, windows phone 8. Every enterprise needs to securely maintain their data. Step by step instruction how to download and install the odbc drivers for oracle 11g release 2.

Operating System¶

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

Installing Oracle Odbc Drivers Windows 10

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:

Install Oracle Odbc Driver Ubuntu

Step 2: Configure the ODBC Driver¶

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

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.

Oracle Odbc Drivers Not Installing

Install Oracle Odbc Driver Windows Server 2016

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