FreeTDS Development Group

[Sebastien FLAESCH <sf AT 4js.com>]

Hummm...

sf@orion:/opt3/dbs/tds/tmp/freetds$ git log | grep "Author.* Ucko" | wc -l
52

Sorry I am cannot spend too much time on this.

Attached the TDSDUMP log, if it can help...

Or if you have any other compile option to debug what's going on
and is easily testable, let me know.

Seb



On 06/27/2018 03:40 PM, Aaron Ucko wrote:
> That's not good (or intentional!), but I'm not sure why that would be;
> that combination still works for me:
>
>    $ TDSVER=7.3 ./src/apps/tsql -o v -H MSDEV1 -p 1433 -U DBAPI_test
>    Password:
>    locale is 
> "LC_CTYPE=en_US.UTF-8;LC_NUMERIC=en_US.UTF-8;LC_TIME=en_US.UTF-8;LC_COLLATE=C;LC_MONETARY=en_US.UTF-8;LC_MESSAGES=en_US.UTF-8;LC_PAPER=en_US.UTF-8;LC_NAME=en_US.UTF-8;LC_ADDRESS=en_US.UTF-8;LC_TELEPHONE=en_US.UTF-8;LC_MEASUREMENT=en_US.UTF-8;LC_IDENTIFICATION=en_US.UTF-8"
>    locale charset is "UTF-8"
>    using default charset "UTF-8"
>    1> SELECT @@version
>    2> go
>    
>    using TDS version 7.3
>    Microsoft SQL Server 2014 (SP2-GDR) (KB4057120) - 12.0.5214.6 (X64)
>         Jan  9 2018 15:03:12
>         Copyright (c) Microsoft Corporation
>         Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )
>    
>    (1 row affected)
>    using TDS version 7.3
>
> Would you mind bisecting to determine which commit broke this
> combination for you?
>
> -- Aaron Ucko <ucko at ncbi>, NCBI C++ Toolkit core development group
>
> Sebastien FLAESCH <sf AT 4js.com> writes:
>
> > I could execute our QA tests with SQL Server 2016 and 2017 without detecting
> > any regression, by using the "master" branch.
> >
> > But it fails to connect to SQL Server 2014 (12.0).
> >
> > Is there some limitation regarding the supported SQL Server version?
> >
> > ODBCINI:
> >
> > [ftm_msvtest1_ida_utf8]
> > Description     = SQL Server 2014
> > Server          = ida
> > Database        = msvtest1
> > Port            = 1681
> > TDS_Version     = 7.3
> > ClientCharset   = UTF-8
> >
> >
> > Seb
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> https://lists.ibiblio.org/mailman/listinfo/freetds

log.c:170:Starting log file for FreeTDS 1.1.dev.20180627
	on 2018-06-27 16:40:47 with debug flags 0x4fff.
iconv.c:325:tds_iconv_open(0x23fc010, UTF-8)
iconv.c:185:local name for ISO-8859-1 is ISO-8859-1
iconv.c:185:local name for UTF-8 is UTF-8
iconv.c:185:local name for UCS-2LE is UCS-2LE
iconv.c:185:local name for UCS-2BE is UCS-2BE
iconv.c:347:setting up conversions for client charset "UTF-8"
iconv.c:349:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:388:tds_iconv_open: done
net.c:387:Connecting with protocol version 7.3
net.c:314:Connecting to 10.0.40.27 port 1681
net.c:336:tds_setup_socket: connect(2) returned "Operation now in progress"
net.c:524:tds_open_socket() succeeded
packet.c:807:Sending packet
0000 12 01 00 3a 00 00 00 00-00 00 1a 00 06 01 00 20 |...:.... ....... |
0010 00 01 02 00 21 00 0c 03-00 2d 00 04 04 00 31 00 |....!... .-....1.|
0020 01 ff 09 00 00 00 00 00-00 4d 53 53 51 4c 53 65 |........ .MSSQLSe|
0030 72 76 65 72 00 b9 51 00-00 00                   |rver..Q. ..|

packet.c:435:Received packet
0000 04 01 00 2b 00 00 01 00-00 00 1a 00 06 01 00 20 |...+.... ....... |
0010 00 01 02 00 21 00 01 03-00 22 00 00 04 00 22 00 |....!... ."....".|
0020 01 ff 0c 00 08 dd 00 00-00 00 00                |........ ...|

