Servers

Thank you for downloading

  • Microsoft® SQL Server® ODBC Driver 1.0 for Linux

    If your download does not start after 30 seconds,
    Click here

    Choose the files that didn't download.

    File NameDownload LinkSize
    Linux5\sqlncli-11.0.1790.0.tar.gzRecommendedClick here926 KB
    Linux6\sqlncli-11.0.1790.0.tar.gzRecommendedClick here917 KB
    Download Summary:
    KBMBGB

    You have not selected any file(s) to download.

      • 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

    • 01

      Microsoft® SQL Server® 2014 Express

      Microsoft SQL Server 2014 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

    • 04

      Windows Management Framework 4.0

      Windows Management Framework 4.0 includes updates to Windows PowerShell, Windows PowerShell ISE, Windows PowerShell Web Services (Management OData IIS Extension), Windows Remote Management (WinRM), Windows Management Instrumentation (WMI), the Server Manager WMI provider, and a new feature for 4.0, Windows PowerShell Desired State Configuration (DSC).

    • 05

      Microsoft® SQL Server® 2008 Management Studio Express

      Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.

Loading your results, please wait...

Site feedback
Microsoft

What category would you like to give web site feedback on?



Rate your level of satisfaction with this web page today:

Comments:

Submit