linux下用tsql连接mssql数据库出错
来源:未知 责任编辑:智问网络 发表时间:2013-09-26 23:53 点击:次
用tsql连接mssql出现下面的错误
sh-3.2# tsql -H 192.168.1.100 -p 1433 -U sa
tsql -H 192.168.1.100 -p 1433 -U sa
Password: fuckyou
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
Error 20017 (severity 9):
Unexpected EOF from the server
OS error 115, "Operation now in progress"
Error 20002 (severity 9):
Adaptive Server connection failed
There was a problem connecting to the server
于是执行tsql -C发现freetds的版本是5.0,考虑到可能是freetds版本的问题,于是指定freetds版本为7.0,执行如下
sh-3.2# TDSVER=7.0 tsql -H 192.168.1.100 -p 1433 -U sa
TDSVER=7.0 tsql -H 192.168.1.100 -p 1433 -U sa
Password: fuckyou
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
1> select @@version
select @@version
2> go
go
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
sh-3.2# tsql -H 192.168.1.100 -p 1433 -U sa
tsql -H 192.168.1.100 -p 1433 -U sa
Password: fuckyou
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
Error 20017 (severity 9):
Unexpected EOF from the server
OS error 115, "Operation now in progress"
Error 20002 (severity 9):
Adaptive Server connection failed
There was a problem connecting to the server
于是执行tsql -C发现freetds的版本是5.0,考虑到可能是freetds版本的问题,于是指定freetds版本为7.0,执行如下
sh-3.2# TDSVER=7.0 tsql -H 192.168.1.100 -p 1433 -U sa
TDSVER=7.0 tsql -H 192.168.1.100 -p 1433 -U sa
Password: fuckyou
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
1> select @@version
select @@version
2> go
go
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
最新推荐更多>>>
- 发表评论
-
- 最新评论 更多>>