ODBC Driver 13.1 for Linux Released

Hi all, we are delighted to share the Production Ready Release of the Microsoft ODBC Driver 13.1 for Linux –  (Ubuntu, RedHat and SUSE). The new driver enables access to SQL Server, Azure SQL Database and Azure SQL DW from any C/C++ application on Linux

Added

  • BCP API Support 
    • You can use functions through the ODBC driver as described here on Linux
  • Support for user defined KeyStoreProvider for Always Encrypted
  • Ubuntu 16.10 support
    • Developed a package for Ubuntu 16.10 to ensure an apt-get install experience
  • Dependency on the platform unixODBC Driver Manager instead of the custom unixODBC-utf16 Driver Manager
    • This avoids conflicts with applications/software that depends on the platform unixODBC Driver Manager

Fixed

  • msqobcsql.h  (Connect issues 3115331, 3114970)  
    • Missing definitions for AE, BCP, and SQL Server specific types were added 
  • TRUST_SERVER_CERTIFICATE connection attribute is always yes (Connect 3116639)  
    • Setting the TRUST_SERVER_CERTIFICATE connection attribute to anything other than yes failed to set the attribute value.  This has been corrected. 
  • Fixed Connect issue 2693027 - Memory Leak 
    • We detected this issue independently of the bug report using valgrind.  The memory leak has been fixed.
  • Driver failure when connecting with more than 1024 handles
    • Switched away from libio select. Driver now supports (theoretical) handle limit of 64k or platform max 
  • Intermittent commlinkfailure when using Azure DW 
    • In some high latency scenarios over an encrypted channel, the driver could fail unexpectedly. This has been resolved

Install the ODBC Driver for Linux on Ubuntu 15.10

[snippet slug=odbc-driver-15-10-13-1-rtw lang=bsh]

Install the ODBC Driver for Linux on Ubuntu 16.04

[snippet slug=odbc-driver-16-04-13-1-rtw lang=bsh]

Install the ODBC Driver for Linux on Ubuntu 16.10

[snippet slug=odbc-driver-16-10-13-1-rtw lang=bsh]

Install the ODBC Driver for Linux on RedHat 6

[snippet slug=odbc-driver-rhel-6-13-1-rtw lang=bsh]

Install the ODBC Driver for Linux on RedHat 7

[snippet slug=odbc-driver-rhel-7-13-1-rtw lang=bsh]

Install the ODBC Driver for SLES 12

[snippet slug=odbc-driver-suse12-13-1-rtw lang=bsh]

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:

[snippet slug=odbc-c-sample lang=bsh]

If you installed the driver using the manual instructions found here, you will have to manually uninstall the ODBC Driver and the unixODBC Driver Manager to use the deb/rpm packages. If you have any questions on how to manually uninstall, feel free to leave a comment below. 

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

Meet Bhagdev (meetb@microsoft.com)

sql-loves-linux_2_twitter-002