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
- You can now user defined/created AE Column Master Key keystore providers.
- 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)