我正在尝试从Ubuntu连接到MSSQL服务器。 我已经像这里建议的那样安装了freetds。
然而,当我尝试配置/etc/odbc.ini并输入驱动程序路径时,我在位置/usr/local/freetds/lib/libtdsodbc.so
找不到驱动程序。
有人能帮我安装freetds并配置odbc以使用它吗? *编辑1:我已在/usr/lib/x86_64-linux-gnu/odbc中找到libtdsodbc.so。 我应该使用那个驱动程序/路径吗?
我正在尝试从Ubuntu连接到MSSQL服务器。 我已经像这里建议的那样安装了freetds。
然而,当我尝试配置/etc/odbc.ini并输入驱动程序路径时,我在位置/usr/local/freetds/lib/libtdsodbc.so
找不到驱动程序。
有人能帮我安装freetds并配置odbc以使用它吗? *编辑1:我已在/usr/lib/x86_64-linux-gnu/odbc中找到libtdsodbc.so。 我应该使用那个驱动程序/路径吗?
# Install pre-requesite packages
sudo apt-get install unixodbc unixodbc-dev freetds-dev freetds-bin tdsodbc
[FreeTDS]
Description = v0.91 with protocol v7.2
Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
[dbserverdsn]
Driver = FreeTDS
Server = dbserver.domain.com
Port = 1433
TDS_Version = 7.2
[global]
# TDS protocol version, use:
# 7.3 for SQL Server 2008 or greater (tested through 2014)
# 7.2 for SQL Server 2005
# 7.1 for SQL Server 2000
# 7.0 for SQL Server 7
tds version = 7.2
port = 1433
# Whether to write a TDSDUMP file for diagnostic purposes
# (setting this to /tmp is insecure on a multi-user system)
; dump file = /tmp/freetds.log
; debug flags = 0xffff
# Command and connection timeouts
; timeout = 10
; connect timeout = 10
# If you get out-of-memory errors, it may mean that your client
# is trying to allocate a huge buffer for a TEXT field.
# Try setting 'text size' to a more reasonable limit
text size = 64512
# A typical Microsoft server
[dbserverdsn]
host = dbserver.domain.com
port = 1433
tds version = 7.2
Server = dbserver.domain.com
更改为我的服务器IP吗?这样我才能使用tsql tsql -S dbserverdsn
,还是应该在那里写IP?当我使用tsql -S dbserverdsn
时,我得到了Error 100 (severity 11): unrecognized msgno Error 20009 (severity 9):Unable to connect: Adaptive Server is unavailable or does not exist OS error 111, "Connection refused" There was a problem connecting to the server
的错误信息。 - Hrvoje Ttsql -C
命令检查了 TDS 版本,发现它是 4.2。我将上面的 7.2 替换为 4.2,这似乎解决了 msgno error
的问题。 - Jay Killeen通过apt-get
可获得的版本实在太老了。要获取更新版本:
sudo apt-get install wget
sudo apt-get install build-essential
sudo apt-get install libc6-dev
# find latest version of FreeTDS ftp://ftp.freetds.org/pub/freetds/stable/
wget ftp://ftp.freetds.org/pub/freetds/stable/freetds-1.2.tar.gz
tar -xzf freetds-1.2.tar.gz
cd freetds-1.2
./configure --prefix=/usr/local --with-tdsver=7.3
sudo make
sudo make install
1.12
(2019/07)。 - ˈvɔlə在freedts.conf文件中
[Server80]
host = example.com
port = 1433
tds version = 8.0
client charset = UTF-8
in odbc.ini
[MSSQL8]
Driver = FreeTDS
Description = Sybase JDBC Server
Trace = No
Servername = Server80
Database = DBNAME
UID = sa
ClientCharset = UTF-8
在odbcinst.ini文件中
[FreeTDS]
Description=v0.63 with protocol v8.0
Driver=/usr/lib/i386-linux-gnu/odbc/libtdsodbc.so
UsageCount=2
sudo apt install -y freetds-bin
进行工作! - Peter Krauss