sqlnclient安装

安装MSSQL native client

https://www.microsoft.com/en-us/download/details.aspx?id=28160

wget https://download.microsoft.com/download/6/A/B/6AB27E13-46AE-4CE9-AFFD-406367CADC1D/Linux6/sqlncli-11.0.1790.0.tar.gz

tar -zxvf sqlncli-11.0.1790.0.tar.gz

cd sqlncli-11.0.1790.0

./build_dm.sh --help

rpm -e unixODBC-2.2.14-14.el6.x86_64 --nodeps

rpm -e unixODBC-devel-2.2.14-14.el6.x86_64

./build_dm.sh --download-url=ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.0.tar.gz

cd /tmp/unixODBC.13350.23795.22500/unixODBC-2.3.0

make install

cd -

odbc_config --odbcinstini

./install.sh verify

./install.sh install

附录：

如有需要，安下述执行

1. python2.6安装pip

下载get-pip.py：

wget https://bootstrap.pypa.io/get-pip.py

python get-pip.py 

2. rpm安装Unixodbc

wget http://mirror.centos.org/centos/6/os/x86_64/Packages/libtool-ltdl-2.2.6-15.5.el6.x86_64.rpm

wget ftp://rpmfind.net/linux/centos/6.8/os/x86_64/Packages/unixODBC-2.2.14-14.el6.x86_64.rpm

wget ftp://rpmfind.net/linux/centos/6.8/os/x86_64/Packages/unixODBC-devel-2.2.14-14.el6.x86_64.rpm

rpm -ivh libtool-ltdl-2.2.6-15.5.el6.x86_64.rpm

rpm -ivh unixODBC-2.2.14-14.el6.x86_64.rpm

rpm -ivh unixODBC-devel-2.2.14-14.el6.x86_64.rpm

3. pip安装pyodbc

pip install pyodbc