python 安装mssql扩展
原创
©著作权归作者所有:来自51CTO博客作者jack_cap的原创作品,请联系作者获取转载授权,否则将追究法律责任
开始很自然的想到
easy_install pymssql
出现
Searching for pymssql
Reading https://pypi.python.org/simple/pymssql/
Reading http:///p/pymssql/
Reading http:///p/pymssql/downloads/list
Reading http://pymssql.sourceforge.net
Download error on http://pymssql.sourceforge.net: timed out -- Some packages may not be found!
Reading http://sourceforge.net/project/showfiles.php?group_id=40059&package_id=32202
Best match: pymssql 2.0.0b1-dev-20130403
Downloading http:///files/pymssql-2.0.0b1-dev-20130403.tar.gz
Processing pymssql-2.0.0b1-dev-20130403.tar.gz
Writing /tmp/easy_install-Q0iuH6/pymssql-2.0.0b1-dev-20130403/setup.cfg
Running pymssql-2.0.0b1-dev-20130403/setup.py -q bdist_egg --dist-dir /tmp/easy_install-Q0iuH6/pymssql-2.0.0b1-dev-20130403/egg-dist-tmp-iZ2UMu
creating tmp
creating tmp/easy_install-Q0iuH6
creating tmp/easy_install-Q0iuH6/pymssql-2.0.0b1-dev-20130403
creating tmp/easy_install-Q0iuH6/pymssql-2.0.0b1-dev-20130403/temp
cc -c /tmp/easy_install-Q0iuH6/pymssql-2.0.0b1-dev-20130403/temp/clock_gettime8KzG4j.c -o tmp/easy_install-Q0iuH6/pymssql-2.0.0b1-dev-20130403/temp/clock_gettime8KzG4j.o
cc tmp/easy_install-Q0iuH6/pymssql-2.0.0b1-dev-20130403/temp/clock_gettime8KzG4j.o -lrt -o a.out
warning: no files found matching 'win32/freetds.zip'
/usr/bin/ld: cannot find -lct
collect2: ld returned 1 exit status
error: Setup script exited with error: command 'gcc' failed with exit status 1
很自然以为系统没有安装python-devel
yum install python-devel
显示已经安装
然后从pypi下载软件包安装
python setup.py build
running build
running build_ext
skipping '_mssql.c' Cython extension (up-to-date)
building '_mssql' extension
gcc -pthread -fno-strict-aliasing -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -fPIC -I/root/pymssql-2.0.0b1-dev-20130403/freetds/nix_64/include -I/usr/include/python2.6 -c _mssql.c -o build/temp.linux-x86_64-2.6/_mssql.o -Wno-parentheses-equality -DMSDBLIB
gcc -pthread -shared build/temp.linux-x86_64-2.6/_mssql.o -L/root/pymssql-2.0.0b1-dev-20130403/freetds/nix_64/lib -L/usr/lib64 -lsybdb -lct -lrt -lpython2.6 -o build/lib.linux-x86_64-2.6/_mssql.so
/usr/bin/ld: cannot find -lct
collect2: ld returned 1 exit status
error: command 'gcc' failed with exit status 1
还是gcc 不过上面说skipping '_mssql.c' Cython extension (up-to-date)
然后查看build/temp.linux-x86_64-2.6/目录空空
说明库没有编译上
google了一下发现是freetds的问题
下载安装
过程如下:
tar xvf freetds-stable.tgz
cd freetds-0.91/
./configure --with-tdsver=8.0 --enable-msdblib
make && make install
解决问题
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
Mssql安装使用
我之前用过sql server,后来使用频率较少,最近有开始接触了,顺便整理下笔记,为后续准备~mssql 也是遵循sql92标准的,所以语法基本与mysql 等都是一致有一些数据类型, 函数等;
sqlserver 数据库 sql docker 分页 -
mssql 安装包 python
1. 概述ORACLE透明网关for MSSQL的产品名称为Oracle Transparent Gateway for SQL Server。使用该产品后,对于Oracle数据库而言,屏蔽了SQL Server的异构性,可直接在Oracle数据库中对SQL Server数据进行大多数操作。通过透明网关在出口退税审核系统和综合管理系统建立DB Link,可实现数据的定时抽取
mssql 安装包 python oracle sql server microsoft windows
















