Microsoft® SQL Server® ODBC Driver 1.0 for Linux

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 Systems

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.

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"

Community Support: ODBC, OLE DB and SQL Server Native Client Forum.
Submit Feedback: Microsoft SQL Server Feedback Center.
Documentation: ODBC Driver on Linux Documentation.
Team Blog: Microsoft SQL Server Native Client Team Blog