-->

Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Parallel Data Warehouse

Actual ODBC Pack (for Mac OS - compatible with MacOS 11 Big Sur) The Actual ODBC Pack installs the latest version of several Actual Technologies ODBC drivers. The included drivers and their version numbers are listed below: Actual SQL Server 5.1.2 (Microsoft SQL Server and Sybase). MySQL ODBC driver (32/64 bit) v.2.1 Devart ODBC Driver for MySQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access MySQL databases from Windows, Linux and Mac OS X, both 32-bit and 64-bit.

Microsoft ODBC Driver for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to SQL Server. Use Microsoft ODBC Driver 17 for SQL Server to create new applications or enhance existing applications that need to take advantage of newer SQL Server features.

Download for Windows

The redistributable installer for Microsoft ODBC Driver 17 for SQL Server installs the client components, which are required during run time to take advantage of newer SQL Server features. It optionally installs the header files needed to develop an application that uses the ODBC API. Starting with version 17.4.2, the installer also includes and installs the Microsoft Active Directory Authentication Library (ADAL.dll).

Version 17.7.2 is the latest general availability (GA) version. If you have a previous version of Microsoft ODBC Driver 17 for SQL Server installed, installing 17.7.2 upgrades it to 17.7.2.

Free Odbc Driver For Mac Numbers Update

Download Microsoft ODBC Driver 17 for SQL Server (x64)
Download Microsoft ODBC Driver 17 for SQL Server (x86)

Version information

Release number: 17.7.2.1
Released: March 10, 2021

Note

If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the US-English version of the site. You can download different languages from the US-English version site by selecting available languages.

Available languages

This release of Microsoft ODBC Driver for SQL Server can be installed in the following languages:

Release notes for Windows

For details about this release on Windows, see the Windows release notes.

Previous releases for Windows

To download previous releases for Windows, see previous Microsoft ODBC Driver for SQL Server releases.

Download for Linux and macOS

The Microsoft ODBC Driver for SQL Server can be downloaded and installed using package managers for Linux and macOS using the relevant installation instructions:
Install ODBC for SQL Server (Linux)
Install ODBC for SQL Server (macOS)

If you need to download the packages for offline installation, all versions are available via the below links.

Note

Packages named msodbcsql17-* are the latest version. Packages named msodbcsql-* are version 13 of the driver.

Alpine

17.7.2.1 Alpine package (PGP Signature)
17.7.1.1 Alpine package (PGP Signature)
17.6.1.1 Alpine package (PGP Signature)
17.5.2.2 Alpine package (PGP Signature)
17.5.2.1 Alpine package (PGP Signature)
17.5.1.1 Alpine package (PGP Signature)

Debian

Red Hat

Suse

Ubuntu

See also Installing the Linux driver.

macOS

See the Homebrew formulae for details.

See also Installing the macOS driver.

Older Linux releases

Red Hat Enterprise Linux 5 and 6 (64-bit) - Download Microsoft ODBC Driver 11 for SQL Server - Red Hat Linux
SUSE Linux Enterprise 11 Service Pack 2 (64-bit) - Download Microsoft ODBC Driver 11 Preview for SQL Server - SUSE Linux

Release notes for Linux and macOS

For details about releases for Linux and macOS, see the Linux and macOS release notes.

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

In this Topic:

Prerequisites¶

Operating System¶

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

iODBC¶

The Snowflake ODBC driver for Mac requires iODBC, which is available for download from:

To install iODBC:

After downloading iODBC, double-click on the downloaded .dmg file.
Double-click on the installer file, iODBC-SDK.pkg, and follow the prompts.

Note

iODBC provides a GUI administrator tool for configuring drivers and DSNs; however, this tool has not been tested for use with Snowflake and, therefore, should not be used to create or manage DSNs. Use ODBC Manager instead.

ODBC Manager — Optional/Recommended¶

ODBC Manager is a GUI tool for configuring drivers and creating/managing DSNs. The tool is optional because you can also create DSNs manually by editing the appropriate odbc.ini file. ODBC Manager is available from:

To install ODBC Manager:

After downloading ODBC Manager, double-click on the downloaded .dmg file.
Double-click on the installer file, ODBCManager.pkg, and follow the prompts.

The installer installs ODBC Manager in the ~/Applications/Utilities directory.

Step 1: Install the ODBC Driver¶

To install the Snowflake ODBC driver for macOS:

If you haven’t already downloaded the driver, download it now. For details, see Downloading the ODBC Driver.
Double-click on the downloaded .dmg file, snowflake_odbc_mac-<version>.dmg.
Double-click on the installer file, snowflakeODBC_<version>.pkg, and follow the prompts.
You will likely be prompted for the administrator/sudo password for the machine on which you are installing the driver.

If you choose the default directory when prompted, the installer installs the ODBC driver files in the following directories:

Step 2: Configure the ODBC Driver¶

To configure the ODBC driver for macOS, create one or more data source (DSNs), which are stored in the following files, depending on the type of DSN you create:

User DSNs: ~/Library/ODBC/odbc.ini
System DSNs: /Library/ODBC/odbc.ini

To create a DSN, either use ODBC Manager or edit the appropriate odbc.ini file.

Creating a DSN Using ODBC Manager¶

To create a DSN in ODBC Manager:

Start ODBC Manager.
Click on User DSN or System DSN.
Click the Add button.
Select the driver to use (Snowflake) and click OK.
Enter the name of the DSN and optionally a description.
Create a Keyword/Value pair for each DSN parameter:
1. Click Add to create a Keyword/Value pair.
2. Select Keyword and replace it with the parameter name.
3. Select Value and replace it with the value for the parameter.
Repeat this process for each parameter. For details about the parameters that can be set for each DSN, see ODBC Configuration and Connection Parameters.
Click OK to create the DSN.

If you are creating the first user or system DSN for the ODBC driver, ODBC Manager creates the odbc.ini file in the corresponding directory for the type of DSN you are creating. If you are