Compartilhar via

Servicing Update for ODBC Driver 13.1 for Linux and macOS Released

  • Artigo

Hi all, we are delighted to share the servicing update of the Microsoft ODBC Driver 13.1 for Linux and macOS. The new driver enables access to SQL Server, Azure SQL Database and Azure SQL DW from any C/C++ application on Linux and macOS.

Added

  • Ubuntu 14.04, 17.04, Debian Jessie and SUSE Enterprise Linux 11 SP4 support
    • Use apt-get, and zypper to install the driver
  • Azure Active Directory Authentication support (username/password) for Linux and macOS
    • Get started with Azure AD by checking out the docs here
  • Configurable driver location on Linux
    • Simply copy the whole driver install directory to the location of your choice after normal installation.

Fixed

  • Issue with Floating-point numbers formatted incorrectly in French locale
  • Issue with SQLBindParameter input/output parameters truncating prematurely
  • Implicit cursor conversion due to comments
  • Buffer overrun upon UTF-8 character conversion
  • Symbolic link creation for the RPM package

Install the ODBC Driver for Linux on Debian Jessie 8

[snippet slug=odbc-driver-debian-jessie-servicing-release lang=bsh]

Install the ODBC Driver for Linux on Ubuntu 14.04

[snippet slug=odbc-driver-14-04-13-1-servicing-release lang=bsh]

Install the ODBC Driver for Linux on Ubuntu 16.04

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

Install the ODBC Driver for Linux on Ubuntu 16.10

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

Install the ODBC Driver for Linux on Ubuntu 17.04

[snippet slug=odbc-driver-17-04-13-1-servicing-release lang=bsh]

Install the ODBC Driver for Linux on RedHat 6

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

Install the ODBC Driver for Linux on RedHat 7

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

Install the ODBC Driver for SLES 11

Note: For SLES 11, make sure you enable the security module before you install the driver. The driver uses newer versions of openssl and crypto libraries that are available via the module.

[snippet slug=odbc-driver-suse11-13-1-servicing-release lang=bsh]

Install the ODBC Driver for SLES 12

[snippet slug=odbc-driver-suse12-13-1-servicing-release 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

Comments

  • Anonymous
    August 01, 2017
    Hi Bhagdev,We have SAP System running on SUSE Linux SP4 , I followed the steps mentioned and installed the following " msodbcsql-13.1.9.0-1 " .However I get the errorcommand-not-found sqlcmdAlso I don't find sqlcmd file on my server.I performed all the steps as mentioned in the sapnote1644499 - Database connectivity from Linux to SQL Server Could you please let me know if I am missing something
    • Anonymous
      September 04, 2017
      Hello Ahmed, we are still working on the SLES 11 package for mssql-tools. Stay tuned for updates.
  • Anonymous
    August 25, 2017
    I'm trying to run this on top of the official Python container for Docker (FROM python:latest), which is based on Debian 8. However, having issues when running "RUN ACCEPT_EULA=Y apt-get -y install msodbcsql"Perhaps it's my minor experience with this environment but has anyone ran such a configuration successfully?