Installing and Configuring the ODBC Commuter for Windows¶

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

In this Topic:

  • Prerequisites

    • Operating Organization

    • Ambassador Privileges

    • Visual C++ Redistributable for Visual Studio 2015

  • Step i: Install the ODBC Driver

  • Stride 2: Configure the ODBC Commuter

Prerequisites¶

Ambassador Privileges¶

To install the ODBC driver, yous demand ambassador-level privileges and then that the driver can be installed in the C:\Program Files directory.

Visual C++ Redistributable for Visual Studio 2015¶

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

Step 1: Install the ODBC Driver¶

  1. If y'all haven't already downloaded the latest commuter version, download it at present. For details, see Downloading the ODBC Driver.

    • snowflake64_odbc-<version>.msi

    • snowflake32_odbc-<version>.msi

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

    Notation

    The driver is installed in C:\Program Files .

Stride ii: 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 Assistants Tool:

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

    Configuring ODBC for Windows

    In one case yous find the ODBC assistants 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 run into 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 Organization DSN tab and click the Add button:

      Configuring ODBC for Windows

    2. Select SnowflakeDSIIDriver from the list of installed drivers.

    3. Enter the connexion 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 post-obit:

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

        For more information on these parameters, see Required Connection Parameters.

      • All other parameters in the dialog are optional. In particular, the proxy-related parameters should be specified merely if you are using a proxy, and the Authenticator should be changed from the default ("snowflake") simply if needed. For more details about ODBC Information Source parameters, see ODBC Configuration and Connection Parameters and, in item, Optional Connection Parameters.

      • The Countersign 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 tin can simply 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 y'all are using federated authentication. For more information, encounter the authenticator parameter clarification in ODBC Configuration and Connection Parameters.

    4. Click OK to create the DSN.

You tin now reference this DSN in ODBC-based customer applications for connecting to Snowflake.