centos下pymssql的安装及使用

pip install pymssql

python setup.py build


错误：Python.h：没有那个文件或目录
参考：http://www.cnblogs.com/yuxc/archive/2012/05/13/2498019.html
解决：yum install python-devel -y


错误：invalid command 'bdist_wheel'
参考：http://blog.csdn.net/jishan7/article/details/48653659
解决：pip install setuptools --upgrade


错误：/usr/local/lib/libpython2.6.a(abstract.o): relocation R_X86_64_32 against `.rodata.str1.8' can not be used when making a shared object; recompile with -fPIC
参考：http://taoo.iteye.com/blog/1826912
解决：源码安装python2.6.6，

./configure --prefix=/home/python/2.6.6/setup/ -enable-shared CFLAGS=-fPIC
make -j
make install
mv /usr/local/lib/libpython2.6.a /usr/local/lib/libpython2.6.a.bak
cp /home/python/2.6.6/setup/lib/python2.6/config/libpython2.6.a /usr/local/lib/libpython2.6.a


使用
参考：http://blog.csdn.net/five3/article/details/16338191