wget http://www.unixodbc.org/unixODBC-2.3.7.tar.gz
tar zxvf unixODBC-2.3.7.tar.gz
cd unixODBC-2.3.7
./configure
make
make install
添加配置
vi /usr/local/etc/odbc.ini
[SQLTest]
Driver = FreeTDS
Description = OBDC FreeTDS
Database = db_test
Servername = SQLTest
vi /usr/local/etc/odbcinst.ini
[FreeTDS]
Description = ODBC for FreeTDS
Driver = /usr/local/lib/libtdsodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so
安装freetds(驱动SQLServer)
wget ftp://ftp.freetds.org/pub/freetds/stable/freetds-0.91.100.tar.gz
./configure --with-sdsver=8.0 --with-unixODBC=/usr/local # --enable-msdblib=yes C语言使用
make
make install
添加配置
vi /usr/local/etc/freetds.conf最后添加
[SQLTest]
host = 192.168.2.9
port = 1433
tds version = 8.0
连接测试
tsql -H 192.168.2.9 -p 1433 -U sa -P sa ==> 1>
tsql -S SQLTest -U sa ===> 1>
odbcinst -q -s ==> [SQLTest]
isql -v SQLTest 用户名 密码 ==> Connected!