以下是我的代码详细信息
Step 1.
/etc/freetds/freettds.conf
[mssql]
host = 192.168.1.10
port = 1433
tds version =8.0
client charset = UTF-8
Step 2
/etc/odbcinst.ini
[FreeTDS]
Description = FreeTDS
Driver = /usr/lib/i386-linux-gnu/odbc/libtdsodbc.so
Setup = /usr/lib/i386-linux-gnu/odbc/libtdsS.so
Step 3
/etc/odbc.ini
[mssqltest]
Description = MS SQL connection to mssqltest database
Driver = FreeTDS
Database = cakephp_results
Server = mssql
UserName = sa
Password = sa
Trace = Yes
Port = 1433
我尝试使用以下命令通过命令行连接sql:
$ tsql -S mssqltest -U sa -P sa
Error 20012 (severity 2):
Server name not found in configuration files.
locale is "en_IN"
locale charset is "UTF-8"
using default charset "UTF-8"
Error 20013 (severity 2):
Unknown host machine name.
There was a problem connecting to the server
发布于 2013-07-09 07:55:40
您应该将/etc/freetds.conf
复制到您的主文件夹,并在其名称前加上点,如下所示:
cp /etc/freetds.conf ~/.freetds.conf
看起来它会搜索每个用户的配置,我最近也遇到了同样的问题。
发布于 2015-08-25 19:02:56
创建一个~/.freetds.conf
应该适合您。它对我来说很好
https://stackoverflow.com/questions/17064066
复制