unixODBC MS SQL Server 安装配置
1.安装unixodbc
2.安装freetds
修改/etc/profile
#
# TDS
#
#SYBASE为freetds的安装路径
SYBASE=/usr/local
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$SYBASE/lib
export SYBASE LD_LIBRARY_PATH
安装tds
# ./configure --with-tdsver=7.0 --with-unixodbc=/usr/local
# make
# make install
3.配置tds
如果是默认安装路径在/usr/local/etc/freetds.conf
4.增加dns
安装驱动
/usr/local/etc/odbcinst.ini
[TDS]
Description = v0.52 with protocol v4.2
Driver = /usr/local/lib/libtdsodbc.so
存成tds.driver.template
可运行安装驱动,也可以直接修改odbcinst.ini
odbcinst -i -d -f tds.driver.template
添加dns
/usr/local/etc/odbc.ini 设置系统dns
~/.odbc.ini 设置用户dns
[P450]
Driver = TDS
Description = Northwind sample database
Trace = No
Server = 192.168.1.25
Database = Northwind
UID = sa
保存成tds.datasource.template
运行
odbcinst -i -s -f tds.datasource.template
也可以直接配置odbc.ini
4.可以isql -v P450 sa MyPassword
连接数据库了