ODBC Driver 13.1 for Mac Preview 1 Released


Hi all,

We are excited to announce the availability of the ODBC Driver 13.1 for macOS – Preview. The preview release adds support for macOS El Capitan with unixODBC Driver Manager and and enables access to SQL Server, Azure SQL Database and Azure SQL Data Warehouse from any C/C++ application on Linux. 

Install the ODBC Driver for macOS El Capitan

/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
brew tap microsoft/msodbcsql https://github.com/Microsoft/homebrew-mssql-preview
brew update
brew install msodbcsql 
#for silent install ACCEPT_EULA=y brew install msodbcsql

Try our Sample

Once you install the driver that runs on a supported Linux distro, you can use this C sample to connect to SQL Server/Azure SQL DB/Azure SQL DW. To download the sample and get started, follow these steps:

wget "https://raw.githubusercontent.com/Microsoft/sql-server-samples/master/samples/tutorials/c/linux/sample_c_linux.c"
gcc sample_c_linux.c -o sample_c_linux -lodbc -w #make sure you change the servername, username and password in the connections string
./sample_c_linux

Please file bugs/questions/issues on our Issues page. We welcome contributions/questions/issues of any kind. Happy programming!

Survey and Future Plans

Please take this survey to help us understand if you use unixODBC or iODBC on macOS.

Going forward we plan to improve test coverage,  fix bugs reported on our Issues page and add feature support for Always Encrypted, Transparent Network IP Resolution and Bulk Copy Support. Stay tuned for upcoming releases that will have additional feature support and bug fixes.

Meet Bhagdev (meetb@microsoft.com)

brewinstallmsodbcsql


Comments (6)

  1. Sergei says:

    Which ODBC version is supported with this driver 3.0, 3.5 or 3.8? Is there a documentation or readme which shows supported functionality and limitations of the driver?

    1. Meet Bhagdev says:

      The ODBC Driver itself supports 3.8. However unixODBC (driver manager on Linux and Mac) is only tested with 3.5. Limitations can be found here: https://docs.microsoft.com/en-us/sql/connect/odbc/linux/known-issues-in-this-version-of-the-driver

  2. Dariel says:

    Will this work with Azure AD auth?

    1. Meet Bhagdev says:

      Not yet, but we are working on it 🙂

      1. Kyle Briggs says:

        Is there any idea as to when this driver will support azure ad credentials as the authentication method?

      2. Meet Bhagdev says:

        It’s in the works. You should see an update in the next few days 🙂

Skip to main content