http://www.microsoft.com/en-us/download/details.aspx?
id=28160
Microsoft SQL Server ODBC Driver
1.0 for Linux
The Microsoft SQL Server ODBC Driver for Linux provides native connectivity
from Linux to Microsoft SQL Server.
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:
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:
Make sure that you have root permissions.
Remove any older installed version of unixODBC (for example, unixODBC
2.2.11): yum remove unixODBC
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
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
Type "YES" to proceed with unpacking the files. This part of the process can
take up to five minutes to complete.
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:
Make sure that you have root permissions.
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
(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.
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
When you are ready to install the Microsoft SQL Server ODBC Driver 1.0 for
Linux, run the install script:
./install.sh install
After reviewing the license agreement, type "YES" to continue with the
installation.
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:
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:
Make sure that you have root permissions.
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:
Make sure that you have root permissions.
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
(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.
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
When you are ready to install the Microsoft SQL Server ODBC Driver 1.0 for
Linux, run the install script:
./install.sh install
After reviewing the license agreement, type "YES" to continue with the
installation.
Verify that Microsoft SQL Server ODBC Driver 1.0 for Linux was registered
successfully:
odbcinst -q -d -n "SQL Server Native Client 11.0"
