Installing and Configuring the ODBC Driver for Windows

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

In this Topic:

Prerequisites

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 driver, download it now. For details, see Downloading the ODBC Driver.
  2. Double-click on the downloaded .msi file:
  • snowflake64_odbc-<version>.msi
  • snowflake32_odbc-<version>.msi

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:

    Configuring ODBC for Windows

    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:

    Configuring ODBC for Windows

    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:

      Configuring ODBC for Windows
    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:

      Configuring ODBC for Windows

      When entering parameters, note the following:

      • Data Source, User and Server are the only parameters required to create a DSN.
      • 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.
      • All other parameters in the dialog are optional.

      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.

    4. Click OK to create the DSN.

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