linux访问sqlserver配置（CentOS6.8访问sqlserver2005）

本文主要是介绍linux访问sqlserver配置（CentOS6.8访问sqlserver2005），希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

1、安装Linux系统的ODBC

wget http://mirrors.163.com/centos/6/os/x86_64/Packages/unixODBC-2.2.14-14.el6.x86_64
wget http://mirrors.163.com/centos/6/os/x86_64/Packages/unixODBC-devel-2.2.14-14.el6.x86_64
wget http://mirrors.163.com/centos/6/os/x86_64/Packages/unixODBC-kde-2.2.14-14.el6.x86_64rpm -ivh unixODBC-2.2.14-14.el6.x86_64
rpm -ivh unixODBC-devel-2.2.14-14.el6.x86_64
rpm -ivh unixODBC-kde-2.2.14-14.el6.x86_64

2、FreeTDS的安装与配置

下载：freetds-stable.tgz

http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
tar -zxvf freetds-stable.tgz
cd freetds-0.91/
./configure --prefix=/usr/local/freetds --with-tdsver=7.1  --enable-msdblib --with-gnu-ld --enable-shared --enable-static
make
make install

3、配置 unixODBC 和 FreeTDS

3.1配置freetds的数据源

vi /usr/local/freetds/etc/freetds.conf

[mssql]
host = 192.168.100.9
port = 1433
tds version = 7.0

测试数据源

/usr/local/freetds/bin/tsql -S mssql -U sa -P password -D database

提示如下，证明配置成功。

locale is "zh_CN.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
Default database being set to bodycheck
1> 

3.2向unixODBC 登记 FreeTDS 驱动，指明odbc的驱动程序

vi /etc/odbcinst.ini

[SQLSERVER]
Description=freetds driver
Driver=/usr/local/freetds/lib/libtdsodbc.so

3.3配置odbc.ini

vi /etc/odbc.ini

[sql]
Driver=MSSQLSERVER            #驱动名
Description=MSSQL Server
Servername=mssql              #数据源
Database=database

配置完成，访问数据库
isql -v sql user password

+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> 

这篇关于linux访问sqlserver配置（CentOS6.8访问sqlserver2005）的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---