問(wèn)題描述

我已經(jīng)嘗試了從 4.2 到 7.2 的所有可用版本，在我看來(lái)，我嘗試過(guò)的所有版本都無(wú)效.

I have tried all the version available from 4.2 until 7.2, it seems to me all the versions I've tried are invalid.

查看錯(cuò)誤日志并根據(jù)選擇TDS協(xié)議，是SQL服務(wù)器2014 支持嗎?

Looking at the errors logs and based on the Choosing TDS protocol, is SQL server 2014 supported?

簡(jiǎn)要錯(cuò)誤:

Error 20017 (severity 9):
    Unexpected EOF from the server
    OS error 115, "Operation now in progress"
Error 20002 (severity 9):
    Adaptive Server connection failed

查看tsql轉(zhuǎn)儲(chǔ)的日志:

Looking at the log dumped by tsql:

log.c:196:Starting log file for FreeTDS 0.91
        on 2016-04-05 15:35:48 with debug flags 0x4fff.
util.c:331:tdserror(0x18ec140, 0x18ec290, 100, 0)
util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:384:tdserror: returning TDS_INT_CANCEL(2)
iconv.c:330:tds_iconv_open(0x18ec290, UTF-8)
iconv.c:187:local name for ISO-8859-1 is ISO-8859-1
iconv.c:187:local name for UTF-8 is UTF-8
iconv.c:187:local name for UCS-2LE is UCS-2LE
iconv.c:187:local name for UCS-2BE is UCS-2BE
iconv.c:349:setting up conversions for client charset "UTF-8"
iconv.c:351:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:391:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion
iconv.c:394:tds_iconv_open: done
net.c:205:Connecting to 192.168.1.221 port 4712 (TDS version 7.1)
net.c:270:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:310:tds_open_socket() succeeded
util.c:156:Changed query state from DEAD to IDLE
net.c:741:Sending packet
0000 12 01 00 34 00 00 00 00-00 00 15 00 06 01 00 1b |...4.... ........|
0010 00 01 02 00 1c 00 0c 03-00 28 00 04 ff 08 00 01 |........ .(......|
0020 55 00 00 00 4d 53 53 51-4c 53 65 72 76 65 72 00 |U...MSSQ LServer.|
0030 d3 52 00 00            -                        |.R..|

net.c:555:Received header
0000 48 54 54 50 2f 31 2e 31-                        |HTTP/1.1|

util.c:331:tdserror(0x18ec140, 0x18ec290, 20017, 115)
util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:384:tdserror: returning TDS_INT_CANCEL(2)
util.c:156:Changed query state from IDLE to DEAD
login.c:466:login packet rejected
util.c:331:tdserror(0x18ec140, 0x18ec290, 20002, 0)
util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:384:tdserror: returning TDS_INT_CANCEL(2)
mem.c:615:tds_free_all_results()

推薦答案

我不確定 SQL 服務(wù)器是否應(yīng)該像 HTTP/1.1 一樣返回 TDS 標(biāo)頭 - 看起來(lái)您正在嘗試連接到Web 服務(wù)器(和/或錯(cuò)誤的端口).

I'm not that sure that SQL server should return TDS header like HTTP/1.1 - looks like you are attempting to connect to web server (and/or wrong port).

這篇關(guān)于連接到 SQL Server 2014 的 FreeTDS 錯(cuò)誤的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！