离线安装freeTDS
下载freetds-1.00.109
官网下载页面:http://www.freetds.org/files/stable/
版本下载地址:http://www.freetds.org/files/stable/freetds-1.00.109.tar.gz
编译安装freetds
tar xvf freetds-1.00.109.tar.gz;
cd freetds-1.00.109;
#--with-unixodbc=/usr/local/unixODBC-2.3.7
./configure --prefix=/usr/local/freetds --with-tdsver=7.4 --enable-msdblib --enable-dbmfix --enable-shared --enable-static;
make;
make install;
#解释
-------------------------------------------
>--prefix设置FreeTDS的安装目录
>--with-tdsver设置TDS版本
>--enable-msdblib允许Microsoft数据库函数库
-------------------------------------------
#将tsql命令加入环境变量
-------------------------------------------
vim ~/.bashrc;
-------------------------------------------
>FREETDS_HOME=/usr/local/freetds
>export PATH=$FREETDS_HOME/bin:$PATH
-------------------------------------------
source ~/.bashrc;
-------------------------------------------
tsql -C; #查看版本信息
-------------------------------------------
>Compile-time settings (established with the "configure" script)
> Version: freetds v1.00.109
> freetds.conf directory: /usr/local/freetds/etc
> MS db-lib source compatibility: yes
> Sybase binary compatibility: no
> Thread safety: yes
> iconv library: yes
> TDS version: 7.4
> iODBC: no
> unixodbc: no
> SSPI "trusted" logins: no
> Kerberos: no
> OpenSSL: no
> GnuTLS: no
> MARS: no
-----------------------------------------------------------
#库文件加载
echo "/usr/local/freetds/lib" > /etc/ld.so.conf.d/freetds.conf;
ldconfig;
修改配置文件,连接数据库
vim /usr/local/freetds/etc/freetds.conf;
------------------------------------
#sqlserver 2012配置
>[sql-server-2012]
> host = xxx.xxx.xxx
> port = 1433
> tds version = 7.4
#sqlserver 2005配置
>[2005SQL]
> host = xxx.xxx.xxx
> port = 1433
> tds version = 8.0
#sqlserver 2008配置
>[sql-server-2008]
> host = xxx.xxx.xxx
> port = 1433
> tds version = 8.0
> client chaeset = UTF-8
------------------------------------
#测试连接
tsql -S sql-server-2008 -U 用户名 -P 密码;
use test;#使用指定数据库
go;
离线安装pymssql
离线安装pip
扩展包下载地址:https://pypi.org/project
tar xvf setuptools-0.6c11.tar.gz;
tar xvf pip-18.1.tar.gz;
cd setuptools-0.6c11 && python setup.py install;
cd pip-18.1 && python setup.py install;