freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol()
- From: Sebastien FLAESCH <sf AT 4js.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol()
- Date: Thu, 21 Feb 2019 15:16:57 +0100
Testing FreeTDS 1.1rc3 with SQL Server 2019:
I get an unexpected SQL type code with a CHAR(10) column, when the
database collation is using UTF-8.
Instead of SQL_CHAR (or SQL_WCHAR), I get SQL_WVARCHAR.
I have created a database with this collation:
Latin1_General_100_CI_AS_SC_UTF8
Then created a table like this:
CREATE TABLE mytab1 ( col1 CHAR(10) )
and inserted a row:
INSERT INTO mytab1 VALUES ( 'abc' )
Then in the ODBC program:
SQLExecDirect(.."SELECT * FROM mytab1"..)
SQLDescribCol(...)
Check the TDSDUMP trace in attachment (freetds-2019-1.log)
token.c:1541:tds7_get_data_info:
colname = col1
type = 39 (varchar)
server's type = 231 (x UCS-2 varchar) <-- 231 ?
column_varint_size = 2
column_size = 20 (20 on server)
The same program, connecting to SQL Server 2017 (were DB collation is Latin1
without UTF-8):
token.c:1541:tds7_get_data_info:
colname = col1
type = 47 (char)
server's type = 175 (xchar) <-- 175
column_varint_size = 2
column_size = 10 (10 on server)
With SQL Server 2019, when using another collation (non-UTF-8)
CREATE TABLE mytab2 ( col1 CHAR(10) COLLATE Latin1_General_CI_AS )
I get the expected tds type code...
Seb
log.c:168:Starting log file for FreeTDS 1.1rc3
on 2019-02-21 15:14:16 with debug flags 0x4fff.
iconv.c:326:tds_iconv_open(0x612000000640, UTF-8)
iconv.c:186:local name for ISO-8859-1 is ISO-8859-1
iconv.c:186:local name for UTF-8 is UTF-8
iconv.c:186:local name for UCS-2LE is UCS-2LE
iconv.c:186:local name for UCS-2BE is UCS-2BE
iconv.c:348:setting up conversions for client charset "UTF-8"
iconv.c:350:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:389:tds_iconv_open: done
net.c:391:Connecting with protocol version 7.3
net.c:318:Connecting to 10.0.40.27 port 1684
net.c:340:tds_setup_socket: connect(2) returned "Operation now in progress"
net.c:528:tds_open_socket() succeeded
packet.c:801: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 3d 13 00-00 00 |rver.=.. ..|
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 0f 00 04 b0 00 00-00 00 00 |........ ...|
login.c:1253:detected flag 0
tls.c:1012: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:801:Sending packet
0000 12 01 00 ca 00 00 00 00-16 03 01 00 bd 01 00 00 |........ ........|
0010 b9 03 03 f2 bd 01 02 37-3e f7 ff e2 97 97 6b c0 |.......7 >.....k.|
0020 ae 48 ed 18 ea 9d ce b1-f6 c0 80 b0 dd 3e 14 a7 |.H...... .....>..|
0030 ee fc 87 00 00 4a c0 2c-c0 30 cc a9 cc a8 c0 af |.....J., .0......|
0040 c0 ad c0 2b c0 2f c0 ae-c0 ac c0 24 c0 28 c0 73 |...+./.. ...$.(.s|
0050 c0 77 c0 23 c0 27 c0 72-c0 76 c0 0a c0 14 c0 09 |.w.#.'.r .v......|
0060 c0 13 00 9d c0 a1 c0 9d-00 9c c0 a0 c0 9c 00 3d |........ .......=|
0070 00 c0 00 3c 00 ba 00 35-00 84 00 2f 00 41 00 ff |...<...5 .../.A..|
0080 01 00 00 46 00 0b 00 04-03 00 01 02 00 0a 00 0a |...F.... ........|
0090 00 08 00 1d 00 17 00 19-00 18 00 23 00 00 00 16 |........ ...#....|
00a0 00 00 00 17 00 00 00 0d-00 20 00 1e 06 01 06 02 |........ . ......|
00b0 06 03 05 01 05 02 05 03-04 01 04 02 04 03 03 01 |........ ........|
00c0 03 02 03 03 02 01 02 02-02 03 |........ ..|
packet.c:435:Received packet
0000 12 01 04 9e 00 00 00 00-16 03 03 04 91 02 00 00 |........ ........|
0010 51 03 03 5c 6e b2 38 e2-7b e3 ac 59 42 b4 f9 f2 |Q..\n.8. {..YB...|
0020 4b 43 f2 ef a3 be b6 c1-ce a5 90 5d 29 00 7b 28 |KC...... ...]).{(|
0030 d1 eb b3 20 84 46 00 00-17 b7 49 ee 91 93 a1 d5 |... .F.. ..I.....|
0040 0b 1a 65 18 4a 7a fe 0a-26 c7 80 59 ab 81 30 9f |..e.Jz.. &..Y..0.|
0050 fc 29 e7 c7 c0 30 00 00-09 00 17 00 00 ff 01 00 |.)...0.. ........|
0060 01 00 0b 00 03 08 00 03-05 00 03 02 30 82 02 fe |........ ....0...|
0070 30 82 01 e6 a0 03 02 01-02 02 10 28 7e 47 1f 3d |0....... ...(~G.=|
0080 bb 23 be 4b b2 dc 3c fd-45 27 ed 30 0d 06 09 2a |.#.K..<. E'.0...*|
0090 86 48 86 f7 0d 01 01 0b-05 00 30 3b 31 39 30 37 |.H...... ..0;1907|
00a0 06 03 55 04 03 1e 30 00-53 00 53 00 4c 00 5f 00 |..U...0. S.S.L._.|
00b0 53 00 65 00 6c 00 66 00-5f 00 53 00 69 00 67 00 |S.e.l.f. _.S.i.g.|
00c0 6e 00 65 00 64 00 5f 00-46 00 61 00 6c 00 6c 00 |n.e.d._. F.a.l.l.|
00d0 62 00 61 00 63 00 6b 30-1e 17 0d 31 39 30 32 31 |b.a.c.k0 ...19021|
00e0 39 31 37 35 33 31 30 5a-17 0d 34 39 30 32 31 39 |9175310Z ..490219|
00f0 31 37 35 33 31 30 5a 30-3b 31 39 30 37 06 03 55 |175310Z0 ;1907..U|
0100 04 03 1e 30 00 53 00 53-00 4c 00 5f 00 53 00 65 |...0.S.S .L._.S.e|
0110 00 6c 00 66 00 5f 00 53-00 69 00 67 00 6e 00 65 |.l.f._.S .i.g.n.e|
0120 00 64 00 5f 00 46 00 61-00 6c 00 6c 00 62 00 61 |.d._.F.a .l.l.b.a|
0130 00 63 00 6b 30 82 01 22-30 0d 06 09 2a 86 48 86 |.c.k0.." 0...*.H.|
0140 f7 0d 01 01 01 05 00 03-82 01 0f 00 30 82 01 0a |........ ....0...|
0150 02 82 01 01 00 bb 71 e5-83 fc bc 85 d4 5a 5d ed |......q. .....Z].|
0160 f8 d5 7b ad 87 f9 86 8e-25 fc d4 05 c3 a2 9f 05 |..{..... %.......|
0170 be b9 6d a8 6e a3 70 a8-60 50 7a 5b e1 e5 19 01 |..m.n.p. `Pz[....|
0180 7b 87 8f f2 ab bb da f7-04 99 a5 d3 be 5a 10 b0 |{....... .....Z..|
0190 cc 77 77 b5 ff 81 36 e9-55 ad cf cd 83 e2 39 3e |.ww...6. U.....9>|
01a0 15 54 4a 30 ff d9 ee 7e-f0 25 32 c3 e9 97 76 02 |.TJ0...~ .%2...v.|
01b0 e4 21 22 b9 ba c8 31 4d-dc b5 88 c7 7c 67 90 da |.!"...1M ....|g..|
01c0 f9 9d dd 7f 6e 97 23 de-5a 80 f7 23 92 9c d4 23 |....n.#. Z..#...#|
01d0 4f 6e a5 17 87 66 3a 2c-0b 99 dd d4 28 5a 25 d9 |On...f:, ....(Z%.|
01e0 f7 3a fb 6d 1a 97 9a a1-04 3f 2c 74 20 52 d3 a3 |.:.m.... .?,t R..|
01f0 01 00 24 f2 85 1d bd d0-82 7d 35 db 06 87 83 25 |..$..... .}5....%|
0200 ba e0 b8 94 74 a3 3e e4-aa ea 19 10 e0 30 04 1c |....t.>. .....0..|
0210 60 81 9d 84 bc 39 00 1a-d0 e6 2a 14 34 71 e7 d5 |`....9.. ..*.4q..|
0220 49 27 e1 f2 cd 43 e5 44-97 48 0c 87 55 1c 18 f2 |I'...C.D .H..U...|
0230 5d 08 db 55 85 6a 21 83-35 a8 29 b6 6a 70 52 32 |]..U.j!. 5.).jpR2|
0240 06 0b 49 da c7 80 9d d8-90 f8 0d 69 ac eb 02 27 |..I..... ...i...'|
0250 7b 8d 56 f0 85 02 03 01-00 01 30 0d 06 09 2a 86 |{.V..... ..0...*.|
0260 48 86 f7 0d 01 01 0b 05-00 03 82 01 01 00 88 8a |H....... ........|
0270 a1 b7 dc ea fc dc 5f db-53 da 9a 4b 8a 12 55 81 |......_. S..K..U.|
0280 83 12 62 c1 fc 5c 91 b5-eb 9a 06 58 5d 70 f1 af |..b..\.. ...X]p..|
0290 aa 35 c0 1c 84 c0 ae 91-5c cb 95 ed 6b 2c 92 64 |.5...... \...k,.d|
02a0 c7 c4 32 cc 13 64 42 90-2a aa 19 a4 a7 92 46 c3 |..2..dB. *.....F.|
02b0 e5 6a 1f 94 a8 97 f8 87-6f ce 1b d8 b6 b6 dd 84 |.j...... o.......|
02c0 ed 03 cd 69 03 3b 9b 8f-c2 40 9b a0 37 3c b5 68 |...i.;.. .@..7<.h|
02d0 56 03 4a dc fb 28 79 4c-3b 28 da fe 03 3c 07 03 |V.J..(yL ;(...<..|
02e0 3d ad a4 5a 7a 36 2f 49-d6 eb 01 41 27 c5 94 62 |=..Zz6/I ...A'..b|
02f0 ff 19 5f 19 7f d0 ea 47-04 f8 06 6b c8 31 c3 04 |.._....G ...k.1..|
0300 1b 90 7e 16 f5 0d 17 4c-8a 9e f9 10 26 f5 ca 40 |..~....L ....&..@|
0310 2c de c4 ee 77 bd 0b 2d-46 2b c7 79 34 77 d2 0b |,...w..- F+.y4w..|
0320 39 6c 3d 26 6b 2d d8 ac-54 5c 46 a0 f0 48 3b d1 |9l=&k-.. T\F..H;.|
0330 22 d9 7f 8b b9 c7 3b 2e-40 87 d0 a5 9d 48 0b 73 |".....;. @....H.s|
0340 ad 36 66 03 d5 7d a4 d4-1d 81 19 e0 c1 93 f4 28 |.6f..}.. .......(|
0350 41 6f 16 c3 3b 24 6d 7d-03 8a 6b 4c 36 32 e0 9b |Ao..;$m} ..kL62..|
0360 b5 10 4f 52 ed bb ad 21-5c c6 27 dc be e3 0c 00 |..OR...! \.'.....|
0370 01 28 03 00 1d 20 59 d4-27 ef ec fa d8 d8 bd 2b |.(... Y. '......+|
0380 7e 3f 8c 40 da f6 f8 00-b2 66 01 86 a9 91 27 8e |~?.@.... .f....'.|
0390 ad 39 a7 6b 71 4c 04 01-01 00 26 a7 59 bb 28 f1 |.9.kqL.. ..&.Y.(.|
03a0 7e b4 50 c7 b4 b3 ba 07-5d 3a 14 91 cc 5a f2 b6 |~.P..... ]:...Z..|
03b0 d4 b2 3c da 91 4d 17 47-65 61 fb a5 aa cd f3 ee |..<..M.G ea......|
03c0 b9 87 1a 74 b7 35 8d ac-f5 5c e2 a7 c5 ec aa 17 |...t.5.. .\......|
03d0 c2 93 7b e9 0e 2d 63 f4-58 2d cb 50 7a 09 26 af |..{..-c. X-.Pz.&.|
03e0 cf be e2 ec 3c 15 26 34-2f 8c 0e 9e f9 c0 35 11 |....<.&4 /.....5.|
03f0 16 3d cc a1 db cc c4 95-c6 34 4d 43 93 5f 00 92 |.=...... .4MC._..|
0400 e4 03 7a 52 ec 07 2a 39-ff a5 50 2f de 34 d1 b3 |..zR..*9 ..P/.4..|
0410 45 d5 d6 40 36 b8 ae dc-ca a5 a9 8c b9 b9 e1 43 |E..@6... .......C|
0420 da d2 b9 f4 d5 65 45 fc-c8 ed f1 a3 95 7b 66 f1 |.....eE. .....{f.|
0430 68 1b 66 fe 5e 25 c9 45-31 cf 5e bc 71 63 df bc |h.f.^%.E 1.^.qc..|
0440 54 d6 09 43 b9 31 27 59-02 ea 3b dd 6d b0 7b 5a |T..C.1'Y ..;.m.{Z|
0450 ca c7 a3 91 5f 63 69 8c-6e 19 f6 74 ef b3 d2 92 |...._ci. n..t....|
0460 6c 7d 5e 0f e7 ab e7 39-04 6f e2 a5 b4 33 8e e2 |l}^....9 .o...3..|
0470 8d 46 a9 a7 8c 9e 4d 13-9e 6d cf f9 78 72 fb c7 |.F....M. .m..xr..|
0480 1d 19 57 90 b8 39 71 90-cb cc cb e0 d6 21 b6 d2 |..W..9q. .....!..|
0490 ec 7c 82 92 af 8a d5 1b-da 28 0e 00 00 00 |.|...... .(....|
tls.c:117:in tds_pull_func_login
tls.c:147:in tds_push_func_login
tls.c:117:in tds_pull_func_login
packet.c:801:Sending packet
0000 12 01 00 65 00 00 00 00-16 03 03 00 25 10 00 00 |...e.... ....%...|
0010 21 20 ca 7e 3c 0c a7 a8-86 f8 63 8d d8 4e c9 01 |! .~<... ..c..N..|
0020 d6 e7 96 d2 e9 09 25 a3-f6 d1 82 fd 3e b3 35 a3 |......%. ....>.5.|
0030 b3 0e 14 03 03 00 01 01-16 03 03 00 28 2b 32 9a |........ ....(+2.|
0040 70 ae 04 30 e4 6b 1b 45-27 81 a9 87 8c 75 de a3 |p..0.k.E '....u..|
0050 59 b1 9e 86 a7 be 21 63-99 c8 5b cc 82 1f 23 c1 |Y.....!c ..[...#.|
0060 e3 b9 a8 0d 4b - |....K|
packet.c:435:Received packet
0000 12 01 00 3b 00 00 00 00-14 03 03 00 01 01 16 03 |...;.... ........|
0010 03 00 28 00 00 00 00 00-00 00 00 b1 86 81 f8 60 |..(..... .......`|
0020 95 35 08 87 07 75 6d 96-2e e9 28 20 68 b5 16 70 |.5...um. ..( h..p|
0030 a3 35 f5 ef 41 7a 1f 3c-a1 3c 8b |.5..Az.< .<.|
tls.c:117:in tds_pull_func_login
tls.c:117:in tds_pull_func_login
tls.c:117:in tds_pull_func_login
tls.c:1048:handshake succeeded!!
login.c:975:quietly sending TDS 7+ login packet
token.c:416:tds_process_login_tokens()
packet.c:435:Received packet
0000 04 01 01 9d 00 35 01 00-e3 1f 00 01 08 6d 00 73 |.....5.. .....m.s|
0010 00 76 00 74 00 65 00 73-00 74 00 31 00 06 6d 00 |.v.t.e.s .t.1..m.|
0020 61 00 73 00 74 00 65 00-72 00 ab 76 00 45 16 00 |a.s.t.e. r..v.E..|
0030 00 02 00 27 00 43 00 68-00 61 00 6e 00 67 00 65 |...'.C.h .a.n.g.e|
0040 00 64 00 20 00 64 00 61-00 74 00 61 00 62 00 61 |.d. .d.a .t.a.b.a|
0050 00 73 00 65 00 20 00 63-00 6f 00 6e 00 74 00 65 |.s.e. .c .o.n.t.e|
0060 00 78 00 74 00 20 00 74-00 6f 00 20 00 27 00 6d |.x.t. .t .o. .'.m|
0070 00 73 00 76 00 74 00 65-00 73 00 74 00 31 00 27 |.s.v.t.e .s.t.1.'|
0080 00 2e 00 0d 49 00 44 00-41 00 5c 00 53 00 51 00 |....I.D. A.\.S.Q.|
0090 4c 00 53 00 52 00 56 00-30 00 30 00 33 00 00 01 |L.S.R.V. 0.0.3...|
00a0 00 00 00 e3 08 00 07 05-09 04 d0 24 00 00 e3 17 |........ ...$....|
00b0 00 02 0a 75 00 73 00 5f-00 65 00 6e 00 67 00 6c |...u.s._ .e.n.g.l|
00c0 00 69 00 73 00 68 00 00-ab 76 00 47 16 00 00 01 |.i.s.h.. .v.G....|
00d0 00 27 00 43 00 68 00 61-00 6e 00 67 00 65 00 64 |.'.C.h.a .n.g.e.d|
00e0 00 20 00 6c 00 61 00 6e-00 67 00 75 00 61 00 67 |. .l.a.n .g.u.a.g|
00f0 00 65 00 20 00 73 00 65-00 74 00 74 00 69 00 6e |.e. .s.e .t.t.i.n|
0100 00 67 00 20 00 74 00 6f-00 20 00 75 00 73 00 5f |.g. .t.o . .u.s._|
0110 00 65 00 6e 00 67 00 6c-00 69 00 73 00 68 00 2e |.e.n.g.l .i.s.h..|
0120 00 0d 49 00 44 00 41 00-5c 00 53 00 51 00 4c 00 |..I.D.A. \.S.Q.L.|
0130 53 00 52 00 56 00 30 00-30 00 33 00 00 01 00 00 |S.R.V.0. 0.3.....|
0140 00 ad 36 00 01 73 0b 00-03 16 4d 00 69 00 63 00 |..6..s.. ..M.i.c.|
0150 72 00 6f 00 73 00 6f 00-66 00 74 00 20 00 53 00 |r.o.s.o. f.t. .S.|
0160 51 00 4c 00 20 00 53 00-65 00 72 00 76 00 65 00 |Q.L. .S. e.r.v.e.|
0170 72 00 00 00 00 00 0f 00-04 b0 e3 13 00 04 04 34 |r....... .......4|
0180 00 30 00 39 00 36 00 04-34 00 30 00 39 00 36 00 |.0.9.6.. 4.0.9.6.|
0190 fd 00 00 00 00 00 00 00-00 00 00 00 00 |........ .....|
token.c:420:looking for login token, got e3(ENVCHANGE)
token.c:129:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:420:looking for login token, got ab(INFO)
token.c:129:tds_process_default_tokens() marker is ab(INFO)
mem.c:656:tds_free_all_results()
token.c:2398:tds_process_info() reading message 5701 from server
token.c:2493:tds_process_info() calling client msg handler
odbc.c:2367:msgno 5701 20003
token.c:2510:tds_process_info() returning TDS_SUCCESS
token.c:420:looking for login token, got e3(ENVCHANGE)
token.c:129:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2225:tds_process_env_chg(): 5 bytes of collation data received
token.c:2226:tds->conn->collation was
0000 00 00 00 00 00 - |.....|
iconv.c:785:setting server single-byte charset to "CP1252"
token.c:2236:tds->conn->collation now
0000 09 04 d0 24 00 - |...$.|
token.c:420:looking for login token, got e3(ENVCHANGE)
token.c:129:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:420:looking for login token, got ab(INFO)
token.c:129:tds_process_default_tokens() marker is ab(INFO)
mem.c:656:tds_free_all_results()
token.c:2398:tds_process_info() reading message 5703 from server
token.c:2493:tds_process_info() calling client msg handler
odbc.c:2367:msgno 5703 20003
token.c:2510:tds_process_info() returning TDS_SUCCESS
token.c:420:looking for login token, got ad(LOGINACK)
token.c:346:server reports TDS version 73.b.0.3
token.c:348:Product name for 0x730b0003 is 2008
token.c:382:Product version 8F0004B0
token.c:420:looking for login token, got e3(ENVCHANGE)
token.c:129:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2285:changing block size from 4096 to 4096
token.c:420:looking for login token, got fd(DONE)
token.c:129:tds_process_default_tokens() marker is fd(DONE)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
token.c:443:tds_process_login_tokens() returning TDS_SUCCESS
odbc.c:1529:SQLAllocHandle(3, 0x619000000580, 0x7fff0ab9fb70)
odbc.c:1704:_SQLAllocStmt(0x619000000580, 0x7fff0ab9fb70)
odbc_export.h:815:SQLExecDirect(0x613000000740, SELECT SERVERPROPERTY('ProductVersion'), -3)
prepare_query.c:202:parsing 0 parameters
odbc.c:3273:_SQLExecute(0x613000000740)
odbc.c:3290:_SQLExecute() starting with state 0
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
packet.c:801:Sending packet
0000 01 01 00 6c 00 00 01 00-16 00 00 00 12 00 00 00 |...l.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 53 00 |........ ......S.|
0020 45 00 4c 00 45 00 43 00-54 00 20 00 53 00 45 00 |E.L.E.C. T. .S.E.|
0030 52 00 56 00 45 00 52 00-50 00 52 00 4f 00 50 00 |R.V.E.R. P.R.O.P.|
0040 45 00 52 00 54 00 59 00-28 00 27 00 50 00 72 00 |E.R.T.Y. (.'.P.r.|
0050 6f 00 64 00 75 00 63 00-74 00 56 00 65 00 72 00 |o.d.u.c. t.V.e.r.|
0060 73 00 69 00 6f 00 6e 00-27 00 29 00 |s.i.o.n. '.).|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0ab9f978, 0x7fff0ab9f97c, 0x6914)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 4a 00 35 01 00-81 01 00 00 00 00 00 21 |...J.5.. .......!|
0010 00 62 49 1f 00 00 00 d1-21 00 00 00 e7 07 09 04 |.bI..... !.......|
0020 d0 00 34 00 01 31 00 35-00 2e 00 30 00 2e 00 31 |..4..1.5 ...0...1|
0030 00 32 00 30 00 30 00 2e-00 32 00 34 00 fd 10 00 |.2.0.0.. .2.4....|
0040 c1 00 01 00 00 00 00 00-00 00 |........ ..|
token.c:568:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1572:processing TDS7 result metadata.
mem.c:656:tds_free_all_results()
token.c:1597:set current_results (1 column) to tds->res_info
token.c:1604:setting up 1 columns
token.c:1541:tds7_get_data_info:
colname =
type = 98 (variant)
server's type = 98 (variant)
column_varint_size = 4
column_size = 8009 (8009 on server)
token.c:1613: name size/wsize type/wtype utype
token.c:1614: -------------------- --------------- --------------- -------
token.c:1619: 8009/8009 98/98 0
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4049, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3687:odbc_process_tokens: returning result_type 4049
odbc.c:3436:_SQLExecute: odbc_process_tokens returned result_type 4049
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0ab9f978, 0x7fff0ab9f97c, 0x6914)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is d1(ROW)
token.c:674:tds_process_tokens::SET_RETURN stopping on current token
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3687:odbc_process_tokens: returning result_type 4040
odbc.c:3436:_SQLExecute: odbc_process_tokens returned result_type 4040
odbc.c:1824:SQLBindCol(0x613000000740, 1, 1, 0x7fff0ab9fbf0, 100, 0x7fff0ab9fbb0)
odbc.c:4018:SQLFetch(0x613000000740)
odbc.c:3752:_SQLFetch(0x613000000740, 1, 0)
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0ab9f988, 0x7fff0ab9f98c, 0x6508)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is d1(ROW)
token.c:1949:tds_process_row(): reading column 0
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3687:odbc_process_tokens: returning result_type 4040
convert_tds2sql.c:292:odbc_tds2sql: src is 231 dest = 1
odbc.c:4268:SQLCloseCursor(0x613000000740)
odbc.c:4166:_SQLFreeStmt(0x613000000740, 0, 0)
query.c:2128:tds_send_cancel: not in_cancel and not idle
query.c:2174:tds_send_cancel: sending cancel packet
packet.c:801:Sending packet
0000 06 01 00 08 00 00 01 00- |........|
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0ab9fa3c, (nil), 0x0)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is fd(DONE)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2113: rows_affected = 1
packet.c:435:Received packet
0000 04 01 00 15 00 35 01 00-fd 20 00 fd 00 00 00 00 |.....5.. . ......|
0010 00 00 00 00 00 - |.....|
token.c:568:processing result tokens. marker is fd(DONE)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 1
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
odbc.c:4063:SQLFreeHandle(3, 0x613000000740)
odbc.c:4166:_SQLFreeStmt(0x613000000740, 1, 0)
odbc.c:1529:SQLAllocHandle(3, 0x619000000580, 0x611000013180)
odbc.c:1704:_SQLAllocStmt(0x619000000580, 0x611000013180)
odbc_export.h:815:SQLExecDirect(0x613000000900, DROP TABLE mytab2, -3)
prepare_query.c:202:parsing 0 parameters
odbc.c:3273:_SQLExecute(0x613000000900)
odbc.c:3290:_SQLExecute() starting with state 0
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
packet.c:801:Sending packet
0000 01 01 00 40 00 00 01 00-16 00 00 00 12 00 00 00 |...@.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 44 00 |........ ......D.|
0020 52 00 4f 00 50 00 20 00-54 00 41 00 42 00 4c 00 |R.O.P. . T.A.B.L.|
0030 45 00 20 00 6d 00 79 00-74 00 61 00 62 00 32 00 |E. .m.y. t.a.b.2.|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0aba11f8, 0x7fff0aba11fc, 0x6914)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 15 00 35 01 00-fd 00 00 c7 00 00 00 00 |.....5.. ........|
0010 00 00 00 00 00 - |.....|
token.c:568:processing result tokens. marker is fd(DONE)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3660:odbc_process_tokens: processed TDS_DONE_RESULT
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0aba11f8, 0x7fff0aba11fc, 0x26914)
token.c:556:tds_process_tokens() state is COMPLETED
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3615: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3436:_SQLExecute: odbc_process_tokens returned result_type 4046
odbc.c:4612:_SQLRowCount(0x613000000900, 0x7fff0aba12c0), -1 rows
odbc.c:4623:SQLRowCount returns 0, row count -1
odbc.c:891:SQLMoreResults(0x613000000900)
odbc.c:4063:SQLFreeHandle(3, 0x613000000900)
odbc.c:4166:_SQLFreeStmt(0x613000000900, 1, 0)
odbc.c:1529:SQLAllocHandle(3, 0x619000000580, 0x611000013180)
odbc.c:1704:_SQLAllocStmt(0x619000000580, 0x611000013180)
odbc_export.h:815:SQLExecDirect(0x613000000ac0, CREATE TABLE mytab2 ( col1 char(10) COLLATE Latin1_General_CI_AS ), -3)
prepare_query.c:202:parsing 0 parameters
odbc.c:3273:_SQLExecute(0x613000000ac0)
odbc.c:3290:_SQLExecute() starting with state 0
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
packet.c:801:Sending packet
0000 01 01 00 a2 00 00 01 00-16 00 00 00 12 00 00 00 |........ ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 43 00 |........ ......C.|
0020 52 00 45 00 41 00 54 00-45 00 20 00 54 00 41 00 |R.E.A.T. E. .T.A.|
0030 42 00 4c 00 45 00 20 00-6d 00 79 00 74 00 61 00 |B.L.E. . m.y.t.a.|
0040 62 00 32 00 20 00 28 00-20 00 63 00 6f 00 6c 00 |b.2. .(. .c.o.l.|
0050 31 00 20 00 63 00 68 00-61 00 72 00 28 00 31 00 |1. .c.h. a.r.(.1.|
0060 30 00 29 00 20 00 43 00-4f 00 4c 00 4c 00 41 00 |0.). .C. O.L.L.A.|
0070 54 00 45 00 20 00 4c 00-61 00 74 00 69 00 6e 00 |T.E. .L. a.t.i.n.|
0080 31 00 5f 00 47 00 65 00-6e 00 65 00 72 00 61 00 |1._.G.e. n.e.r.a.|
0090 6c 00 5f 00 43 00 49 00-5f 00 41 00 53 00 20 00 |l._.C.I. _.A.S. .|
00a0 29 00 - |).|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0aba11f8, 0x7fff0aba11fc, 0x6914)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 15 00 35 01 00-fd 00 00 c6 00 00 00 00 |.....5.. ........|
0010 00 00 00 00 00 - |.....|
token.c:568:processing result tokens. marker is fd(DONE)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3660:odbc_process_tokens: processed TDS_DONE_RESULT
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0aba11f8, 0x7fff0aba11fc, 0x26914)
token.c:556:tds_process_tokens() state is COMPLETED
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3615: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3436:_SQLExecute: odbc_process_tokens returned result_type 4046
odbc.c:4612:_SQLRowCount(0x613000000ac0, 0x7fff0aba12c0), -1 rows
odbc.c:4623:SQLRowCount returns 0, row count -1
odbc.c:891:SQLMoreResults(0x613000000ac0)
odbc.c:4063:SQLFreeHandle(3, 0x613000000ac0)
odbc.c:4166:_SQLFreeStmt(0x613000000ac0, 1, 0)
odbc.c:1529:SQLAllocHandle(3, 0x619000000580, 0x611000013180)
odbc.c:1704:_SQLAllocStmt(0x619000000580, 0x611000013180)
odbc_export.h:815:SQLExecDirect(0x613000000c80, insert into mytab2 VALUES (N'abc'); select @@rowcount, scope_identity(), -3)
prepare_query.c:202:parsing 0 parameters
odbc.c:3273:_SQLExecute(0x613000000c80)
odbc.c:3290:_SQLExecute() starting with state 0
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
packet.c:801:Sending packet
0000 01 01 00 ac 00 00 01 00-16 00 00 00 12 00 00 00 |........ ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 69 00 |........ ......i.|
0020 6e 00 73 00 65 00 72 00-74 00 20 00 69 00 6e 00 |n.s.e.r. t. .i.n.|
0030 74 00 6f 00 20 00 6d 00-79 00 74 00 61 00 62 00 |t.o. .m. y.t.a.b.|
0040 32 00 20 00 56 00 41 00-4c 00 55 00 45 00 53 00 |2. .V.A. L.U.E.S.|
0050 20 00 28 00 4e 00 27 00-61 00 62 00 63 00 27 00 | .(.N.'. a.b.c.'.|
0060 29 00 3b 00 20 00 73 00-65 00 6c 00 65 00 63 00 |).;. .s. e.l.e.c.|
0070 74 00 20 00 40 00 40 00-72 00 6f 00 77 00 63 00 |t. .@.@. r.o.w.c.|
0080 6f 00 75 00 6e 00 74 00-2c 00 20 00 73 00 63 00 |o.u.n.t. ,. .s.c.|
0090 6f 00 70 00 65 00 5f 00-69 00 64 00 65 00 6e 00 |o.p.e._. i.d.e.n.|
00a0 74 00 69 00 74 00 79 00-28 00 29 00 |t.i.t.y. (.).|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0aba11b8, 0x7fff0aba11bc, 0x6914)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 3e 00 35 01 00-fd 11 00 c3 00 01 00 00 |...>.5.. ........|
0010 00 00 00 00 00 81 02 00-00 00 00 00 20 00 38 00 |........ .... .8.|
0020 00 00 00 00 21 00 6c 11-26 00 00 d1 01 00 00 00 |....!.l. &.......|
0030 00 fd 10 00 c1 00 01 00-00 00 00 00 00 00 |........ ......|
token.c:568:processing result tokens. marker is fd(DONE)
token.c:2094:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2113: rows_affected = 1
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4052, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3657:odbc_process_tokens: row_count=1
odbc.c:3436:_SQLExecute: odbc_process_tokens returned result_type 4052
odbc.c:1824:SQLBindCol(0x613000000c80, 1, 4, 0x7fff0aba1180, 4, 0x7fff0aba11c0)
odbc.c:1824:SQLBindCol(0x613000000c80, 2, -25, 0x7fff0aba1200, 8, 0x7fff0aba1240)
odbc.c:4018:SQLFetch(0x613000000c80)
odbc.c:3752:_SQLFetch(0x613000000c80, 1, 0)
error.c:414:odbc_errs_add: "Invalid cursor state"
odbc.c:891:SQLMoreResults(0x613000000c80)
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0aba1098, 0x7fff0aba109c, 0x15914)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1572:processing TDS7 result metadata.
mem.c:656:tds_free_all_results()
token.c:1597:set current_results (2 columns) to tds->res_info
token.c:1604:setting up 2 columns
token.c:1541:tds7_get_data_info:
colname =
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1541:tds7_get_data_info:
colname =
type = 108 (numeric)
server's type = 108 (numeric)
column_varint_size = 1
column_size = 17 (17 on server)
token.c:1613: name size/wsize type/wtype utype
token.c:1614: -------------------- --------------- --------------- -------
token.c:1619: 4/4 56/56 0
token.c:1619: 17/17 108/108 0
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4049, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3687:odbc_process_tokens: returning result_type 4049
odbc.c:917:SQLMoreResults: result_type=4049, row_count=-1, lastrc=0
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0aba1098, 0x7fff0aba109c, 0x15914)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is d1(ROW)
token.c:674:tds_process_tokens::SET_RETURN stopping on current token
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3687:odbc_process_tokens: returning result_type 4040
odbc.c:917:SQLMoreResults: result_type=4040, row_count=-1, lastrc=0
odbc.c:4018:SQLFetch(0x613000000c80)
odbc.c:3752:_SQLFetch(0x613000000c80, 1, 0)
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0aba1018, 0x7fff0aba101c, 0x6508)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is d1(ROW)
token.c:1949:tds_process_row(): reading column 0
data.c:717:tds_get_data: type 56, varint size 0
data.c:761:tds_get_data(): wire column size is 4
token.c:1949:tds_process_row(): reading column 1
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3687:odbc_process_tokens: returning result_type 4040
convert_tds2sql.c:292:odbc_tds2sql: src is 56 dest = 4
odbc.c:4268:SQLCloseCursor(0x613000000c80)
odbc.c:4166:_SQLFreeStmt(0x613000000c80, 0, 0)
query.c:2128:tds_send_cancel: not in_cancel and not idle
query.c:2174:tds_send_cancel: sending cancel packet
packet.c:801:Sending packet
0000 06 01 00 08 00 00 01 00- |........|
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0aba10cc, (nil), 0x0)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is fd(DONE)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2113: rows_affected = 1
packet.c:435:Received packet
0000 04 01 00 15 00 35 01 00-fd 20 00 fd 00 00 00 00 |.....5.. . ......|
0010 00 00 00 00 00 - |.....|
token.c:568:processing result tokens. marker is fd(DONE)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 1
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
odbc.c:891:SQLMoreResults(0x613000000c80)
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0aba1218, 0x7fff0aba121c, 0x15914)
token.c:556:tds_process_tokens() state is COMPLETED
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3615: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:917:SQLMoreResults: result_type=4046, row_count=-1, lastrc=0
mem.c:656:tds_free_all_results()
odbc.c:928:SQLMoreResults: row_status=0
odbc.c:930:SQLMoreResults: row_count=-1, lastrc=0
odbc.c:1529:SQLAllocHandle(3, 0x619000000580, 0x611000013540)
odbc.c:1704:_SQLAllocStmt(0x619000000580, 0x611000013540)
odbc.c:4063:SQLFreeHandle(3, 0x613000000e40)
odbc.c:4166:_SQLFreeStmt(0x613000000e40, 1, 0)
odbc.c:1529:SQLAllocHandle(3, 0x619000000580, 0x611000013540)
odbc.c:1704:_SQLAllocStmt(0x619000000580, 0x611000013540)
odbc.c:6720:SQLSetStmtAttr(0x613000001000, -1, (nil), -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000001000, -1, (nil), -5)
odbc.c:6720:SQLSetStmtAttr(0x613000001000, -2, 0x1, -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000001000, -2, 0x1, -5)
odbc_export.h:815:SQLExecDirect(0x613000001000, select col1 from mytab2, -3)
prepare_query.c:202:parsing 0 parameters
odbc.c:3273:_SQLExecute(0x613000001000)
odbc.c:3290:_SQLExecute() starting with state 0
query.c:2338:tds_cursor_declare() cursor id = 0
query.c:2385:tds_cursor_open() cursor id = 0
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
query.c:2512:tds_cursor_open (): RPC call set up
query.c:2516:tds_cursor_open (): cursor open completed
packet.c:801:Sending packet
0000 03 01 00 86 00 00 01 00-16 00 00 00 12 00 00 00 |........ ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........|
0020 02 00 00 00 00 01 26 04-00 00 00 63 32 00 00 00 |......&. ...c2...|
0030 09 04 d0 24 00 32 00 00-00 73 00 65 00 6c 00 65 |...$.2.. .s.e.l.e|
0040 00 63 00 74 00 20 00 63-00 6f 00 6c 00 31 00 20 |.c.t. .c .o.l.1. |
0050 00 66 00 72 00 6f 00 6d-00 20 00 20 00 20 00 6d |.f.r.o.m . . . .m|
0060 00 79 00 74 00 61 00 62-00 32 00 00 01 26 04 04 |.y.t.a.b .2...&..|
0070 08 00 00 00 00 01 26 04-04 01 20 00 00 00 01 26 |......&. .. ....&|
0080 04 04 00 00 00 00 - |......|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0aba11e8, 0x7fff0aba11ec, 0x6900)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 ba 00 35 01 00-81 02 00 00 00 00 00 09 |.....5.. ........|
0010 00 af 0a 00 09 04 d0 00-00 04 63 00 6f 00 6c 00 |........ ..c.o.l.|
0020 31 00 00 00 00 00 00 00-38 07 52 00 4f 00 57 00 |1....... 8.R.O.W.|
0030 53 00 54 00 41 00 54 00-a4 0f 00 01 06 00 6d 00 |S.T.A.T. ......m.|
0040 79 00 74 00 61 00 62 00-32 00 a5 06 00 01 01 00 |y.t.a.b. 2.......|
0050 02 00 14 ff 11 00 c1 00-00 00 00 00 00 00 00 00 |........ ........|
0060 79 00 00 00 00 ac 00 00-00 01 00 00 00 00 00 00 |y....... ........|
0070 26 04 04 f3 de bc 0a ac-02 00 00 01 00 00 00 00 |&....... ........|
0080 00 00 26 04 04 08 00 00-00 ac 03 00 00 01 00 00 |..&..... ........|
0090 00 00 00 00 26 04 04 01-00 00 00 ac 04 00 00 01 |....&... ........|
00a0 00 00 00 00 00 00 26 04-04 01 00 00 00 fe 00 00 |......&. ........|
00b0 e0 00 00 00 00 00 00 00-00 00 |........ ..|
token.c:568:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1572:processing TDS7 result metadata.
mem.c:656:tds_free_all_results()
token.c:1594:set current_results to cursor->res_info
token.c:1604:setting up 2 columns
token.c:1541:tds7_get_data_info:
colname = col1
type = 47 (char)
server's type = 175 (xchar)
column_varint_size = 2
column_size = 10 (10 on server)
token.c:1541:tds7_get_data_info:
colname = ROWSTAT
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1613: name size/wsize type/wtype utype
token.c:1614: -------------------- --------------- --------------- -------
token.c:1619: col1 10/10 47/175 0
token.c:1619: ROWSTAT 4/4 56/56 0
token.c:568:processing result tokens. marker is ff(DONEINPROC)
token.c:2094:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2113: rows_affected = 0
token.c:568:processing result tokens. marker is 79(RETURNSTATUS)
token.c:568:processing result tokens. marker is ac(PARAM)
token.c:617:processing parameters for op 2
token.c:619:calling tds_process_param_result
token.c:1303:tds_process_param_result(0x6120000007c0, 0x7fff0aba1168)
token.c:1645:tds_get_data_info(0x6120000007c0, 0x610000000d40, 1) [for parameter]
token.c:1707:processing result. type = 38(integer-null), varint_size 1
token.c:1712:processing result. column_size 4
data.c:717:tds_get_data: type 38, varint size 1
data.c:761:tds_get_data(): wire column size is 4
log.c:443:type integer-null has value 180150003
token.c:619:calling tds_process_param_result
token.c:1303:tds_process_param_result(0x6120000007c0, 0x7fff0aba1168)
token.c:1645:tds_get_data_info(0x6120000007c0, 0x610000000e40, 1) [for parameter]
token.c:1707:processing result. type = 38(integer-null), varint_size 1
token.c:1712:processing result. column_size 4
data.c:717:tds_get_data: type 38, varint size 1
data.c:761:tds_get_data(): wire column size is 4
log.c:443:type integer-null has value 8
token.c:619:calling tds_process_param_result
token.c:1303:tds_process_param_result(0x6120000007c0, 0x7fff0aba1168)
token.c:1645:tds_get_data_info(0x6120000007c0, 0x610000000f40, 1) [for parameter]
token.c:1707:processing result. type = 38(integer-null), varint_size 1
token.c:1712:processing result. column_size 4
data.c:717:tds_get_data: type 38, varint size 1
data.c:761:tds_get_data(): wire column size is 4
log.c:443:type integer-null has value 1
token.c:619:calling tds_process_param_result
token.c:1303:tds_process_param_result(0x6120000007c0, 0x7fff0aba1168)
token.c:1645:tds_get_data_info(0x6120000007c0, 0x610000001040, 1) [for parameter]
token.c:1707:processing result. type = 38(integer-null), varint_size 1
token.c:1712:processing result. column_size 4
data.c:717:tds_get_data: type 38, varint size 1
data.c:761:tds_get_data(): wire column size is 4
log.c:443:type integer-null has value 1
token.c:625:4 hidden return parameters
token.c:632:stored internal cursor id 180150003
token.c:568:processing result tokens. marker is fe(DONEPROC)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3660:odbc_process_tokens: processed TDS_DONE_RESULT
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0aba11e8, 0x7fff0aba11ec, 0x26900)
token.c:556:tds_process_tokens() state is COMPLETED
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3615: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
query.c:2885:tds_cursor_setname() cursor id = 180150003
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
packet.c:801:Sending packet
0000 03 01 00 55 00 00 01 00-16 00 00 00 12 00 00 00 |...U.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........|
0020 08 00 00 00 00 00 26 04-04 f3 de bc 0a 00 00 26 |......&. .......&|
0030 04 04 02 00 00 00 00 00-a7 13 00 09 04 d0 24 00 |........ ......$.|
0040 13 00 53 51 4c 5f 43 55-52 36 31 33 30 30 30 30 |..SQL_CU R6130000|
0050 30 31 30 30 30 - |01000|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0aba11e8, 0x7fff0aba11ec, 0x6914)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 1a 00 35 01 00-79 00 00 00 00 fe 00 00 |.....5.. y.......|
0010 e0 00 00 00 00 00 00 00-00 00 |........ ..|
token.c:568:processing result tokens. marker is 79(RETURNSTATUS)
token.c:568:processing result tokens. marker is fe(DONEPROC)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3615: result_type=1, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3436:_SQLExecute: odbc_process_tokens returned result_type 4046
odbc.c:4531:SQLNumResultCols(0x613000001000, 0x7fff0aba1300)
odbc_export.h:556:SQLDescribeCol(0x613000001000, 1, (nil), 0, 0x7fff0aba11d0, 0x7fff0aba1210, 0x7fff0aba12d0, 0x7fff0aba1250, 0x7fff0aba1290)
odbc.c:6720:SQLSetStmtAttr(0x613000001000, 5, (nil), -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000001000, 5, (nil), -5)
odbc.c:6720:SQLSetStmtAttr(0x613000001000, 27, 0xa, -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000001000, 27, 0xa, -5)
odbc.c:6720:SQLSetStmtAttr(0x613000001000, 26, 0x611000013588, -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000001000, 26, 0x611000013588, -5)
odbc_export.h:556:SQLDescribeCol(0x613000001000, 1, (nil), 0, 0x7fff0aba1210, 0x606000006d58, 0x7fff0aba12d0, 0x7fff0aba1250, 0x7fff0aba1290)
odbc.c:1824:SQLBindCol(0x613000001000, 1, 1, 0x6120000010c0, 31, 0x607000004cb0)
odbc.c:4268:SQLCloseCursor(0x613000001000)
odbc.c:4166:_SQLFreeStmt(0x613000001000, 0, 0)
query.c:2824:tds_cursor_close() cursor id = 180150003
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
packet.c:801:Sending packet
0000 03 01 00 2d 00 00 01 00-16 00 00 00 12 00 00 00 |...-.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........|
0020 09 00 02 00 00 00 26 04-04 f3 de bc 0a |......&. .....|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7fff0aba1298, 0x7fff0aba129c, 0x100)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 1a 00 35 01 00-79 00 00 00 00 fe 00 00 |.....5.. y.......|
0010 e0 00 00 00 00 00 00 00-00 00 |........ ..|
token.c:568:processing result tokens. marker is 79(RETURNSTATUS)
token.c:568:processing result tokens. marker is fe(DONEPROC)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
token.c:772:TDS_OP_CURSORCLOSE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
mem.c:918:tds_cursor_deallocated() : freeing cursor_id 180150003
odbc.c:4063:SQLFreeHandle(3, 0x613000001000)
odbc.c:4166:_SQLFreeStmt(0x613000001000, 1, 0)
odbc.c:4063:SQLFreeHandle(3, 0x613000000c80)
odbc.c:4166:_SQLFreeStmt(0x613000000c80, 1, 0)
odbc.c:2332:SQLDisconnect(0x619000000580)
query.c:3783:tds_disconnect()
util.c:165:Changed query state from IDLE to DEAD
mem.c:949:tds_release_cursor() : freeing cursor_id 180150003
mem.c:951:tds_release_cursor() : freeing cursor results
mem.c:956:tds_release_cursor() : freeing cursor name
mem.c:961:tds_release_cursor() : freeing cursor query
mem.c:965:tds_release_cursor() : cursor_id 180150003 freed
mem.c:656:tds_free_all_results()
odbc.c:4063:SQLFreeHandle(2, 0x619000000580)
odbc.c:4089:_SQLFreeConnect(0x619000000580)
bcp.c:673:_bcp_free_storage(0x619000000580)
log.c:168:Starting log file for FreeTDS 1.1rc3
on 2019-02-21 14:47:41 with debug flags 0x4fff.
iconv.c:326:tds_iconv_open(0x612000000640, UTF-8)
iconv.c:186:local name for ISO-8859-1 is ISO-8859-1
iconv.c:186:local name for UTF-8 is UTF-8
iconv.c:186:local name for UCS-2LE is UCS-2LE
iconv.c:186:local name for UCS-2BE is UCS-2BE
iconv.c:348:setting up conversions for client charset "UTF-8"
iconv.c:350:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:389:tds_iconv_open: done
net.c:391:Connecting with protocol version 7.3
net.c:318:Connecting to 10.0.40.27 port 1684
net.c:340:tds_setup_socket: connect(2) returned "Operation now in progress"
net.c:528:tds_open_socket() succeeded
packet.c:801: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 fb 0f 00-00 00 |rver.... ..|
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 0f 00 04 b0 00 00-00 00 00 |........ ...|
login.c:1253:detected flag 0
tls.c:1012: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:801:Sending packet
0000 12 01 00 ca 00 00 00 00-16 03 01 00 bd 01 00 00 |........ ........|
0010 b9 03 03 cb c9 62 b9 21-42 86 9f 25 be 3d df 42 |.....b.! B..%.=.B|
0020 d3 a5 38 de 5b e9 e7 58-5c cc ab d4 35 33 11 0e |..8.[..X \...53..|
0030 f8 11 37 00 00 4a c0 2c-c0 30 cc a9 cc a8 c0 af |..7..J., .0......|
0040 c0 ad c0 2b c0 2f c0 ae-c0 ac c0 24 c0 28 c0 73 |...+./.. ...$.(.s|
0050 c0 77 c0 23 c0 27 c0 72-c0 76 c0 0a c0 14 c0 09 |.w.#.'.r .v......|
0060 c0 13 00 9d c0 a1 c0 9d-00 9c c0 a0 c0 9c 00 3d |........ .......=|
0070 00 c0 00 3c 00 ba 00 35-00 84 00 2f 00 41 00 ff |...<...5 .../.A..|
0080 01 00 00 46 00 0b 00 04-03 00 01 02 00 0a 00 0a |...F.... ........|
0090 00 08 00 1d 00 17 00 19-00 18 00 23 00 00 00 16 |........ ...#....|
00a0 00 00 00 17 00 00 00 0d-00 20 00 1e 06 01 06 02 |........ . ......|
00b0 06 03 05 01 05 02 05 03-04 01 04 02 04 03 03 01 |........ ........|
00c0 03 02 03 03 02 01 02 02-02 03 |........ ..|
packet.c:435:Received packet
0000 12 01 04 9e 00 00 00 00-16 03 03 04 91 02 00 00 |........ ........|
0010 51 03 03 5c 6e ab fd e8-b8 9d ab 8b 23 ac 31 76 |Q..\n... ....#.1v|
0020 b5 df b6 97 d9 bd 36 14-7e d9 ac c0 d4 da 4f 98 |......6. ~.....O.|
0030 88 e1 25 20 5c 15 00 00-06 d4 bd 58 1f 56 65 78 |..% \... ...X.Vex|
0040 c4 e5 59 12 2a d1 9f 06-31 41 cf a9 ad 1c 8b 7d |..Y.*... 1A.....}|
0050 7f 64 de 9e c0 30 00 00-09 00 17 00 00 ff 01 00 |.d...0.. ........|
0060 01 00 0b 00 03 08 00 03-05 00 03 02 30 82 02 fe |........ ....0...|
0070 30 82 01 e6 a0 03 02 01-02 02 10 28 7e 47 1f 3d |0....... ...(~G.=|
0080 bb 23 be 4b b2 dc 3c fd-45 27 ed 30 0d 06 09 2a |.#.K..<. E'.0...*|
0090 86 48 86 f7 0d 01 01 0b-05 00 30 3b 31 39 30 37 |.H...... ..0;1907|
00a0 06 03 55 04 03 1e 30 00-53 00 53 00 4c 00 5f 00 |..U...0. S.S.L._.|
00b0 53 00 65 00 6c 00 66 00-5f 00 53 00 69 00 67 00 |S.e.l.f. _.S.i.g.|
00c0 6e 00 65 00 64 00 5f 00-46 00 61 00 6c 00 6c 00 |n.e.d._. F.a.l.l.|
00d0 62 00 61 00 63 00 6b 30-1e 17 0d 31 39 30 32 31 |b.a.c.k0 ...19021|
00e0 39 31 37 35 33 31 30 5a-17 0d 34 39 30 32 31 39 |9175310Z ..490219|
00f0 31 37 35 33 31 30 5a 30-3b 31 39 30 37 06 03 55 |175310Z0 ;1907..U|
0100 04 03 1e 30 00 53 00 53-00 4c 00 5f 00 53 00 65 |...0.S.S .L._.S.e|
0110 00 6c 00 66 00 5f 00 53-00 69 00 67 00 6e 00 65 |.l.f._.S .i.g.n.e|
0120 00 64 00 5f 00 46 00 61-00 6c 00 6c 00 62 00 61 |.d._.F.a .l.l.b.a|
0130 00 63 00 6b 30 82 01 22-30 0d 06 09 2a 86 48 86 |.c.k0.." 0...*.H.|
0140 f7 0d 01 01 01 05 00 03-82 01 0f 00 30 82 01 0a |........ ....0...|
0150 02 82 01 01 00 bb 71 e5-83 fc bc 85 d4 5a 5d ed |......q. .....Z].|
0160 f8 d5 7b ad 87 f9 86 8e-25 fc d4 05 c3 a2 9f 05 |..{..... %.......|
0170 be b9 6d a8 6e a3 70 a8-60 50 7a 5b e1 e5 19 01 |..m.n.p. `Pz[....|
0180 7b 87 8f f2 ab bb da f7-04 99 a5 d3 be 5a 10 b0 |{....... .....Z..|
0190 cc 77 77 b5 ff 81 36 e9-55 ad cf cd 83 e2 39 3e |.ww...6. U.....9>|
01a0 15 54 4a 30 ff d9 ee 7e-f0 25 32 c3 e9 97 76 02 |.TJ0...~ .%2...v.|
01b0 e4 21 22 b9 ba c8 31 4d-dc b5 88 c7 7c 67 90 da |.!"...1M ....|g..|
01c0 f9 9d dd 7f 6e 97 23 de-5a 80 f7 23 92 9c d4 23 |....n.#. Z..#...#|
01d0 4f 6e a5 17 87 66 3a 2c-0b 99 dd d4 28 5a 25 d9 |On...f:, ....(Z%.|
01e0 f7 3a fb 6d 1a 97 9a a1-04 3f 2c 74 20 52 d3 a3 |.:.m.... .?,t R..|
01f0 01 00 24 f2 85 1d bd d0-82 7d 35 db 06 87 83 25 |..$..... .}5....%|
0200 ba e0 b8 94 74 a3 3e e4-aa ea 19 10 e0 30 04 1c |....t.>. .....0..|
0210 60 81 9d 84 bc 39 00 1a-d0 e6 2a 14 34 71 e7 d5 |`....9.. ..*.4q..|
0220 49 27 e1 f2 cd 43 e5 44-97 48 0c 87 55 1c 18 f2 |I'...C.D .H..U...|
0230 5d 08 db 55 85 6a 21 83-35 a8 29 b6 6a 70 52 32 |]..U.j!. 5.).jpR2|
0240 06 0b 49 da c7 80 9d d8-90 f8 0d 69 ac eb 02 27 |..I..... ...i...'|
0250 7b 8d 56 f0 85 02 03 01-00 01 30 0d 06 09 2a 86 |{.V..... ..0...*.|
0260 48 86 f7 0d 01 01 0b 05-00 03 82 01 01 00 88 8a |H....... ........|
0270 a1 b7 dc ea fc dc 5f db-53 da 9a 4b 8a 12 55 81 |......_. S..K..U.|
0280 83 12 62 c1 fc 5c 91 b5-eb 9a 06 58 5d 70 f1 af |..b..\.. ...X]p..|
0290 aa 35 c0 1c 84 c0 ae 91-5c cb 95 ed 6b 2c 92 64 |.5...... \...k,.d|
02a0 c7 c4 32 cc 13 64 42 90-2a aa 19 a4 a7 92 46 c3 |..2..dB. *.....F.|
02b0 e5 6a 1f 94 a8 97 f8 87-6f ce 1b d8 b6 b6 dd 84 |.j...... o.......|
02c0 ed 03 cd 69 03 3b 9b 8f-c2 40 9b a0 37 3c b5 68 |...i.;.. .@..7<.h|
02d0 56 03 4a dc fb 28 79 4c-3b 28 da fe 03 3c 07 03 |V.J..(yL ;(...<..|
02e0 3d ad a4 5a 7a 36 2f 49-d6 eb 01 41 27 c5 94 62 |=..Zz6/I ...A'..b|
02f0 ff 19 5f 19 7f d0 ea 47-04 f8 06 6b c8 31 c3 04 |.._....G ...k.1..|
0300 1b 90 7e 16 f5 0d 17 4c-8a 9e f9 10 26 f5 ca 40 |..~....L ....&..@|
0310 2c de c4 ee 77 bd 0b 2d-46 2b c7 79 34 77 d2 0b |,...w..- F+.y4w..|
0320 39 6c 3d 26 6b 2d d8 ac-54 5c 46 a0 f0 48 3b d1 |9l=&k-.. T\F..H;.|
0330 22 d9 7f 8b b9 c7 3b 2e-40 87 d0 a5 9d 48 0b 73 |".....;. @....H.s|
0340 ad 36 66 03 d5 7d a4 d4-1d 81 19 e0 c1 93 f4 28 |.6f..}.. .......(|
0350 41 6f 16 c3 3b 24 6d 7d-03 8a 6b 4c 36 32 e0 9b |Ao..;$m} ..kL62..|
0360 b5 10 4f 52 ed bb ad 21-5c c6 27 dc be e3 0c 00 |..OR...! \.'.....|
0370 01 28 03 00 1d 20 59 d4-27 ef ec fa d8 d8 bd 2b |.(... Y. '......+|
0380 7e 3f 8c 40 da f6 f8 00-b2 66 01 86 a9 91 27 8e |~?.@.... .f....'.|
0390 ad 39 a7 6b 71 4c 04 01-01 00 14 f2 1c 8d 21 4c |.9.kqL.. ......!L|
03a0 d6 ff 9d e3 c0 41 5c 84-e9 b2 bc 99 16 49 8d bb |.....A\. .....I..|
03b0 b9 9d 05 ce 90 44 ac 15-e3 a1 ad cf cf 4a cb 71 |.....D.. .....J.q|
03c0 88 2a 92 ad 40 a5 9a da-e4 3b a3 23 34 16 f5 8a |.*..@... .;.#4...|
03d0 02 04 42 2a ec c8 9b 97-bd 6b 1d d5 e6 50 aa e3 |..B*.... .k...P..|
03e0 89 41 6d 7f b6 e0 c8 67-9c e3 8e 4a 9f 71 24 3e |.Am....g ...J.q$>|
03f0 7f 9a d1 f9 35 1d e1 1d-9c 07 55 80 4a 2b c9 76 |....5... ..U.J+.v|
0400 b6 39 9b 07 0e 37 c5 a7-15 a3 bf 3a 0d b6 f1 8a |.9...7.. ...:....|
0410 d2 21 0b 8d 6d d9 3a 02-86 ad 5c b8 d7 36 18 c3 |.!..m.:. ..\..6..|
0420 44 7e 49 27 37 6c 38 29-d8 7b 5f ef 1d 24 e4 b4 |D~I'7l8) .{_..$..|
0430 ff 54 73 bc a4 17 33 b5-f5 50 b2 16 03 c8 27 a3 |.Ts...3. .P....'.|
0440 9e e9 e9 90 27 0b 28 be-88 73 e0 e9 7c 7f 81 0b |....'.(. .s..|...|
0450 b0 8b 4c 1c 87 fb 11 eb-95 8a d6 13 ea c3 7b 0d |..L..... ......{.|
0460 65 ce 3b 6e 95 34 b0 55-72 a3 78 af 67 75 5d 23 |e.;n.4.U r.x.gu]#|
0470 91 21 83 e9 bb 51 8a df-6f 68 cb 5e 9a 6f 93 c5 |.!...Q.. oh.^.o..|
0480 6b 2e d1 4e ab ac 3f fb-a9 24 17 06 23 6f 27 9d |k..N..?. .$..#o'.|
0490 18 da a5 b9 6f 40 6b 16-14 87 0e 00 00 00 |....o@k. ......|
tls.c:117:in tds_pull_func_login
tls.c:147:in tds_push_func_login
tls.c:117:in tds_pull_func_login
packet.c:801:Sending packet
0000 12 01 00 65 00 00 00 00-16 03 03 00 25 10 00 00 |...e.... ....%...|
0010 21 20 49 39 60 c2 12 24-02 ab 79 7a 42 7f f9 84 |! I9`..$ ..yzB...|
0020 38 94 2b 7e d0 bc a5 64-15 78 13 9c 85 f5 ab b0 |8.+~...d .x......|
0030 42 55 14 03 03 00 01 01-16 03 03 00 28 44 6e 12 |BU...... ....(Dn.|
0040 30 84 69 8b 2f 9c 11 e4-c4 cb d4 16 30 a0 b9 a3 |0.i./... ....0...|
0050 3d b1 6d d8 47 ac 1d 33-f1 bc ea 2b 0c 72 35 ae |=.m.G..3 ...+.r5.|
0060 c4 c6 3a 9c 08 - |..:..|
packet.c:435:Received packet
0000 12 01 00 3b 00 00 00 00-14 03 03 00 01 01 16 03 |...;.... ........|
0010 03 00 28 00 00 00 00 00-00 00 00 ab 32 18 34 27 |..(..... ....2.4'|
0020 1d 53 2f 2e 7b b4 46 74-15 cb 6d 13 db 58 79 88 |.S/.{.Ft ..m..Xy.|
0030 51 01 a5 e7 e0 c0 a7 e2-1d 38 f7 |Q....... .8.|
tls.c:117:in tds_pull_func_login
tls.c:117:in tds_pull_func_login
tls.c:117:in tds_pull_func_login
tls.c:1048:handshake succeeded!!
login.c:975:quietly sending TDS 7+ login packet
token.c:416:tds_process_login_tokens()
packet.c:435:Received packet
0000 04 01 01 9d 00 35 01 00-e3 1f 00 01 08 6d 00 73 |.....5.. .....m.s|
0010 00 76 00 74 00 65 00 73-00 74 00 31 00 06 6d 00 |.v.t.e.s .t.1..m.|
0020 61 00 73 00 74 00 65 00-72 00 ab 76 00 45 16 00 |a.s.t.e. r..v.E..|
0030 00 02 00 27 00 43 00 68-00 61 00 6e 00 67 00 65 |...'.C.h .a.n.g.e|
0040 00 64 00 20 00 64 00 61-00 74 00 61 00 62 00 61 |.d. .d.a .t.a.b.a|
0050 00 73 00 65 00 20 00 63-00 6f 00 6e 00 74 00 65 |.s.e. .c .o.n.t.e|
0060 00 78 00 74 00 20 00 74-00 6f 00 20 00 27 00 6d |.x.t. .t .o. .'.m|
0070 00 73 00 76 00 74 00 65-00 73 00 74 00 31 00 27 |.s.v.t.e .s.t.1.'|
0080 00 2e 00 0d 49 00 44 00-41 00 5c 00 53 00 51 00 |....I.D. A.\.S.Q.|
0090 4c 00 53 00 52 00 56 00-30 00 30 00 33 00 00 01 |L.S.R.V. 0.0.3...|
00a0 00 00 00 e3 08 00 07 05-09 04 d0 24 00 00 e3 17 |........ ...$....|
00b0 00 02 0a 75 00 73 00 5f-00 65 00 6e 00 67 00 6c |...u.s._ .e.n.g.l|
00c0 00 69 00 73 00 68 00 00-ab 76 00 47 16 00 00 01 |.i.s.h.. .v.G....|
00d0 00 27 00 43 00 68 00 61-00 6e 00 67 00 65 00 64 |.'.C.h.a .n.g.e.d|
00e0 00 20 00 6c 00 61 00 6e-00 67 00 75 00 61 00 67 |. .l.a.n .g.u.a.g|
00f0 00 65 00 20 00 73 00 65-00 74 00 74 00 69 00 6e |.e. .s.e .t.t.i.n|
0100 00 67 00 20 00 74 00 6f-00 20 00 75 00 73 00 5f |.g. .t.o . .u.s._|
0110 00 65 00 6e 00 67 00 6c-00 69 00 73 00 68 00 2e |.e.n.g.l .i.s.h..|
0120 00 0d 49 00 44 00 41 00-5c 00 53 00 51 00 4c 00 |..I.D.A. \.S.Q.L.|
0130 53 00 52 00 56 00 30 00-30 00 33 00 00 01 00 00 |S.R.V.0. 0.3.....|
0140 00 ad 36 00 01 73 0b 00-03 16 4d 00 69 00 63 00 |..6..s.. ..M.i.c.|
0150 72 00 6f 00 73 00 6f 00-66 00 74 00 20 00 53 00 |r.o.s.o. f.t. .S.|
0160 51 00 4c 00 20 00 53 00-65 00 72 00 76 00 65 00 |Q.L. .S. e.r.v.e.|
0170 72 00 00 00 00 00 0f 00-04 b0 e3 13 00 04 04 34 |r....... .......4|
0180 00 30 00 39 00 36 00 04-34 00 30 00 39 00 36 00 |.0.9.6.. 4.0.9.6.|
0190 fd 00 00 00 00 00 00 00-00 00 00 00 00 |........ .....|
token.c:420:looking for login token, got e3(ENVCHANGE)
token.c:129:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:420:looking for login token, got ab(INFO)
token.c:129:tds_process_default_tokens() marker is ab(INFO)
mem.c:656:tds_free_all_results()
token.c:2398:tds_process_info() reading message 5701 from server
token.c:2493:tds_process_info() calling client msg handler
odbc.c:2367:msgno 5701 20003
token.c:2510:tds_process_info() returning TDS_SUCCESS
token.c:420:looking for login token, got e3(ENVCHANGE)
token.c:129:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2225:tds_process_env_chg(): 5 bytes of collation data received
token.c:2226:tds->conn->collation was
0000 00 00 00 00 00 - |.....|
iconv.c:785:setting server single-byte charset to "CP1252"
token.c:2236:tds->conn->collation now
0000 09 04 d0 24 00 - |...$.|
token.c:420:looking for login token, got e3(ENVCHANGE)
token.c:129:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:420:looking for login token, got ab(INFO)
token.c:129:tds_process_default_tokens() marker is ab(INFO)
mem.c:656:tds_free_all_results()
token.c:2398:tds_process_info() reading message 5703 from server
token.c:2493:tds_process_info() calling client msg handler
odbc.c:2367:msgno 5703 20003
token.c:2510:tds_process_info() returning TDS_SUCCESS
token.c:420:looking for login token, got ad(LOGINACK)
token.c:346:server reports TDS version 73.b.0.3
token.c:348:Product name for 0x730b0003 is 2008
token.c:382:Product version 8F0004B0
token.c:420:looking for login token, got e3(ENVCHANGE)
token.c:129:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2285:changing block size from 4096 to 4096
token.c:420:looking for login token, got fd(DONE)
token.c:129:tds_process_default_tokens() marker is fd(DONE)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
token.c:443:tds_process_login_tokens() returning TDS_SUCCESS
odbc.c:1529:SQLAllocHandle(3, 0x619000000580, 0x7ffeca4c4420)
odbc.c:1704:_SQLAllocStmt(0x619000000580, 0x7ffeca4c4420)
odbc_export.h:815:SQLExecDirect(0x613000000580, SELECT SERVERPROPERTY('ProductVersion'), -3)
prepare_query.c:202:parsing 0 parameters
odbc.c:3273:_SQLExecute(0x613000000580)
odbc.c:3290:_SQLExecute() starting with state 0
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
packet.c:801:Sending packet
0000 01 01 00 6c 00 00 01 00-16 00 00 00 12 00 00 00 |...l.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 53 00 |........ ......S.|
0020 45 00 4c 00 45 00 43 00-54 00 20 00 53 00 45 00 |E.L.E.C. T. .S.E.|
0030 52 00 56 00 45 00 52 00-50 00 52 00 4f 00 50 00 |R.V.E.R. P.R.O.P.|
0040 45 00 52 00 54 00 59 00-28 00 27 00 50 00 72 00 |E.R.T.Y. (.'.P.r.|
0050 6f 00 64 00 75 00 63 00-74 00 56 00 65 00 72 00 |o.d.u.c. t.V.e.r.|
0060 73 00 69 00 6f 00 6e 00-27 00 29 00 |s.i.o.n. '.).|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffeca4c4228, 0x7ffeca4c422c, 0x6914)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 4a 00 35 01 00-81 01 00 00 00 00 00 21 |...J.5.. .......!|
0010 00 62 49 1f 00 00 00 d1-21 00 00 00 e7 07 09 04 |.bI..... !.......|
0020 d0 00 34 00 01 31 00 35-00 2e 00 30 00 2e 00 31 |..4..1.5 ...0...1|
0030 00 32 00 30 00 30 00 2e-00 32 00 34 00 fd 10 00 |.2.0.0.. .2.4....|
0040 c1 00 01 00 00 00 00 00-00 00 |........ ..|
token.c:568:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1572:processing TDS7 result metadata.
mem.c:656:tds_free_all_results()
token.c:1597:set current_results (1 column) to tds->res_info
token.c:1604:setting up 1 columns
token.c:1541:tds7_get_data_info:
colname =
type = 98 (variant)
server's type = 98 (variant)
column_varint_size = 4
column_size = 8009 (8009 on server)
token.c:1613: name size/wsize type/wtype utype
token.c:1614: -------------------- --------------- --------------- -------
token.c:1619: 8009/8009 98/98 0
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4049, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3687:odbc_process_tokens: returning result_type 4049
odbc.c:3436:_SQLExecute: odbc_process_tokens returned result_type 4049
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffeca4c4228, 0x7ffeca4c422c, 0x6914)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is d1(ROW)
token.c:674:tds_process_tokens::SET_RETURN stopping on current token
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3687:odbc_process_tokens: returning result_type 4040
odbc.c:3436:_SQLExecute: odbc_process_tokens returned result_type 4040
odbc.c:1824:SQLBindCol(0x613000000580, 1, 1, 0x7ffeca4c44a0, 100, 0x7ffeca4c4460)
odbc.c:4018:SQLFetch(0x613000000580)
odbc.c:3752:_SQLFetch(0x613000000580, 1, 0)
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffeca4c4238, 0x7ffeca4c423c, 0x6508)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is d1(ROW)
token.c:1949:tds_process_row(): reading column 0
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3687:odbc_process_tokens: returning result_type 4040
convert_tds2sql.c:292:odbc_tds2sql: src is 231 dest = 1
odbc.c:4268:SQLCloseCursor(0x613000000580)
odbc.c:4166:_SQLFreeStmt(0x613000000580, 0, 0)
query.c:2128:tds_send_cancel: not in_cancel and not idle
query.c:2174:tds_send_cancel: sending cancel packet
packet.c:801:Sending packet
0000 06 01 00 08 00 00 01 00- |........|
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffeca4c42ec, (nil), 0x0)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is fd(DONE)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2113: rows_affected = 1
packet.c:435:Received packet
0000 04 01 00 15 00 35 01 00-fd 20 00 fd 00 00 00 00 |.....5.. . ......|
0010 00 00 00 00 00 - |.....|
token.c:568:processing result tokens. marker is fd(DONE)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 1
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
odbc.c:4063:SQLFreeHandle(3, 0x613000000580)
odbc.c:4166:_SQLFreeStmt(0x613000000580, 1, 0)
odbc.c:1529:SQLAllocHandle(3, 0x619000000580, 0x611000013180)
odbc.c:1704:_SQLAllocStmt(0x619000000580, 0x611000013180)
odbc.c:6720:SQLSetStmtAttr(0x613000000740, -1, (nil), -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000000740, -1, (nil), -5)
odbc.c:6720:SQLSetStmtAttr(0x613000000740, -2, 0x1, -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000000740, -2, 0x1, -5)
odbc_export.h:815:SQLExecDirect(0x613000000740, select col1 from mytab1, -3)
prepare_query.c:202:parsing 0 parameters
odbc.c:3273:_SQLExecute(0x613000000740)
odbc.c:3290:_SQLExecute() starting with state 0
query.c:2338:tds_cursor_declare() cursor id = 0
query.c:2385:tds_cursor_open() cursor id = 0
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
query.c:2512:tds_cursor_open (): RPC call set up
query.c:2516:tds_cursor_open (): cursor open completed
packet.c:801:Sending packet
0000 03 01 00 86 00 00 01 00-16 00 00 00 12 00 00 00 |........ ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........|
0020 02 00 00 00 00 01 26 04-00 00 00 63 32 00 00 00 |......&. ...c2...|
0030 09 04 d0 24 00 32 00 00-00 73 00 65 00 6c 00 65 |...$.2.. .s.e.l.e|
0040 00 63 00 74 00 20 00 63-00 6f 00 6c 00 31 00 20 |.c.t. .c .o.l.1. |
0050 00 66 00 72 00 6f 00 6d-00 20 00 20 00 20 00 6d |.f.r.o.m . . . .m|
0060 00 79 00 74 00 61 00 62-00 31 00 00 01 26 04 04 |.y.t.a.b .1...&..|
0070 08 00 00 00 00 01 26 04-04 01 20 00 00 00 01 26 |......&. .. ....&|
0080 04 04 00 00 00 00 - |......|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffeca4c59f8, 0x7ffeca4c59fc, 0x6900)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 ba 00 35 01 00-81 02 00 00 00 00 00 09 |.....5.. ........|
0010 00 e7 14 00 09 04 d0 24-00 04 63 00 6f 00 6c 00 |.......$ ..c.o.l.|
0020 31 00 00 00 00 00 00 00-38 07 52 00 4f 00 57 00 |1....... 8.R.O.W.|
0030 53 00 54 00 41 00 54 00-a4 0f 00 01 06 00 6d 00 |S.T.A.T. ......m.|
0040 79 00 74 00 61 00 62 00-31 00 a5 06 00 01 01 00 |y.t.a.b. 1.......|
0050 02 00 14 ff 11 00 c1 00-00 00 00 00 00 00 00 00 |........ ........|
0060 79 00 00 00 00 ac 00 00-00 01 00 00 00 00 00 00 |y....... ........|
0070 26 04 04 f3 de bc 0a ac-02 00 00 01 00 00 00 00 |&....... ........|
0080 00 00 26 04 04 08 00 00-00 ac 03 00 00 01 00 00 |..&..... ........|
0090 00 00 00 00 26 04 04 01-00 00 00 ac 04 00 00 01 |....&... ........|
00a0 00 00 00 00 00 00 26 04-04 01 00 00 00 fe 00 00 |......&. ........|
00b0 e0 00 00 00 00 00 00 00-00 00 |........ ..|
token.c:568:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1572:processing TDS7 result metadata.
mem.c:656:tds_free_all_results()
token.c:1594:set current_results to cursor->res_info
token.c:1604:setting up 2 columns
token.c:1541:tds7_get_data_info:
colname = col1
type = 39 (varchar)
server's type = 231 (x UCS-2 varchar)
column_varint_size = 2
column_size = 20 (20 on server)
token.c:1541:tds7_get_data_info:
colname = ROWSTAT
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1613: name size/wsize type/wtype utype
token.c:1614: -------------------- --------------- --------------- -------
token.c:1619: col1 20/20 39/231 0
token.c:1619: ROWSTAT 4/4 56/56 0
token.c:568:processing result tokens. marker is ff(DONEINPROC)
token.c:2094:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2113: rows_affected = 0
token.c:568:processing result tokens. marker is 79(RETURNSTATUS)
token.c:568:processing result tokens. marker is ac(PARAM)
token.c:617:processing parameters for op 2
token.c:619:calling tds_process_param_result
token.c:1303:tds_process_param_result(0x6120000007c0, 0x7ffeca4c5978)
token.c:1645:tds_get_data_info(0x6120000007c0, 0x610000000b40, 1) [for parameter]
token.c:1707:processing result. type = 38(integer-null), varint_size 1
token.c:1712:processing result. column_size 4
data.c:717:tds_get_data: type 38, varint size 1
data.c:761:tds_get_data(): wire column size is 4
log.c:443:type integer-null has value 180150003
token.c:619:calling tds_process_param_result
token.c:1303:tds_process_param_result(0x6120000007c0, 0x7ffeca4c5978)
token.c:1645:tds_get_data_info(0x6120000007c0, 0x610000000c40, 1) [for parameter]
token.c:1707:processing result. type = 38(integer-null), varint_size 1
token.c:1712:processing result. column_size 4
data.c:717:tds_get_data: type 38, varint size 1
data.c:761:tds_get_data(): wire column size is 4
log.c:443:type integer-null has value 8
token.c:619:calling tds_process_param_result
token.c:1303:tds_process_param_result(0x6120000007c0, 0x7ffeca4c5978)
token.c:1645:tds_get_data_info(0x6120000007c0, 0x610000000d40, 1) [for parameter]
token.c:1707:processing result. type = 38(integer-null), varint_size 1
token.c:1712:processing result. column_size 4
data.c:717:tds_get_data: type 38, varint size 1
data.c:761:tds_get_data(): wire column size is 4
log.c:443:type integer-null has value 1
token.c:619:calling tds_process_param_result
token.c:1303:tds_process_param_result(0x6120000007c0, 0x7ffeca4c5978)
token.c:1645:tds_get_data_info(0x6120000007c0, 0x610000000e40, 1) [for parameter]
token.c:1707:processing result. type = 38(integer-null), varint_size 1
token.c:1712:processing result. column_size 4
data.c:717:tds_get_data: type 38, varint size 1
data.c:761:tds_get_data(): wire column size is 4
log.c:443:type integer-null has value 1
token.c:625:4 hidden return parameters
token.c:632:stored internal cursor id 180150003
token.c:568:processing result tokens. marker is fe(DONEPROC)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3660:odbc_process_tokens: processed TDS_DONE_RESULT
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffeca4c59f8, 0x7ffeca4c59fc, 0x26900)
token.c:556:tds_process_tokens() state is COMPLETED
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3615: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
query.c:2885:tds_cursor_setname() cursor id = 180150003
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
packet.c:801:Sending packet
0000 03 01 00 55 00 00 01 00-16 00 00 00 12 00 00 00 |...U.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........|
0020 08 00 00 00 00 00 26 04-04 f3 de bc 0a 00 00 26 |......&. .......&|
0030 04 04 02 00 00 00 00 00-a7 13 00 09 04 d0 24 00 |........ ......$.|
0040 13 00 53 51 4c 5f 43 55-52 36 31 33 30 30 30 30 |..SQL_CU R6130000|
0050 30 30 37 34 30 - |00740|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffeca4c59f8, 0x7ffeca4c59fc, 0x6914)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 1a 00 35 01 00-79 00 00 00 00 fe 00 00 |.....5.. y.......|
0010 e0 00 00 00 00 00 00 00-00 00 |........ ..|
token.c:568:processing result tokens. marker is 79(RETURNSTATUS)
token.c:568:processing result tokens. marker is fe(DONEPROC)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3615: result_type=1, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3436:_SQLExecute: odbc_process_tokens returned result_type 4046
odbc.c:4531:SQLNumResultCols(0x613000000740, 0x7ffeca4c5b10)
odbc_export.h:556:SQLDescribeCol(0x613000000740, 1, (nil), 0, 0x7ffeca4c59e0, 0x7ffeca4c5a20, 0x7ffeca4c5ae0, 0x7ffeca4c5a60, 0x7ffeca4c5aa0)
odbc.c:6720:SQLSetStmtAttr(0x613000000740, 5, (nil), -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000000740, 5, (nil), -5)
odbc.c:6720:SQLSetStmtAttr(0x613000000740, 27, 0xa, -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000000740, 27, 0xa, -5)
odbc.c:6720:SQLSetStmtAttr(0x613000000740, 26, 0x6110000131c8, -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000000740, 26, 0x6110000131c8, -5)
odbc_export.h:556:SQLDescribeCol(0x613000000740, 1, (nil), 0, 0x7ffeca4c5a20, 0x606000006cf8, 0x7ffeca4c5ae0, 0x7ffeca4c5a60, 0x7ffeca4c5aa0)
odbc.c:1824:SQLBindCol(0x613000000740, 1, 1, 0x6120000010c0, 31, 0x607000003820)
odbc.c:4047:SQLFetchScroll(0x613000000740, 1, 0)
odbc.c:3752:_SQLFetch(0x613000000740, 1, 0)
query.c:2528:tds_cursor_setrows() cursor id = 180150003
query.c:2629:tds_cursor_fetch() cursor id = 180150003
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
packet.c:801:Sending packet
0000 03 01 00 44 00 00 01 00-16 00 00 00 12 00 00 00 |...D.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........|
0020 07 00 02 00 00 00 26 04-04 f3 de bc 0a 00 00 26 |......&. .......&|
0030 04 04 02 00 00 00 00 00-26 04 00 00 00 26 04 04 |........ &....&..|
0040 0a 00 00 00 - |....|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffeca4c5a18, 0x7ffeca4c5a1c, 0x6d00)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 45 00 35 01 00-81 ff ff d1 14 00 61 00 |...E.5.. ......a.|
0010 62 00 63 00 20 00 20 00-20 00 20 00 20 00 20 00 |b.c. . . . . . .|
0020 20 00 01 00 00 00 ff 11-00 c1 00 01 00 00 00 00 | ....... ........|
0030 00 00 00 79 00 00 00 00-fe 00 00 e0 00 00 00 00 |...y.... ........|
0040 00 00 00 00 00 - |.....|
token.c:568:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1572:processing TDS7 result metadata.
token.c:1581:no meta data
token.c:568:processing result tokens. marker is d1(ROW)
token.c:665:tds_process_tokens(). set current_results to cursor->res_info
token.c:674:tds_process_tokens::SET_RETURN stopping on current token
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3687:odbc_process_tokens: returning result_type 4040
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffeca4c5a18, 0x7ffeca4c5a1c, 0x6508)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is d1(ROW)
token.c:665:tds_process_tokens(). set current_results to cursor->res_info
token.c:1949:tds_process_row(): reading column 0
data.c:717:tds_get_data: type 39, varint size 2
data.c:761:tds_get_data(): wire column size is 20
token.c:1949:tds_process_row(): reading column 1
data.c:717:tds_get_data: type 56, varint size 0
data.c:761:tds_get_data(): wire column size is 4
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3687:odbc_process_tokens: returning result_type 4040
convert_tds2sql.c:292:odbc_tds2sql: src is 231 dest = 1
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffeca4c5a18, 0x7ffeca4c5a1c, 0x6508)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is ff(DONEINPROC)
token.c:2094:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2113: rows_affected = 1
token.c:568:processing result tokens. marker is 79(RETURNSTATUS)
token.c:568:processing result tokens. marker is fe(DONEPROC)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3615: result_type=1, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3886:SQLFetch: NO_DATA_FOUND
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffeca4c5ab4, (nil), 0x2282a)
token.c:556:tds_process_tokens() state is COMPLETED
odbc.c:4268:SQLCloseCursor(0x613000000740)
odbc.c:4166:_SQLFreeStmt(0x613000000740, 0, 0)
query.c:2824:tds_cursor_close() cursor id = 180150003
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
packet.c:801:Sending packet
0000 03 01 00 2d 00 00 01 00-16 00 00 00 12 00 00 00 |...-.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........|
0020 09 00 02 00 00 00 26 04-04 f3 de bc 0a |......&. .....|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffeca4c5b08, 0x7ffeca4c5b0c, 0x100)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 1a 00 35 01 00-79 00 00 00 00 fe 00 00 |.....5.. y.......|
0010 e0 00 00 00 00 00 00 00-00 00 |........ ..|
token.c:568:processing result tokens. marker is 79(RETURNSTATUS)
token.c:568:processing result tokens. marker is fe(DONEPROC)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
token.c:772:TDS_OP_CURSORCLOSE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
mem.c:918:tds_cursor_deallocated() : freeing cursor_id 180150003
odbc.c:4063:SQLFreeHandle(3, 0x613000000740)
odbc.c:4166:_SQLFreeStmt(0x613000000740, 1, 0)
odbc.c:2332:SQLDisconnect(0x619000000580)
query.c:3783:tds_disconnect()
util.c:165:Changed query state from IDLE to DEAD
mem.c:949:tds_release_cursor() : freeing cursor_id 180150003
mem.c:951:tds_release_cursor() : freeing cursor results
mem.c:956:tds_release_cursor() : freeing cursor name
mem.c:961:tds_release_cursor() : freeing cursor query
mem.c:965:tds_release_cursor() : cursor_id 180150003 freed
mem.c:656:tds_free_all_results()
odbc.c:4063:SQLFreeHandle(2, 0x619000000580)
odbc.c:4089:_SQLFreeConnect(0x619000000580)
bcp.c:673:_bcp_free_storage(0x619000000580)
log.c:168:Starting log file for FreeTDS 1.1rc3
on 2019-02-21 15:15:29 with debug flags 0x4fff.
iconv.c:326:tds_iconv_open(0x612000000640, UTF-8)
iconv.c:186:local name for ISO-8859-1 is ISO-8859-1
iconv.c:186:local name for UTF-8 is UTF-8
iconv.c:186:local name for UCS-2LE is UCS-2LE
iconv.c:186:local name for UCS-2BE is UCS-2BE
iconv.c:348:setting up conversions for client charset "UTF-8"
iconv.c:350:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:389:tds_iconv_open: done
net.c:391:Connecting with protocol version 7.3
net.c:318:Connecting to 10.0.40.27 port 1684
net.c:340:tds_setup_socket: connect(2) returned "Operation now in progress"
net.c:528:tds_open_socket() succeeded
packet.c:801: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 57 13 00-00 00 |rver.W.. ..|
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 0f 00 04 b0 00 00-00 00 00 |........ ...|
login.c:1253:detected flag 0
tls.c:1012: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:801:Sending packet
0000 12 01 00 ca 00 00 00 00-16 03 01 00 bd 01 00 00 |........ ........|
0010 b9 03 03 3f 80 22 83 f9-a0 27 55 9c 25 7a f0 a0 |...?.".. .'U.%z..|
0020 6e e9 50 29 87 ec 92 bf-38 ce b2 4a d7 d4 8c 58 |n.P).... 8..J...X|
0030 d2 8e 60 00 00 4a c0 2c-c0 30 cc a9 cc a8 c0 af |..`..J., .0......|
0040 c0 ad c0 2b c0 2f c0 ae-c0 ac c0 24 c0 28 c0 73 |...+./.. ...$.(.s|
0050 c0 77 c0 23 c0 27 c0 72-c0 76 c0 0a c0 14 c0 09 |.w.#.'.r .v......|
0060 c0 13 00 9d c0 a1 c0 9d-00 9c c0 a0 c0 9c 00 3d |........ .......=|
0070 00 c0 00 3c 00 ba 00 35-00 84 00 2f 00 41 00 ff |...<...5 .../.A..|
0080 01 00 00 46 00 0b 00 04-03 00 01 02 00 0a 00 0a |...F.... ........|
0090 00 08 00 1d 00 17 00 19-00 18 00 23 00 00 00 16 |........ ...#....|
00a0 00 00 00 17 00 00 00 0d-00 20 00 1e 06 01 06 02 |........ . ......|
00b0 06 03 05 01 05 02 05 03-04 01 04 02 04 03 03 01 |........ ........|
00c0 03 02 03 03 02 01 02 02-02 03 |........ ..|
packet.c:435:Received packet
0000 12 01 04 9e 00 00 00 00-16 03 03 04 91 02 00 00 |........ ........|
0010 51 03 03 5c 6e b2 81 48-35 9f 4a 84 a9 20 33 90 |Q..\n..H 5.J.. 3.|
0020 d5 df 10 12 14 54 4e 27-dc 5b cc 13 ec 7b d6 2c |.....TN' .[...{.,|
0030 44 d1 77 20 8b 1a 00 00-bd e1 27 f6 53 04 71 44 |D.w .... ..'.S.qD|
0040 85 0c c3 a2 96 43 75 1d-b8 ef bf a4 04 95 50 9a |.....Cu. ......P.|
0050 34 a2 28 f7 c0 30 00 00-09 00 17 00 00 ff 01 00 |4.(..0.. ........|
0060 01 00 0b 00 03 08 00 03-05 00 03 02 30 82 02 fe |........ ....0...|
0070 30 82 01 e6 a0 03 02 01-02 02 10 28 7e 47 1f 3d |0....... ...(~G.=|
0080 bb 23 be 4b b2 dc 3c fd-45 27 ed 30 0d 06 09 2a |.#.K..<. E'.0...*|
0090 86 48 86 f7 0d 01 01 0b-05 00 30 3b 31 39 30 37 |.H...... ..0;1907|
00a0 06 03 55 04 03 1e 30 00-53 00 53 00 4c 00 5f 00 |..U...0. S.S.L._.|
00b0 53 00 65 00 6c 00 66 00-5f 00 53 00 69 00 67 00 |S.e.l.f. _.S.i.g.|
00c0 6e 00 65 00 64 00 5f 00-46 00 61 00 6c 00 6c 00 |n.e.d._. F.a.l.l.|
00d0 62 00 61 00 63 00 6b 30-1e 17 0d 31 39 30 32 31 |b.a.c.k0 ...19021|
00e0 39 31 37 35 33 31 30 5a-17 0d 34 39 30 32 31 39 |9175310Z ..490219|
00f0 31 37 35 33 31 30 5a 30-3b 31 39 30 37 06 03 55 |175310Z0 ;1907..U|
0100 04 03 1e 30 00 53 00 53-00 4c 00 5f 00 53 00 65 |...0.S.S .L._.S.e|
0110 00 6c 00 66 00 5f 00 53-00 69 00 67 00 6e 00 65 |.l.f._.S .i.g.n.e|
0120 00 64 00 5f 00 46 00 61-00 6c 00 6c 00 62 00 61 |.d._.F.a .l.l.b.a|
0130 00 63 00 6b 30 82 01 22-30 0d 06 09 2a 86 48 86 |.c.k0.." 0...*.H.|
0140 f7 0d 01 01 01 05 00 03-82 01 0f 00 30 82 01 0a |........ ....0...|
0150 02 82 01 01 00 bb 71 e5-83 fc bc 85 d4 5a 5d ed |......q. .....Z].|
0160 f8 d5 7b ad 87 f9 86 8e-25 fc d4 05 c3 a2 9f 05 |..{..... %.......|
0170 be b9 6d a8 6e a3 70 a8-60 50 7a 5b e1 e5 19 01 |..m.n.p. `Pz[....|
0180 7b 87 8f f2 ab bb da f7-04 99 a5 d3 be 5a 10 b0 |{....... .....Z..|
0190 cc 77 77 b5 ff 81 36 e9-55 ad cf cd 83 e2 39 3e |.ww...6. U.....9>|
01a0 15 54 4a 30 ff d9 ee 7e-f0 25 32 c3 e9 97 76 02 |.TJ0...~ .%2...v.|
01b0 e4 21 22 b9 ba c8 31 4d-dc b5 88 c7 7c 67 90 da |.!"...1M ....|g..|
01c0 f9 9d dd 7f 6e 97 23 de-5a 80 f7 23 92 9c d4 23 |....n.#. Z..#...#|
01d0 4f 6e a5 17 87 66 3a 2c-0b 99 dd d4 28 5a 25 d9 |On...f:, ....(Z%.|
01e0 f7 3a fb 6d 1a 97 9a a1-04 3f 2c 74 20 52 d3 a3 |.:.m.... .?,t R..|
01f0 01 00 24 f2 85 1d bd d0-82 7d 35 db 06 87 83 25 |..$..... .}5....%|
0200 ba e0 b8 94 74 a3 3e e4-aa ea 19 10 e0 30 04 1c |....t.>. .....0..|
0210 60 81 9d 84 bc 39 00 1a-d0 e6 2a 14 34 71 e7 d5 |`....9.. ..*.4q..|
0220 49 27 e1 f2 cd 43 e5 44-97 48 0c 87 55 1c 18 f2 |I'...C.D .H..U...|
0230 5d 08 db 55 85 6a 21 83-35 a8 29 b6 6a 70 52 32 |]..U.j!. 5.).jpR2|
0240 06 0b 49 da c7 80 9d d8-90 f8 0d 69 ac eb 02 27 |..I..... ...i...'|
0250 7b 8d 56 f0 85 02 03 01-00 01 30 0d 06 09 2a 86 |{.V..... ..0...*.|
0260 48 86 f7 0d 01 01 0b 05-00 03 82 01 01 00 88 8a |H....... ........|
0270 a1 b7 dc ea fc dc 5f db-53 da 9a 4b 8a 12 55 81 |......_. S..K..U.|
0280 83 12 62 c1 fc 5c 91 b5-eb 9a 06 58 5d 70 f1 af |..b..\.. ...X]p..|
0290 aa 35 c0 1c 84 c0 ae 91-5c cb 95 ed 6b 2c 92 64 |.5...... \...k,.d|
02a0 c7 c4 32 cc 13 64 42 90-2a aa 19 a4 a7 92 46 c3 |..2..dB. *.....F.|
02b0 e5 6a 1f 94 a8 97 f8 87-6f ce 1b d8 b6 b6 dd 84 |.j...... o.......|
02c0 ed 03 cd 69 03 3b 9b 8f-c2 40 9b a0 37 3c b5 68 |...i.;.. .@..7<.h|
02d0 56 03 4a dc fb 28 79 4c-3b 28 da fe 03 3c 07 03 |V.J..(yL ;(...<..|
02e0 3d ad a4 5a 7a 36 2f 49-d6 eb 01 41 27 c5 94 62 |=..Zz6/I ...A'..b|
02f0 ff 19 5f 19 7f d0 ea 47-04 f8 06 6b c8 31 c3 04 |.._....G ...k.1..|
0300 1b 90 7e 16 f5 0d 17 4c-8a 9e f9 10 26 f5 ca 40 |..~....L ....&..@|
0310 2c de c4 ee 77 bd 0b 2d-46 2b c7 79 34 77 d2 0b |,...w..- F+.y4w..|
0320 39 6c 3d 26 6b 2d d8 ac-54 5c 46 a0 f0 48 3b d1 |9l=&k-.. T\F..H;.|
0330 22 d9 7f 8b b9 c7 3b 2e-40 87 d0 a5 9d 48 0b 73 |".....;. @....H.s|
0340 ad 36 66 03 d5 7d a4 d4-1d 81 19 e0 c1 93 f4 28 |.6f..}.. .......(|
0350 41 6f 16 c3 3b 24 6d 7d-03 8a 6b 4c 36 32 e0 9b |Ao..;$m} ..kL62..|
0360 b5 10 4f 52 ed bb ad 21-5c c6 27 dc be e3 0c 00 |..OR...! \.'.....|
0370 01 28 03 00 1d 20 59 d4-27 ef ec fa d8 d8 bd 2b |.(... Y. '......+|
0380 7e 3f 8c 40 da f6 f8 00-b2 66 01 86 a9 91 27 8e |~?.@.... .f....'.|
0390 ad 39 a7 6b 71 4c 04 01-01 00 22 ac 5f be c2 3e |.9.kqL.. .."._..>|
03a0 ad 05 e4 b7 f2 5a af 79-b1 3b e9 35 4f 6a 2d c3 |.....Z.y .;.5Oj-.|
03b0 87 4d 7d 67 38 b6 da 1f-c1 ef 7c 39 7a ba 96 33 |.M}g8... ..|9z..3|
03c0 e4 5a 8e 87 17 68 c6 12-37 1b ff 11 e2 0b 4a a7 |.Z...h.. 7.....J.|
03d0 19 18 26 c2 f2 fb fd ff-14 4a 49 9d 95 54 cc 91 |..&..... .JI..T..|
03e0 0e 0a 94 a6 b1 ec 3f ec-13 ba b9 9d 10 f3 61 82 |......?. ......a.|
03f0 67 1b 7c 26 6e 51 fa 85-b0 bc a1 f5 94 9e 76 4f |g.|&nQ.. ......vO|
0400 82 4f f0 bf bf 2a e1 4f-74 b1 69 23 ce 57 b9 04 |.O...*.O t.i#.W..|
0410 aa 92 ff 57 6d a4 e1 a7-c3 ae ba aa 70 1e d5 03 |...Wm... ....p...|
0420 17 bf a5 27 d2 88 5c c2-f7 b5 74 35 4a 2a a0 5a |...'..\. ..t5J*.Z|
0430 5c d3 47 3b 0a cc b0 dc-d5 f3 fd ea 1d a4 04 76 |\.G;.... .......v|
0440 a3 cf fd 56 e6 a4 1c 41-f5 9a ab d0 7b 8b 84 13 |...V...A ....{...|
0450 4e 19 24 03 79 9f e3 db-6e 00 71 be 69 7c d5 62 |N.$.y... n.q.i|.b|
0460 68 c7 88 dc 5f 84 91 f0-d5 66 3d 31 c8 fb 5d 27 |h..._... .f=1..]'|
0470 da a3 f2 b5 ff 69 44 e4-8d 76 6d f7 6d 94 9d b2 |.....iD. .vm.m...|
0480 0b 86 52 85 18 04 0e bb-32 85 13 81 ff 71 4d 28 |..R..... 2....qM(|
0490 4d a9 28 61 80 37 49 47-fd 1e 0e 00 00 00 |M.(a.7IG ......|
tls.c:117:in tds_pull_func_login
tls.c:147:in tds_push_func_login
tls.c:117:in tds_pull_func_login
packet.c:801:Sending packet
0000 12 01 00 65 00 00 00 00-16 03 03 00 25 10 00 00 |...e.... ....%...|
0010 21 20 8b dc 6f 4c 8d 60-22 b0 ea e3 f0 3d 03 a0 |! ..oL.` "....=..|
0020 5d aa 77 c5 f9 33 9c 80-f0 7e 63 32 8d e4 be 82 |].w..3.. .~c2....|
0030 f0 00 14 03 03 00 01 01-16 03 03 00 28 6e f5 d9 |........ ....(n..|
0040 65 4a 6b ed ce 23 5d fc-09 58 7b d6 4c 7f 01 bc |eJk..#]. .X{.L...|
0050 9b ba f6 84 13 07 57 32-27 61 2a 0b dd 1a cf b7 |......W2 'a*.....|
0060 00 99 2c d8 f3 - |..,..|
packet.c:435:Received packet
0000 12 01 00 3b 00 00 00 00-14 03 03 00 01 01 16 03 |...;.... ........|
0010 03 00 28 00 00 00 00 00-00 00 00 e0 ca f0 00 68 |..(..... .......h|
0020 cc dd 60 ba 76 26 75 86-b9 5b 3d 8c c8 2e e5 7f |..`.v&u. .[=.....|
0030 e2 22 bf 9a 51 47 83 09-91 91 b7 |."..QG.. ...|
tls.c:117:in tds_pull_func_login
tls.c:117:in tds_pull_func_login
tls.c:117:in tds_pull_func_login
tls.c:1048:handshake succeeded!!
login.c:975:quietly sending TDS 7+ login packet
token.c:416:tds_process_login_tokens()
packet.c:435:Received packet
0000 04 01 01 9d 00 33 01 00-e3 1f 00 01 08 6d 00 73 |.....3.. .....m.s|
0010 00 76 00 74 00 65 00 73-00 74 00 31 00 06 6d 00 |.v.t.e.s .t.1..m.|
0020 61 00 73 00 74 00 65 00-72 00 ab 76 00 45 16 00 |a.s.t.e. r..v.E..|
0030 00 02 00 27 00 43 00 68-00 61 00 6e 00 67 00 65 |...'.C.h .a.n.g.e|
0040 00 64 00 20 00 64 00 61-00 74 00 61 00 62 00 61 |.d. .d.a .t.a.b.a|
0050 00 73 00 65 00 20 00 63-00 6f 00 6e 00 74 00 65 |.s.e. .c .o.n.t.e|
0060 00 78 00 74 00 20 00 74-00 6f 00 20 00 27 00 6d |.x.t. .t .o. .'.m|
0070 00 73 00 76 00 74 00 65-00 73 00 74 00 31 00 27 |.s.v.t.e .s.t.1.'|
0080 00 2e 00 0d 49 00 44 00-41 00 5c 00 53 00 51 00 |....I.D. A.\.S.Q.|
0090 4c 00 53 00 52 00 56 00-30 00 30 00 33 00 00 01 |L.S.R.V. 0.0.3...|
00a0 00 00 00 e3 08 00 07 05-09 04 d0 24 00 00 e3 17 |........ ...$....|
00b0 00 02 0a 75 00 73 00 5f-00 65 00 6e 00 67 00 6c |...u.s._ .e.n.g.l|
00c0 00 69 00 73 00 68 00 00-ab 76 00 47 16 00 00 01 |.i.s.h.. .v.G....|
00d0 00 27 00 43 00 68 00 61-00 6e 00 67 00 65 00 64 |.'.C.h.a .n.g.e.d|
00e0 00 20 00 6c 00 61 00 6e-00 67 00 75 00 61 00 67 |. .l.a.n .g.u.a.g|
00f0 00 65 00 20 00 73 00 65-00 74 00 74 00 69 00 6e |.e. .s.e .t.t.i.n|
0100 00 67 00 20 00 74 00 6f-00 20 00 75 00 73 00 5f |.g. .t.o . .u.s._|
0110 00 65 00 6e 00 67 00 6c-00 69 00 73 00 68 00 2e |.e.n.g.l .i.s.h..|
0120 00 0d 49 00 44 00 41 00-5c 00 53 00 51 00 4c 00 |..I.D.A. \.S.Q.L.|
0130 53 00 52 00 56 00 30 00-30 00 33 00 00 01 00 00 |S.R.V.0. 0.3.....|
0140 00 ad 36 00 01 73 0b 00-03 16 4d 00 69 00 63 00 |..6..s.. ..M.i.c.|
0150 72 00 6f 00 73 00 6f 00-66 00 74 00 20 00 53 00 |r.o.s.o. f.t. .S.|
0160 51 00 4c 00 20 00 53 00-65 00 72 00 76 00 65 00 |Q.L. .S. e.r.v.e.|
0170 72 00 00 00 00 00 0f 00-04 b0 e3 13 00 04 04 34 |r....... .......4|
0180 00 30 00 39 00 36 00 04-34 00 30 00 39 00 36 00 |.0.9.6.. 4.0.9.6.|
0190 fd 00 00 00 00 00 00 00-00 00 00 00 00 |........ .....|
token.c:420:looking for login token, got e3(ENVCHANGE)
token.c:129:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:420:looking for login token, got ab(INFO)
token.c:129:tds_process_default_tokens() marker is ab(INFO)
mem.c:656:tds_free_all_results()
token.c:2398:tds_process_info() reading message 5701 from server
token.c:2493:tds_process_info() calling client msg handler
odbc.c:2367:msgno 5701 20003
token.c:2510:tds_process_info() returning TDS_SUCCESS
token.c:420:looking for login token, got e3(ENVCHANGE)
token.c:129:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2225:tds_process_env_chg(): 5 bytes of collation data received
token.c:2226:tds->conn->collation was
0000 00 00 00 00 00 - |.....|
iconv.c:785:setting server single-byte charset to "CP1252"
token.c:2236:tds->conn->collation now
0000 09 04 d0 24 00 - |...$.|
token.c:420:looking for login token, got e3(ENVCHANGE)
token.c:129:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:420:looking for login token, got ab(INFO)
token.c:129:tds_process_default_tokens() marker is ab(INFO)
mem.c:656:tds_free_all_results()
token.c:2398:tds_process_info() reading message 5703 from server
token.c:2493:tds_process_info() calling client msg handler
odbc.c:2367:msgno 5703 20003
token.c:2510:tds_process_info() returning TDS_SUCCESS
token.c:420:looking for login token, got ad(LOGINACK)
token.c:346:server reports TDS version 73.b.0.3
token.c:348:Product name for 0x730b0003 is 2008
token.c:382:Product version 8F0004B0
token.c:420:looking for login token, got e3(ENVCHANGE)
token.c:129:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2285:changing block size from 4096 to 4096
token.c:420:looking for login token, got fd(DONE)
token.c:129:tds_process_default_tokens() marker is fd(DONE)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
token.c:443:tds_process_login_tokens() returning TDS_SUCCESS
odbc.c:1529:SQLAllocHandle(3, 0x619000000580, 0x7ffccac48900)
odbc.c:1704:_SQLAllocStmt(0x619000000580, 0x7ffccac48900)
odbc_export.h:815:SQLExecDirect(0x613000000580, SELECT SERVERPROPERTY('ProductVersion'), -3)
prepare_query.c:202:parsing 0 parameters
odbc.c:3273:_SQLExecute(0x613000000580)
odbc.c:3290:_SQLExecute() starting with state 0
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
packet.c:801:Sending packet
0000 01 01 00 6c 00 00 01 00-16 00 00 00 12 00 00 00 |...l.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 53 00 |........ ......S.|
0020 45 00 4c 00 45 00 43 00-54 00 20 00 53 00 45 00 |E.L.E.C. T. .S.E.|
0030 52 00 56 00 45 00 52 00-50 00 52 00 4f 00 50 00 |R.V.E.R. P.R.O.P.|
0040 45 00 52 00 54 00 59 00-28 00 27 00 50 00 72 00 |E.R.T.Y. (.'.P.r.|
0050 6f 00 64 00 75 00 63 00-74 00 56 00 65 00 72 00 |o.d.u.c. t.V.e.r.|
0060 73 00 69 00 6f 00 6e 00-27 00 29 00 |s.i.o.n. '.).|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffccac48708, 0x7ffccac4870c, 0x6914)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 4a 00 33 01 00-81 01 00 00 00 00 00 21 |...J.3.. .......!|
0010 00 62 49 1f 00 00 00 d1-21 00 00 00 e7 07 09 04 |.bI..... !.......|
0020 d0 00 34 00 01 31 00 35-00 2e 00 30 00 2e 00 31 |..4..1.5 ...0...1|
0030 00 32 00 30 00 30 00 2e-00 32 00 34 00 fd 10 00 |.2.0.0.. .2.4....|
0040 c1 00 01 00 00 00 00 00-00 00 |........ ..|
token.c:568:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1572:processing TDS7 result metadata.
mem.c:656:tds_free_all_results()
token.c:1597:set current_results (1 column) to tds->res_info
token.c:1604:setting up 1 columns
token.c:1541:tds7_get_data_info:
colname =
type = 98 (variant)
server's type = 98 (variant)
column_varint_size = 4
column_size = 8009 (8009 on server)
token.c:1613: name size/wsize type/wtype utype
token.c:1614: -------------------- --------------- --------------- -------
token.c:1619: 8009/8009 98/98 0
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4049, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3687:odbc_process_tokens: returning result_type 4049
odbc.c:3436:_SQLExecute: odbc_process_tokens returned result_type 4049
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffccac48708, 0x7ffccac4870c, 0x6914)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is d1(ROW)
token.c:674:tds_process_tokens::SET_RETURN stopping on current token
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3687:odbc_process_tokens: returning result_type 4040
odbc.c:3436:_SQLExecute: odbc_process_tokens returned result_type 4040
odbc.c:1824:SQLBindCol(0x613000000580, 1, 1, 0x7ffccac48980, 100, 0x7ffccac48940)
odbc.c:4018:SQLFetch(0x613000000580)
odbc.c:3752:_SQLFetch(0x613000000580, 1, 0)
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffccac48718, 0x7ffccac4871c, 0x6508)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is d1(ROW)
token.c:1949:tds_process_row(): reading column 0
util.c:165:Changed query state from READING to PENDING
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3687:odbc_process_tokens: returning result_type 4040
convert_tds2sql.c:292:odbc_tds2sql: src is 231 dest = 1
odbc.c:4268:SQLCloseCursor(0x613000000580)
odbc.c:4166:_SQLFreeStmt(0x613000000580, 0, 0)
query.c:2128:tds_send_cancel: not in_cancel and not idle
query.c:2174:tds_send_cancel: sending cancel packet
packet.c:801:Sending packet
0000 06 01 00 08 00 00 01 00- |........|
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffccac487cc, (nil), 0x0)
util.c:165:Changed query state from PENDING to READING
token.c:568:processing result tokens. marker is fd(DONE)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2113: rows_affected = 1
packet.c:435:Received packet
0000 04 01 00 15 00 33 01 00-fd 20 00 fd 00 00 00 00 |.....3.. . ......|
0010 00 00 00 00 00 - |.....|
token.c:568:processing result tokens. marker is fd(DONE)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 1
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
odbc.c:4063:SQLFreeHandle(3, 0x613000000580)
odbc.c:4166:_SQLFreeStmt(0x613000000580, 1, 0)
odbc.c:1529:SQLAllocHandle(3, 0x619000000580, 0x6110000132c0)
odbc.c:1704:_SQLAllocStmt(0x619000000580, 0x6110000132c0)
odbc.c:4063:SQLFreeHandle(3, 0x613000000740)
odbc.c:4166:_SQLFreeStmt(0x613000000740, 1, 0)
odbc.c:1529:SQLAllocHandle(3, 0x619000000580, 0x6110000132c0)
odbc.c:1704:_SQLAllocStmt(0x619000000580, 0x6110000132c0)
odbc.c:6720:SQLSetStmtAttr(0x613000000900, -1, (nil), -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000000900, -1, (nil), -5)
odbc.c:6720:SQLSetStmtAttr(0x613000000900, -2, 0x1, -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000000900, -2, 0x1, -5)
odbc_export.h:815:SQLExecDirect(0x613000000900, select col1 from mytab2, -3)
prepare_query.c:202:parsing 0 parameters
odbc.c:3273:_SQLExecute(0x613000000900)
odbc.c:3290:_SQLExecute() starting with state 0
query.c:2338:tds_cursor_declare() cursor id = 0
query.c:2385:tds_cursor_open() cursor id = 0
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
query.c:2512:tds_cursor_open (): RPC call set up
query.c:2516:tds_cursor_open (): cursor open completed
packet.c:801:Sending packet
0000 03 01 00 86 00 00 01 00-16 00 00 00 12 00 00 00 |........ ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........|
0020 02 00 00 00 00 01 26 04-00 00 00 63 32 00 00 00 |......&. ...c2...|
0030 09 04 d0 24 00 32 00 00-00 73 00 65 00 6c 00 65 |...$.2.. .s.e.l.e|
0040 00 63 00 74 00 20 00 63-00 6f 00 6c 00 31 00 20 |.c.t. .c .o.l.1. |
0050 00 66 00 72 00 6f 00 6d-00 20 00 20 00 20 00 6d |.f.r.o.m . . . .m|
0060 00 79 00 74 00 61 00 62-00 32 00 00 01 26 04 04 |.y.t.a.b .2...&..|
0070 08 00 00 00 00 01 26 04-04 01 20 00 00 00 01 26 |......&. .. ....&|
0080 04 04 00 00 00 00 - |......|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffccac49f78, 0x7ffccac49f7c, 0x6900)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 ba 00 33 01 00-81 02 00 00 00 00 00 09 |.....3.. ........|
0010 00 af 0a 00 09 04 d0 00-00 04 63 00 6f 00 6c 00 |........ ..c.o.l.|
0020 31 00 00 00 00 00 00 00-38 07 52 00 4f 00 57 00 |1....... 8.R.O.W.|
0030 53 00 54 00 41 00 54 00-a4 0f 00 01 06 00 6d 00 |S.T.A.T. ......m.|
0040 79 00 74 00 61 00 62 00-32 00 a5 06 00 01 01 00 |y.t.a.b. 2.......|
0050 02 00 14 ff 11 00 c1 00-00 00 00 00 00 00 00 00 |........ ........|
0060 79 00 00 00 00 ac 00 00-00 01 00 00 00 00 00 00 |y....... ........|
0070 26 04 04 f3 de bc 0a ac-02 00 00 01 00 00 00 00 |&....... ........|
0080 00 00 26 04 04 08 00 00-00 ac 03 00 00 01 00 00 |..&..... ........|
0090 00 00 00 00 26 04 04 01-00 00 00 ac 04 00 00 01 |....&... ........|
00a0 00 00 00 00 00 00 26 04-04 01 00 00 00 fe 00 00 |......&. ........|
00b0 e0 00 00 00 00 00 00 00-00 00 |........ ..|
token.c:568:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1572:processing TDS7 result metadata.
mem.c:656:tds_free_all_results()
token.c:1594:set current_results to cursor->res_info
token.c:1604:setting up 2 columns
token.c:1541:tds7_get_data_info:
colname = col1
type = 47 (char)
server's type = 175 (xchar)
column_varint_size = 2
column_size = 10 (10 on server)
token.c:1541:tds7_get_data_info:
colname = ROWSTAT
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1613: name size/wsize type/wtype utype
token.c:1614: -------------------- --------------- --------------- -------
token.c:1619: col1 10/10 47/175 0
token.c:1619: ROWSTAT 4/4 56/56 0
token.c:568:processing result tokens. marker is ff(DONEINPROC)
token.c:2094:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2113: rows_affected = 0
token.c:568:processing result tokens. marker is 79(RETURNSTATUS)
token.c:568:processing result tokens. marker is ac(PARAM)
token.c:617:processing parameters for op 2
token.c:619:calling tds_process_param_result
token.c:1303:tds_process_param_result(0x6120000007c0, 0x7ffccac49ef8)
token.c:1645:tds_get_data_info(0x6120000007c0, 0x610000000b40, 1) [for parameter]
token.c:1707:processing result. type = 38(integer-null), varint_size 1
token.c:1712:processing result. column_size 4
data.c:717:tds_get_data: type 38, varint size 1
data.c:761:tds_get_data(): wire column size is 4
log.c:443:type integer-null has value 180150003
token.c:619:calling tds_process_param_result
token.c:1303:tds_process_param_result(0x6120000007c0, 0x7ffccac49ef8)
token.c:1645:tds_get_data_info(0x6120000007c0, 0x610000000c40, 1) [for parameter]
token.c:1707:processing result. type = 38(integer-null), varint_size 1
token.c:1712:processing result. column_size 4
data.c:717:tds_get_data: type 38, varint size 1
data.c:761:tds_get_data(): wire column size is 4
log.c:443:type integer-null has value 8
token.c:619:calling tds_process_param_result
token.c:1303:tds_process_param_result(0x6120000007c0, 0x7ffccac49ef8)
token.c:1645:tds_get_data_info(0x6120000007c0, 0x610000000d40, 1) [for parameter]
token.c:1707:processing result. type = 38(integer-null), varint_size 1
token.c:1712:processing result. column_size 4
data.c:717:tds_get_data: type 38, varint size 1
data.c:761:tds_get_data(): wire column size is 4
log.c:443:type integer-null has value 1
token.c:619:calling tds_process_param_result
token.c:1303:tds_process_param_result(0x6120000007c0, 0x7ffccac49ef8)
token.c:1645:tds_get_data_info(0x6120000007c0, 0x610000000e40, 1) [for parameter]
token.c:1707:processing result. type = 38(integer-null), varint_size 1
token.c:1712:processing result. column_size 4
data.c:717:tds_get_data: type 38, varint size 1
data.c:761:tds_get_data(): wire column size is 4
log.c:443:type integer-null has value 1
token.c:625:4 hidden return parameters
token.c:632:stored internal cursor id 180150003
token.c:568:processing result tokens. marker is fe(DONEPROC)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3615: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3660:odbc_process_tokens: processed TDS_DONE_RESULT
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffccac49f78, 0x7ffccac49f7c, 0x26900)
token.c:556:tds_process_tokens() state is COMPLETED
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3615: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
query.c:2885:tds_cursor_setname() cursor id = 180150003
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
packet.c:801:Sending packet
0000 03 01 00 55 00 00 01 00-16 00 00 00 12 00 00 00 |...U.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........|
0020 08 00 00 00 00 00 26 04-04 f3 de bc 0a 00 00 26 |......&. .......&|
0030 04 04 02 00 00 00 00 00-a7 13 00 09 04 d0 24 00 |........ ......$.|
0040 13 00 53 51 4c 5f 43 55-52 36 31 33 30 30 30 30 |..SQL_CU R6130000|
0050 30 30 39 30 30 - |00900|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffccac49f78, 0x7ffccac49f7c, 0x6914)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 1a 00 33 01 00-79 00 00 00 00 fe 00 00 |.....3.. y.......|
0010 e0 00 00 00 00 00 00 00-00 00 |........ ..|
token.c:568:processing result tokens. marker is 79(RETURNSTATUS)
token.c:568:processing result tokens. marker is fe(DONEPROC)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
odbc.c:3614:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3615: result_type=1, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3436:_SQLExecute: odbc_process_tokens returned result_type 4046
odbc.c:4531:SQLNumResultCols(0x613000000900, 0x7ffccac4a090)
odbc_export.h:556:SQLDescribeCol(0x613000000900, 1, (nil), 0, 0x7ffccac49f60, 0x7ffccac49fa0, 0x7ffccac4a060, 0x7ffccac49fe0, 0x7ffccac4a020)
odbc.c:6720:SQLSetStmtAttr(0x613000000900, 5, (nil), -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000000900, 5, (nil), -5)
odbc.c:6720:SQLSetStmtAttr(0x613000000900, 27, 0xa, -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000000900, 27, 0xa, -5)
odbc.c:6720:SQLSetStmtAttr(0x613000000900, 26, 0x611000013308, -5)
odbc.c:6419:_SQLSetStmtAttr(0x613000000900, 26, 0x611000013308, -5)
odbc_export.h:556:SQLDescribeCol(0x613000000900, 1, (nil), 0, 0x7ffccac49fa0, 0x606000006c98, 0x7ffccac4a060, 0x7ffccac49fe0, 0x7ffccac4a020)
odbc.c:1824:SQLBindCol(0x613000000900, 1, 1, 0x6120000010c0, 31, 0x607000003c80)
odbc.c:4268:SQLCloseCursor(0x613000000900)
odbc.c:4166:_SQLFreeStmt(0x613000000900, 0, 0)
query.c:2824:tds_cursor_close() cursor id = 180150003
mem.c:656:tds_free_all_results()
util.c:165:Changed query state from IDLE to WRITING
packet.c:801:Sending packet
0000 03 01 00 2d 00 00 01 00-16 00 00 00 12 00 00 00 |...-.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........|
0020 09 00 02 00 00 00 26 04-04 f3 de bc 0a |......&. .....|
util.c:165:Changed query state from WRITING to PENDING
token.c:553:tds_process_tokens(0x6120000007c0, 0x7ffccac4a028, 0x7ffccac4a02c, 0x100)
util.c:165:Changed query state from PENDING to READING
packet.c:435:Received packet
0000 04 01 00 1a 00 33 01 00-79 00 00 00 00 fe 00 00 |.....3.. y.......|
0010 e0 00 00 00 00 00 00 00-00 00 |........ ..|
token.c:568:processing result tokens. marker is 79(RETURNSTATUS)
token.c:568:processing result tokens. marker is fe(DONEPROC)
token.c:2094:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2113: rows_affected = 0
token.c:2116:tds_process_end() state set to TDS_IDLE
util.c:165:Changed query state from READING to IDLE
token.c:772:TDS_OP_CURSORCLOSE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:165:Changed query state from IDLE to IDLE
mem.c:918:tds_cursor_deallocated() : freeing cursor_id 180150003
odbc.c:4063:SQLFreeHandle(3, 0x613000000900)
odbc.c:4166:_SQLFreeStmt(0x613000000900, 1, 0)
odbc.c:2332:SQLDisconnect(0x619000000580)
query.c:3783:tds_disconnect()
util.c:165:Changed query state from IDLE to DEAD
mem.c:949:tds_release_cursor() : freeing cursor_id 180150003
mem.c:951:tds_release_cursor() : freeing cursor results
mem.c:956:tds_release_cursor() : freeing cursor name
mem.c:961:tds_release_cursor() : freeing cursor query
mem.c:965:tds_release_cursor() : cursor_id 180150003 freed
mem.c:656:tds_free_all_results()
odbc.c:4063:SQLFreeHandle(2, 0x619000000580)
odbc.c:4089:_SQLFreeConnect(0x619000000580)
bcp.c:673:_bcp_free_storage(0x619000000580)
-
[freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(),
Sebastien FLAESCH, 02/21/2019
-
Re: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(),
Frediano Ziglio, 02/27/2019
-
Re: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(),
Sebastien FLAESCH, 02/27/2019
-
Re: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(),
Craig Jackson, 02/27/2019
-
Re: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(),
Sebastien FLAESCH, 02/28/2019
-
Re: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(),
Frediano Ziglio, 02/28/2019
- Re: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(), Sebastien FLAESCH, 02/28/2019
-
Re: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(),
Frediano Ziglio, 02/28/2019
- Re: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(), Frediano Ziglio, 02/28/2019
-
Re: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(),
Frediano Ziglio, 02/28/2019
-
Re: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(),
Sebastien FLAESCH, 02/28/2019
-
Re: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(),
Craig Jackson, 02/27/2019
-
Re: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(),
Sebastien FLAESCH, 02/27/2019
- <Possible follow-up(s)>
-
[freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(),
Sebastien FLAESCH, 02/21/2019
- Re: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(), Frediano Ziglio, 02/22/2019
-
Re: [freetds] SQL Server 2019: CHAR(N) using UTF-8 is seen as SQL_NVARCHAR by SQLDescribeCol(),
Frediano Ziglio, 02/27/2019
Archive powered by MHonArc 2.6.24.