настройка FreeTDS соединения с MSSQL
1) Установить собственно FreeTDS и unixODBC
aptitude install freetds-dev
aptitude install tdsodbcaptitude install freetds-dev
2) настроить freetds.conf, odbcinst.ini, odbc.ini
#cat /etc/odbcinst.ini
[FreeTDS]
Description = TDS driver (Sybase/MS SQL)
Driver = /usr/lib/odbc/libtdsodbc.so
Setup = /usr/lib/odbc/libtdsS.so
CPTimeout =
CPReuse =
FileUsage = 1
#cat /etc/odbc.ini
[SERVER]
Description = ODBC connection via FreeTDS
Driver = FreeTDS
Servername = wts7
Database =
UID =
PWD =
Port =
Trace = No
#cat /etc/freetds/freetds.conf
[wts7]
host = 192.168.0.67
port = 1433
tds version = 7.0
3) проверим
isql -v SERVER sa sql***
sqsh -S wts7 -U sa -P sql***
sqsh -S 192.168.0.67 -U sq -P sql***
tsql -H 192.168.0.67 -p 1433 -U sa ----- ?????
Комментариев нет:
Отправить комментарий