本文主要是介绍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)的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!