login.c:1271:detected flag 0
tls.c:1005:setting default openssl cipher to:HIGH:!SSLv2:!aNULL:-DH
tls.c:147:in tds_push_func_login
tls.c:117:in tds_pull_func_login
packet.c:807:Sending packet
0000 12 01 00 e9 00 00 00 00-16 03 01 00 dc 01 00 00 |........ ........|
0010 d8 03 03 bc 10 18 c4 43-1f 23 48 c7 77 92 47 3f |.......C .#H.w.G?|
0020 a4 14 c9 c6 c3 52 11 3d-13 af de b5 0a 9d 9c cb |.....R.= ........|
0030 f1 9b 60 00 00 42 c0 30-c0 2c c0 28 c0 24 c0 14 |..`..B.0 .,.(.$..|
0040 c0 0a c0 32 c0 2e c0 2a-c0 26 c0 0f c0 05 00 9d |...2...* .&......|
0050 00 3d 00 35 00 84 c0 2f-c0 2b c0 27 c0 23 c0 13 |.=.5.../ .+.'.#..|
0060 c0 09 c0 31 c0 2d c0 29-c0 25 c0 0e c0 04 00 9c |...1.-.) .%......|
0070 00 3c 00 2f 00 41 00 ff-01 00 00 6d 00 0b 00 04 |.<./.A.. ...m....|
0080 03 00 01 02 00 0a 00 34-00 32 00 0e 00 0d 00 19 |.......4 .2......|
0090 00 0b 00 0c 00 18 00 09-00 0a 00 16 00 17 00 08 |........ ........|
00a0 00 06 00 07 00 14 00 15-00 04 00 05 00 12 00 13 |........ ........|
00b0 00 01 00 02 00 03 00 0f-00 10 00 11 00 23 00 00 |........ .....#..|
00c0 00 0d 00 20 00 1e 06 01-06 02 06 03 05 01 05 02 |... .... ........|
00d0 05 03 04 01 04 02 04 03-03 01 03 02 03 03 02 01 |........ ........|
00e0 02 02 02 03 00 0f 00 01-01                      |........ .|

packet.c:435:Received packet
0000 12 01 03 34 00 00 00 00-16 03 01 03 27 02 00 00 |...4.... ....'...|
0010 4d 03 01 5b 33 a1 f0 d3-fd 24 e3 70 ef 18 a4 3d |M..[3... .$.p...=|
0020 be b8 10 69 6f 11 48 38-4e 2c 20 03 c5 d0 7c 40 |...io.H8 N, ...|@|
0030 bb f0 5a 20 04 22 00 00-e9 0d 40 cf ca bc 8a 7c |..Z .".. ..@....||
0040 a7 7e 26 eb c6 13 4d 8a-3f 77 09 52 25 55 62 13 |.~&...M. ?w.R%Ub.|
0050 68 74 92 ef c0 14 00 00-05 ff 01 00 01 00 0b 00 |ht...... ........|
0060 02 03 00 02 00 00 01 fd-30 82 01 f9 30 82 01 62 |........ 0...0..b|
0070 a0 03 02 01 02 02 10 16-8e 3c 21 93 c7 ec bb 4e |........ .<!....N|
0080 c9 f7 ff c6 1e bd ee 30-0d 06 09 2a 86 48 86 f7 |.......0 ...*.H..|
0090 0d 01 01 05 05 00 30 3b-31 39 30 37 06 03 55 04 |......0; 1907..U.|
00a0 03 1e 30 00 53 00 53 00-4c 00 5f 00 53 00 65 00 |..0.S.S. L._.S.e.|
00b0 6c 00 66 00 5f 00 53 00-69 00 67 00 6e 00 65 00 |l.f._.S. i.g.n.e.|
00c0 64 00 5f 00 46 00 61 00-6c 00 6c 00 62 00 61 00 |d._.F.a. l.l.b.a.|
00d0 63 00 6b 30 1e 17 0d 31-38 30 36 32 37 30 39 35 |c.k0...1 80627095|
00e0 37 31 32 5a 17 0d 34 38-30 36 32 37 30 39 35 37 |712Z..48 06270957|
00f0 31 32 5a 30 3b 31 39 30-37 06 03 55 04 03 1e 30 |12Z0;190 7..U...0|
0100 00 53 00 53 00 4c 00 5f-00 53 00 65 00 6c 00 66 |.S.S.L._ .S.e.l.f|
0110 00 5f 00 53 00 69 00 67-00 6e 00 65 00 64 00 5f |._.S.i.g .n.e.d._|
0120 00 46 00 61 00 6c 00 6c-00 62 00 61 00 63 00 6b |.F.a.l.l .b.a.c.k|
0130 30 81 9f 30 0d 06 09 2a-86 48 86 f7 0d 01 01 01 |0..0...* .H......|
0140 05 00 03 81 8d 00 30 81-89 02 81 81 00 d9 09 8a |......0. ........|
0150 d9 55 c9 c2 ff d5 00 90-ea a7 c9 09 02 ab a6 e9 |.U...... ........|
0160 d5 52 ca 3c 75 39 ca f7-a3 ee 45 83 65 54 d4 7c |.R.<u9.. ..E.eT.||
0170 1a 45 0d f9 2d 6a 23 81-5f a8 a6 b8 aa a0 49 7e |.E..-j#. _.....I~|
0180 85 01 18 4b 5f 4b c9 7c-8f 0b 32 02 29 70 14 12 |...K_K.| ..2.)p..|
0190 cb e9 bd 72 0e f0 51 0b-19 4e bf 13 c9 6e 0f ab |...r..Q. .N...n..|
01a0 f9 44 90 88 a0 9a d3 58-5f 30 77 4a bb d0 36 5a |.D.....X _0wJ..6Z|
01b0 f7 b5 b4 52 5f 84 6b ac-87 c7 90 56 6c 5e 40 f3 |...R_.k. ...Vl^@.|
01c0 43 98 15 8f a3 54 9c 94-5b ff fe db d9 02 03 01 |C....T.. [.......|
01d0 00 01 30 0d 06 09 2a 86-48 86 f7 0d 01 01 05 05 |..0...*. H.......|
01e0 00 03 81 81 00 41 cf ce-7e 84 1c 81 4c 1e 57 9e |.....A.. ~...L.W.|
01f0 24 7a bb 3b d2 93 ff 24-2a 20 0f a2 66 52 26 47 |$z.;...$ * ..fR&G|
0200 eb 56 84 45 bc 10 52 a7-b1 6b 13 18 dc 28 75 22 |.V.E..R. .k...(u"|
0210 fd 14 61 af 18 b1 34 65-ea 4c aa b0 48 7f 9a 17 |..a...4e .L..H...|
0220 ab ea 5a 54 48 43 02 fe-97 f9 03 65 f0 de 4d a8 |..ZTHC.. ...e..M.|
0230 ee cf fa 97 47 73 54 ce-27 b8 17 1a 90 3b 7c 38 |....GsT. '....;|8|
0240 5d 02 96 8f b0 ea d4 7e-4b e8 61 39 43 fe 04 44 |]......~ K.a9C..D|
0250 8b f5 87 e7 42 fa 0b 0f-d2 4d a8 ed 61 4e c3 77 |....B... .M..aN.w|
0260 3f a0 58 8a a4 0c 00 00-c7 03 00 17 41 04 69 c5 |?.X..... ....A.i.|
0270 41 12 19 23 05 dd 67 22-40 86 d2 f0 5a d5 35 41 |A..#..g" @...Z.5A|
0280 4f 00 64 c1 89 e0 37 35-54 14 c8 34 fd 35 26 e2 |O.d...75 T..4.5&.|
0290 9c 5b 58 51 68 c1 74 a0-ef 8d 94 7c 21 18 ee 61 |.[XQh.t. ...|!..a|
02a0 6a e9 68 bc a5 03 be 5a-0f f4 21 db fc 93 00 80 |j.h....Z ..!.....|
02b0 3b 3a 51 3b ce c6 79 5d-08 0a e6 b6 0c 40 3b d3 |;:Q;..y] .....@;.|
02c0 74 7c 2b e0 3f fc d0 ca-0a 78 08 43 0b 5d 67 1f |t|+.?... .x.C.]g.|
02d0 4d 09 ca 8b 15 4e 2a 41-6f 33 47 66 58 fc c4 bf |M....N*A o3GfX...|
02e0 a4 5e 7e 16 46 47 1a 8b-d9 93 2c dc 0e 83 ca 45 |.^~.FG.. ..,....E|
02f0 08 b4 78 18 c7 bd 2c 31-f5 07 9b 9d 80 29 81 3b |..x...,1 .....).;|
0300 c8 a7 83 cf c4 84 a3 58-0d 4c 49 84 a3 8c ef e8 |.......X .LI.....|
0310 4d 4f 3c 0e 0e 4e 70 45-04 bb 9e ae 26 d8 22 22 |MO<..NpE ....&.""|
0320 53 dd 00 ae da 9c 76 20-5b af bb 47 64 0c e7 d8 |S.....v  [..Gd...|
0330 0e 00 00 00            -                        |....|

tls.c:1021:handshake failed with -1 4640 1
tls.c:1062:handshake failed
login.c:570:login packet rejected
query.c:3803:tds_disconnect() 
util.c:177:Changed query state from IDLE to DEAD
util.c:331:tdserror(0x23f8e50, 0x23fc3f0, 20002, 0)
odbc.c:2366:msgno 20002 20003
util.c:362:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
mem.c:658:tds_free_all_results()
error.c:414:odbc_errs_add: "Unable to connect to data source"
error_export.h:43:SQLGetDiagRec(2, 0x23f91d0, 1, 0x7ffcf29dcbf0, 0x7ffcf29dcbac, 0x7ffcf29dcc00, 513, 0x7ffcf29dcbaa)
error.c:559:SQLGetDiagRec: "[FreeTDS][SQL Server]Adaptive Server connection failed"
error_export.h:43:SQLGetDiagRec(2, 0x23f91d0, 2, 0x7ffcf29dcbf0, 0x7ffcf29dcbac, 0x7ffcf29dcc00, 513, 0x7ffcf29dcbaa)
error.c:559:SQLGetDiagRec: "[FreeTDS][SQL Server]Unable to connect to data source"
odbc.c:4058:SQLFreeHandle(2, 0x23f91d0)
odbc.c:4084:_SQLFreeConnect(0x23f91d0)
bcp.c:676:_bcp_free_storage(0x23f91d0)