Servers

    Microsoft® SQL Server® ODBC Driver 1.0 for Linux

    Language:
    English
    The Microsoft SQL Server ODBC Driver for Linux provides native connectivity from Linux to Microsoft SQL Server.
    • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
      Version:

      1.0

      File Name:

      Linux5\sqlncli-11.0.1790.0.tar.gz

      Linux6\sqlncli-11.0.1790.0.tar.gz

      Date Published:

      3/6/2012

      File Size:

      926 KB

      917 KB

        The 64 bit version of the Microsoft SQL Server ODBC Driver for Linux provides robust data access to Microsoft SQL Server. It allows native C and C++ applications to leverage the standard ODBC API and connect to Microsoft SQL Server 2012. Microsoft SQL Server ODBC Driver for Linux also comes with powerful tools - sqlcmd and bcp.
    • Supported Operating System

      Linux

        Either 64-bit Red Hat Enterprise Linux 5 or 64-bit Red Hat Enterprise Linux 6 with the following RPM packages installed from your distribution’s package repository:

        64-bit Red Hat Enterprise Linux 5
        • glibc-2.5
        • libgcc-4.1.2
        • libstdc++-4.1.2
        • e2fsprogs-libs-1.39
        • krb5-libs-1.6.1
        • openssl-0.9.8e

        64-bit Red Hat Enterprise Linux 6
        • glibc-2.5
        • libgcc-4.4.6
        • libstdc++-4.4.6
        • libuuid-2.17.2
        • krb5-libs-1.9
        • openssl-1.0.0

        The unixODBC 2.3.0 Driver Manager built and installed according to the following instructions.
    • Install Instructions
        If you previously installed the Microsoft SQL Server ODBC Driver for Linux Community Technology Preview (CTP), please follow the “Upgrade from Community Technology Preview” instructions below instead of these installation instructions.

        Download the Microsoft SQL Server ODBC Driver or Linux package for your platform by clicking one of the download buttons.

        Verify the integrity of your download:

        64-bit Red Hat Enterprise Linux 5
        • MD5: 479f9535c5f899f44f2f6b987e526c2b
        • SHA1: 7e13b288a46b5caa5862d1270edac0fbdafa2a9d

        64-bit Red Hat Enterprise Linux 6
        • MD5: 36aca6fdfaa6e87754c477e08969fed4
        • SHA1: ba8a27b1fc91b933a31d987805a6f78e29f893b4

        Extract the Microsoft SQL Server ODBC Driver 1.0 for Linux package:
        1. Navigate to the directory where you downloaded sqlncli-11.0.1790.0.tar.gz and extract it:
          cd ~/Downloads/
          tar xvf sqlncli-11.0.1790.0.tar.gz.


        Install the unixODBC 2.3.0 Driver Manager:
        1. Make sure that you have root permissions.
        2. Remove any older installed version of unixODBC (for example, unixODBC 2.2.11): yum remove unixODBC
        3. Change to the sqlncli-11.0.1790.0 directory, where you can run build_dm.sh to install the unixODBC Driver Manager:
          cd ./sqlncli-11.0.1790.0
          ./build_dm.sh --help

        4. You can install the driver manager by executing the following command:
          ./build_dm.sh
          Note: you can also download the driver manager manually at http://www.unixodbc.org/ and use the downloaded archive locally:
          ./build_dm.sh --download-url=file://unixODBC-2.3.0.tar.gz
        5. Type "YES" to proceed with unpacking the files. This part of the process can take up to five minutes to complete.
        6. After the script stops running, follow the instructions on the screen to install the unixODBC Driver Manager.

        Install the Microsoft SQL Server ODBC Driver 1.0 for Linux:
        1. Make sure that you have root permissions.
        2. Change to the sqlncli-11.0.1790.0 directory, where you can run install.sh to install the driver:
          cd ./sqlncli-11.0.1790.0
          ./install.sh --help
        3. (Optional) You may want to make a backup of odbcinst.ini. The driver installation will update odbcinst.ini. odbcinst.ini contains the list of drivers that are registered with the unixODBC Driver Manager. Execute the following command to discover the location of odbcinst.ini on your computer:
          odbc_config –odbcinstini.
        4. Before you install the driver, you may run a verify step to check if your computer has the required software to support the Microsoft SQL Server ODBC Driver 1.0 for Linux:
          ./install.sh verify
        5. When you are ready to install the Microsoft SQL Server ODBC Driver 1.0 for Linux, run the install script:
          ./install.sh install
        6. After reviewing the license agreement, type "YES" to continue with the installation.
        7. Verify that Microsoft SQL Server ODBC Driver 1.0 for Linux was registered successfully:
          odbcinst -q -d -n "SQL Server Native Client 11.0"


        Upgrade from Community Technology Preview

        If you previously installed the Microsoft SQL Server ODBC Driver for Linux Community Technology Preview (CTP), it is important to remove the CTP before installing the Microsoft SQL Server ODBC Driver 1.0 for Linux. However, you do not need to uninstall or reinstall the unixODBC 2.3.0 Driver Manager that you used with the CTP.

        Download the Microsoft SQL Server ODBC Driver 1.0 for Linux package for your platform by clicking one of the download buttons.

        Verify the integrity of your download:

        64-bit Red Hat Enterprise Linux 5
        • MD5: 479f9535c5f899f44f2f6b987e526c2b
        • SHA1: 7e13b288a46b5caa5862d1270edac0fbdafa2a9d

        64-bit Red Hat Enterprise Linux 6
        • MD5: 36aca6fdfaa6e87754c477e08969fed4
        • SHA1: ba8a27b1fc91b933a31d987805a6f78e29f893b4

        Extract the Microsoft SQL Server ODBC Driver 1.0 for Linux package:
        1. Navigate to the directory where you downloaded sqlncli-11.0.1790.0.tar.gz and extract it:
          cd ~/Downloads/
          tar xvf sqlncli-11.0.1790.0.tar.gz.


        Remove the Microsoft SQL Server ODBC Driver for Linux Community Technology Preview:
        1. Make sure that you have root permissions.
        2. Remove the CTP files and symbolic links:
          rm /usr/bin/bcp
          rm /usr/bin/sqlcmd
          odbcinst -u -d -n "SQL Server Native Client 11.0"
          rm -r /opt/microsoft/sqlncli

        If you used the --bin-dir option to place the bcp and sqlcmd applications into a different directory when you installed the CTP, be sure to remove both applications from that directory as well.

        Install the Microsoft SQL Server ODBC Driver 1.0 for Linux:
        1. Make sure that you have root permissions.
        2. Change to the sqlncli-11.0.1790.0 directory, where you can run install.sh to install the driver:
          cd ./sqlncli-11.0.1790.0
          ./install.sh --help
        3. (Optional) You may want to make a backup of odbcinst.ini. The driver installation will update odbcinst.ini. odbcinst.ini contains the list of drivers that are registered with the unixODBC Driver Manager. Execute the following command to discover the location of odbcinst.ini on your computer:
          odbc_config –odbcinstini.
        4. Before you install the driver, you may run a verify step to check if your computer has the required software to support the Microsoft SQL Server ODBC Driver 1.0 for Linux:
          ./install.sh verify
        5. When you are ready to install the Microsoft SQL Server ODBC Driver 1.0 for Linux, run the install script:
          ./install.sh install
        6. After reviewing the license agreement, type "YES" to continue with the installation.
        7. Verify that Microsoft SQL Server ODBC Driver 1.0 for Linux was registered successfully:
          odbcinst -q -d -n "SQL Server Native Client 11.0"

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial