Installing the Pymssql module for Python to connect to SQL Server

1. Install dependent packages

Yum install-y gcc Python-devel

2, installation FreeTDS

: Http://pan.baidu.com/s/1pLKtFBl

Tar zxvf freetds-0.82.tar.gz

CD freetds-0.82

./configure--prefix=/usr/local/freetds--with-tdsver=8.0--enable-msdblib--enable-dbmfix--with-gnu-ld-- Enable-shared--enable-static

Make && make install

echo "/usr/local/freetds/lib" >>/etc/ld.so.conf.d/freetds.conf

Ldconfig-v

3, Installation Setuptools

: Http://pan.baidu.com/s/1bpDW8cZ

Tar zxvf setuptools-28.8.0.tar.gz

CD setuptools-28.7.1

Python setup.py Install

4, Installation Pymssql

: Http://pan.baidu.com/s/1kVa0DKz

Tar zxvf pymssql-2.1.0.tar.gz

CD pymssql-2.1.0

Python setup.py Install

Note: Install FreeTDS, will report the following error

Error:command ' gcc ' failed with exit status 1

Installing the Pymssql module for Python to connect to SQL Server