freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] FreeTDS, Perl, unicode

From: Brian Johnson <serversage AT gmail.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] FreeTDS, Perl, unicode
Date: Mon, 11 Mar 2013 04:31:41 -0700

Log file is attached.

I'll confess, this whole unicode thing is new to me so I'm not certain *how* to set the client encoding. Is there some docs anybody can recommend?

I'll give the other items you tried a shot when I get going in the morning.

Thanks for the assistance folks, much appreciated!

-Brian

James K. Lowden wrote:

On Mon, 11 Mar 2013 02:42:32 -0700
Brian Johnson<serversage AT gmail.com> wrote:

I don't see any user/pass info in it, so if needed I could attach the
log. Though I do see "SQLExecute returns SQL_SUCCESS".

You can post a log here. A TDS 7+ dump won't contain user
credentials.

You're sure the client encoding is set up correctly, and the Perl knows
what to expect?

Test other than TDSDUMP: Besides using Perl, you might try with
bsqldb, because if it behaves the same way you have either a setup
problem or a bug, and with sqsh, because sqsh also uses the ct-lib
API.

HTH.

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

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

net.c:555:Received header
0000 04 01 00 25 00 00 01 00- |...%....|

net.c:609:Received packet
0000 04 01 00 25 00 00 01 00-00 00 15 00 06 01 00 1b |...%.... ........|
0010 00 01 02 00 1c 00 01 03-00 1d 00 00 ff 0a 32 07 |........ ......2.|
0020 05 00 00 00 00 - |.....|

login.c:1057:detected flag 0
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Allocating epoch #0
net.c:1257:GNUTLS: level 2:
ASSERT: gnutls_constate.c:695
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Allocating epoch #1
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Keeping ciphersuite: RSA_AES_256_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Keeping ciphersuite: RSA_AES_128_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Keeping ciphersuite: RSA_3DES_EDE_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Keeping ciphersuite: RSA_ARCFOUR_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Keeping ciphersuite: RSA_ARCFOUR_MD5
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Keeping ciphersuite: DHE_DSS_AES_256_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Keeping ciphersuite: DHE_DSS_AES_128_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Keeping ciphersuite: DHE_DSS_3DES_EDE_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Keeping ciphersuite: DHE_DSS_ARCFOUR_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Keeping ciphersuite: DHE_RSA_AES_256_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Keeping ciphersuite: DHE_RSA_AES_128_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Keeping ciphersuite: DHE_RSA_3DES_EDE_CBC_SHA1
net.c:1257:GNUTLS: level 2:
EXT[0x90ec410]: Sending extension SAFE RENEGOTIATION (1 bytes)
net.c:1257:GNUTLS: level 2:
EXT[SIGA]: sent signature algo (4.2) DSA-SHA256
net.c:1257:GNUTLS: level 2:
EXT[SIGA]: sent signature algo (4.1) RSA-SHA256
net.c:1257:GNUTLS: level 2:
EXT[SIGA]: sent signature algo (2.1) RSA-SHA1
net.c:1257:GNUTLS: level 2:
EXT[SIGA]: sent signature algo (2.2) DSA-SHA1
net.c:1257:GNUTLS: level 2:
EXT[0x90ec410]: Sending extension SIGNATURE ALGORITHMS (10 bytes)
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: CLIENT HELLO was sent [88 bytes]
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 88 bytes of Data
net.c:1257:GNUTLS: level 7:
HWRITE: enqueued 88. Total 88 bytes.
net.c:1257:GNUTLS: level 7:
HWRITE FLUSH: 88 bytes in buffer.
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Sending Packet[0] Handshake(22) with length: 88
net.c:1257:GNUTLS: level 7:
WRITE: enqueued 93 bytes for 0x90c0f70. Total 93 bytes.
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Sent Packet[1] Handshake(22) with length: 93
net.c:1257:GNUTLS: level 7:
HWRITE: wrote 88 bytes, 0 bytes left.
net.c:1257:GNUTLS: level 7:
WRITE FLUSH: 93 bytes in buffer.
net.c:1240:in tds_push_func
net.c:1257:GNUTLS: level 7:
WRITE: wrote 93 bytes, 0 bytes left.
net.c:1199:in tds_pull_func
net.c:741:Sending packet
0000 12 01 00 65 00 00 00 00-16 03 00 00 58 01 00 00 |...e.... ....X...|
0010 54 03 03 51 3d a5 6d 58-e4 58 c7 af f7 17 bf f2 |T..Q=.mX .X......|
0020 af 23 64 82 04 07 56 42-23 1d 56 fe 3b bd ad 19 |.#d...VB #.V.;...|
0030 a5 32 d5 00 00 18 00 35-00 2f 00 0a 00 05 00 04 |.2.....5 ./......|
0040 00 38 00 32 00 13 00 66-00 39 00 33 00 16 01 00 |.8.2...f .9.3....|
0050 00 13 ff 01 00 01 00 00-0d 00 0a 00 08 04 02 04 |........ ........|
0060 01 02 01 02 02 - |.....|

net.c:1212:have 0
net.c:1216:before read
net.c:555:Received header
0000 12 01 02 69 00 00 00 00- |...i....|

net.c:609:Received packet
0000 12 01 02 69 00 00 00 00-16 03 01 02 5c 02 00 00 |...i.... ....\...|
0010 4d 03 01 51 3d a5 6d 17-1a fe 36 53 7a cc 08 99 |M..Q=.m. ..6Sz...|
0020 4c 64 34 72 b4 4f 0f ec-6c f4 bc 9f c7 06 91 67 |Ld4r.O.. l......g|
0030 bd 89 24 20 f4 02 00 00-4a a5 36 10 d8 5a 40 14 |..$ .... J.6..Z@.|
0040 d8 dd 6a 35 c1 57 d1 24-48 2d 51 4b e1 6f a9 1e |..j5.W.$ H-QK.o..|
0050 a3 47 df 10 00 2f 00 00-05 ff 01 00 01 00 0b 00 |.G.../.. ........|
0060 02 03 00 02 00 00 01 fd-30 82 01 f9 30 82 01 62 |........ 0...0..b|
0070 a0 03 02 01 02 02 10 61-5d d1 2a e5 6b fd a1 4a |.......a ].*.k..J|
0080 41 36 ba be 93 24 d9 30-0d 06 09 2a 86 48 86 f7 |A6...$.0 ...*.H..|
0090 0d 01 01 05 05 00 30 3b-31 39 30 37 06 03 55 04 |......0; 1907..U.|
00a0 03 1e 30 00 53 00 53 00-4c 00 5f 00 53 00 65 00 |..0.S.S. L._.S.e.|
00b0 6c 00 66 00 5f 00 53 00-69 00 67 00 6e 00 65 00 |l.f._.S. i.g.n.e.|
00c0 64 00 5f 00 46 00 61 00-6c 00 6c 00 62 00 61 00 |d._.F.a. l.l.b.a.|
00d0 63 00 6b 30 1e 17 0d 31-33 30 31 31 39 32 30 30 |c.k0...1 30119200|
00e0 35 35 37 5a 17 0d 34 33-30 31 31 39 32 30 30 35 |557Z..43 01192005|
00f0 35 37 5a 30 3b 31 39 30-37 06 03 55 04 03 1e 30 |57Z0;190 7..U...0|
0100 00 53 00 53 00 4c 00 5f-00 53 00 65 00 6c 00 66 |.S.S.L._ .S.e.l.f|
0110 00 5f 00 53 00 69 00 67-00 6e 00 65 00 64 00 5f |._.S.i.g .n.e.d._|
0120 00 46 00 61 00 6c 00 6c-00 62 00 61 00 63 00 6b |.F.a.l.l .b.a.c.k|
0130 30 81 9f 30 0d 06 09 2a-86 48 86 f7 0d 01 01 01 |0..0...* .H......|
0140 05 00 03 81 8d 00 30 81-89 02 81 81 00 b3 df 3a |......0. .......:|
0150 11 59 24 a0 d6 55 c3 d1-1e 4c 86 4e c7 f9 fb 96 |.Y$..U.. .L.N....|
0160 7e 71 9b f2 53 7a b0 1c-32 78 39 4a 1d e2 26 e0 |~q..Sz.. 2x9J..&.|
0170 c0 c9 84 f8 77 ba 07 37-ef 64 9b ee aa 33 7b 24 |....w..7 .d...3{$|
0180 e2 2b d0 fe 90 8a 37 6b-fa b2 86 86 54 45 3d ca |.+....7k ....TE=.|
0190 f9 df a1 74 9f 99 6b 43-b9 02 15 19 3e e1 fd d2 |...t..kC ....>...|
01a0 b3 d8 62 73 d6 31 a2 3b-51 17 a7 9a 45 20 e2 07 |..bs.1.; Q...E ..|
01b0 93 55 18 6b 0b f5 84 c3-7b 30 1f 55 56 92 03 c1 |.U.k.... {0.UV...|
01c0 1e 94 b2 bd 0b d4 c0 a2-40 c2 2e c2 99 02 03 01 |........ @.......|
01d0 00 01 30 0d 06 09 2a 86-48 86 f7 0d 01 01 05 05 |..0...*. H.......|
01e0 00 03 81 81 00 1e 0f bd-f8 38 42 a0 76 d9 63 10 |........ .8B.v.c.|
01f0 f2 b7 fa 05 99 89 1c c3-78 33 1c c0 a0 11 e0 4e |........ x3.....N|
0200 5a f7 96 7f 40 98 6b fb-b7 23 fb a2 53 c3 ad 1f |Z...@.k. .#..S...|
0210 44 d7 4e 77 65 b2 80 e1-bd 39 a7 b0 0c 3a eb 44 |D.Nwe... .9...:.D|
0220 1a cf f1 0f f1 55 77 7f-d6 b6 6c 5c 71 3f 44 2c |.....Uw. ..l\q?D,|
0230 57 10 f4 29 44 c6 12 51-02 57 6a 38 9b d9 8d ac |W..)D..Q .Wj8....|
0240 19 7c d2 01 96 da ff 28-73 8b 32 0b d4 f1 34 64 |.|.....( s.2...4d|
0250 b6 73 6d b9 23 04 9f 2d-05 25 90 c6 60 7d cf 50 |.sm.#..- .%..`}.P|
0260 44 05 0c 27 85 0e 00 00-00 |D..'.... .|

net.c:1219:after read
net.c:1212:have 609
net.c:1223:read 5 bytes
net.c:1257:GNUTLS: level 7:
READ: Got 5 bytes from 0x90c0f70
net.c:1257:GNUTLS: level 7:
READ: read 5 bytes from 0x90c0f70
net.c:1257:GNUTLS: level 7:
RB: Have 0 bytes into buffer. Adding 5 bytes.
net.c:1257:GNUTLS: level 7:
RB: Requested 5 bytes
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Expected Packet[0] Handshake(22) with length: 1
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Received Packet[0] Handshake(22) with length: 604
net.c:1199:in tds_pull_func
net.c:1212:have 604
net.c:1223:read 604 bytes
net.c:1257:GNUTLS: level 7:
READ: Got 604 bytes from 0x90c0f70
net.c:1257:GNUTLS: level 7:
READ: read 604 bytes from 0x90c0f70
net.c:1257:GNUTLS: level 7:
RB: Have 5 bytes into buffer. Adding 604 bytes.
net.c:1257:GNUTLS: level 7:
RB: Requested 609 bytes
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Decrypted Packet[0] Handshake(22) with length: 604
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 604 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 1 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 3 bytes of Data(22)
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: SERVER HELLO was received [81 bytes]
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 77 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 4 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 77 bytes of Data
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Server's version: 3.1
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: SessionID length: 32
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: SessionID:
f40200004aa53610d85a4014d8dd6a35c157d124482d514be16fa91ea347df10
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Selected cipher suite: RSA_AES_128_CBC_SHA1
net.c:1257:GNUTLS: level 2:
EXT[0x90ec410]: Parsing extension 'SAFE RENEGOTIATION/65281' (1 bytes)
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Safe renegotiation succeeded
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 1 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 3 bytes of Data(22)
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: CERTIFICATE was received [519 bytes]
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 515 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Peeked 169 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 4 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 515 bytes of Data
net.c:1257:GNUTLS: level 2:
ASSERT: ext_signature.c:388
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 1 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 3 bytes of Data(22)
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: SERVER HELLO DONE was received [4 bytes]
net.c:1257:GNUTLS: level 2:
ASSERT: gnutls_handshake.c:1369
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Peeked 519 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 4 bytes of Data
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: CLIENT KEY EXCHANGE was sent [134 bytes]
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Peeked 4 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1257:GNUTLS: level 7:
HWRITE: enqueued 134. Total 134 bytes.
net.c:1257:GNUTLS: level 7:
HWRITE FLUSH: 134 bytes in buffer.
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Sending Packet[1] Handshake(22) with length: 134
net.c:1257:GNUTLS: level 7:
WRITE: enqueued 139 bytes for 0x90c0f70. Total 139 bytes.
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Sent Packet[2] Handshake(22) with length: 139
net.c:1257:GNUTLS: level 7:
HWRITE: wrote 134 bytes, 0 bytes left.
net.c:1257:GNUTLS: level 7:
WRITE FLUSH: 139 bytes in buffer.
net.c:1240:in tds_push_func
net.c:1257:GNUTLS: level 7:
WRITE: wrote 139 bytes, 0 bytes left.
net.c:1257:GNUTLS: level 3:
REC[0x90ec410]: Sent ChangeCipherSpec
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Sending Packet[2] Change Cipher Spec(20) with length: 1
net.c:1257:GNUTLS: level 7:
WRITE: enqueued 6 bytes for 0x90c0f70. Total 6 bytes.
net.c:1257:GNUTLS: level 7:
WRITE FLUSH: 6 bytes in buffer.
net.c:1240:in tds_push_func
net.c:1257:GNUTLS: level 7:
WRITE: wrote 6 bytes, 0 bytes left.
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Sent Packet[3] Change Cipher Spec(20) with length: 6
net.c:1257:GNUTLS: level 9:
INT: PREMASTER SECRET[48]:
0303c0c6afca00c6243bbc9be728305c0ce78f8f6cdf41c381678aa3045034425f1086b2998d8a08d1702606e947a165
net.c:1257:GNUTLS: level 9:
INT: CLIENT RANDOM[32]:
513da56d58e458c7aff717bff2af23648204075642231d56fe3bbdad19a532d5
net.c:1257:GNUTLS: level 9:
INT: SERVER RANDOM[32]:
513da56d171afe36537acc08994c643472b44f0fec6cf4bc9fc7069167bd8924
net.c:1257:GNUTLS: level 9:
INT: MASTER SECRET:
4153637b82ffa0a76d81e9d011b21efbe51a126053258499cac9e9a2f7f12940f0c46c9645132fa503974271e81839ac
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Initializing epoch #1
net.c:1257:GNUTLS: level 9:
INT: KEY BLOCK[104]:
02de2324a1db8d0ec5483c25cacf66f55bb72e6a9e380ef96d848a502cdf5271
net.c:1257:GNUTLS: level 9:
INT: CLIENT WRITE KEY [16]: 1d968c744899b44de0681227acd8dbc3
net.c:1257:GNUTLS: level 9:
INT: SERVER WRITE KEY [16]: fd162bc34cf1a26aeb5b74e9428eebe0
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Epoch #1 ready
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Cipher Suite: RSA_AES_128_CBC_SHA1
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Initializing internal [write] cipher sessions
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Start of epoch cleanup
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: End of epoch cleanup
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Peeked 0 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: recording tls-unique CB (send)
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: FINISHED was sent [16 bytes]
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Peeked 0 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1257:GNUTLS: level 7:
HWRITE: enqueued 16. Total 16 bytes.
net.c:1257:GNUTLS: level 7:
HWRITE FLUSH: 16 bytes in buffer.
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Sending Packet[0] Handshake(22) with length: 16
net.c:1257:GNUTLS: level 7:
WRITE: enqueued 53 bytes for 0x90c0f70. Total 53 bytes.
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Sent Packet[1] Handshake(22) with length: 53
net.c:1257:GNUTLS: level 7:
HWRITE: wrote 16 bytes, 0 bytes left.
net.c:1257:GNUTLS: level 7:
WRITE FLUSH: 53 bytes in buffer.
net.c:1240:in tds_push_func
net.c:1257:GNUTLS: level 7:
WRITE: wrote 53 bytes, 0 bytes left.
net.c:1257:GNUTLS: level 2:
ASSERT: ext_session_ticket.c:710
net.c:1199:in tds_pull_func
net.c:741:Sending packet
0000 12 01 00 ce 00 00 00 00-16 03 01 00 86 10 00 00 |........ ........|
0010 82 00 80 a0 6e fe 85 25-95 76 d8 7f e7 56 bb 48 |....n..% .v...V.H|
0020 45 db 25 f3 b9 25 59 71-62 43 45 2a e3 bc f1 45 |E.%..%Yq bCE*...E|
0030 8f a1 14 a2 8a 8b 2a 07-4e 0b eb c4 9a 45 6f 49 |......*. N....EoI|
0040 75 51 34 a4 8c 5f 13 8e-5a cb 38 ec 80 dd 2d fd |uQ4.._.. Z.8...-.|
0050 8a d3 7b 63 c7 7e ed 69-03 92 18 60 de 16 36 f6 |..{c.~.i ...`..6.|
0060 08 71 cb 0d fc a4 d7 cb-39 1b 6f 4e d1 9d 77 9c |.q...... 9.oN..w.|
0070 35 19 c9 f8 71 74 7c 11-d5 42 e4 77 dc af d2 e6 |5...qt|. .B.w....|
0080 04 37 92 88 a5 c3 1c ce-31 b9 46 43 b4 a2 33 df |.7...... 1.FC..3.|
0090 43 9e 37 14 03 01 00 01-01 16 03 01 00 30 88 c9 |C.7..... .....0..|
00a0 d8 ff 53 89 42 8f f4 ad-13 a8 f6 4c c3 c5 5f e0 |..S.B... ...L.._.|
00b0 6d 4d 3c 65 ab 02 e5 2e-cc 87 37 c1 c1 69 c1 59 |mM<e.... ..7..i.Y|
00c0 ce a8 79 e6 92 35 48 a9-de a1 e6 46 99 f2 |..y..5H. ...F..|

net.c:1212:have 0
net.c:1216:before read
net.c:555:Received header
0000 12 01 00 43 00 00 00 00- |...C....|

net.c:609:Received packet
0000 12 01 00 43 00 00 00 00-14 03 01 00 01 01 16 03 |...C.... ........|
0010 01 00 30 4a 3d f5 38 8b-fc 53 04 9e 1e 96 03 d7 |..0J=.8. .S......|
0020 ea d0 58 c1 2a c5 57 6d-6a 42 bf 4d 84 3f ff b0 |..X.*.Wm jB.M.?..|
0030 24 d0 56 98 c5 e6 5f ea-65 50 1a b9 59 5d 93 5c |$.V..._. eP..Y].\|
0040 eb 80 86 - |...|

net.c:1219:after read
net.c:1212:have 59
net.c:1223:read 5 bytes
net.c:1257:GNUTLS: level 7:
READ: Got 5 bytes from 0x90c0f70
net.c:1257:GNUTLS: level 7:
READ: read 5 bytes from 0x90c0f70
net.c:1257:GNUTLS: level 7:
RB: Have 0 bytes into buffer. Adding 5 bytes.
net.c:1257:GNUTLS: level 7:
RB: Requested 5 bytes
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Expected Packet[1] Change Cipher Spec(20) with length: 1
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Received Packet[1] Change Cipher Spec(20) with length: 1
net.c:1199:in tds_pull_func
net.c:1212:have 54
net.c:1223:read 1 bytes
net.c:1257:GNUTLS: level 7:
READ: Got 1 bytes from 0x90c0f70
net.c:1257:GNUTLS: level 7:
READ: read 1 bytes from 0x90c0f70
net.c:1257:GNUTLS: level 7:
RB: Have 5 bytes into buffer. Adding 1 bytes.
net.c:1257:GNUTLS: level 7:
RB: Requested 6 bytes
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: ChangeCipherSpec Packet was received
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: Cipher Suite: RSA_AES_128_CBC_SHA1
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Start of epoch cleanup
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Epoch #0 freed
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: End of epoch cleanup
net.c:1199:in tds_pull_func
net.c:1212:have 53
net.c:1223:read 5 bytes
net.c:1257:GNUTLS: level 7:
READ: Got 5 bytes from 0x90c0f70
net.c:1257:GNUTLS: level 7:
READ: read 5 bytes from 0x90c0f70
net.c:1257:GNUTLS: level 7:
RB: Have 0 bytes into buffer. Adding 5 bytes.
net.c:1257:GNUTLS: level 7:
RB: Requested 5 bytes
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Expected Packet[0] Handshake(22) with length: 1
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Received Packet[0] Handshake(22) with length: 48
net.c:1199:in tds_pull_func
net.c:1212:have 48
net.c:1223:read 48 bytes
net.c:1257:GNUTLS: level 7:
READ: Got 48 bytes from 0x90c0f70
net.c:1257:GNUTLS: level 7:
READ: read 48 bytes from 0x90c0f70
net.c:1257:GNUTLS: level 7:
RB: Have 5 bytes into buffer. Adding 48 bytes.
net.c:1257:GNUTLS: level 7:
RB: Requested 53 bytes
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Decrypted Packet[0] Handshake(22) with length: 16
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 16 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 1 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 3 bytes of Data(22)
net.c:1257:GNUTLS: level 3:
HSK[0x90ec410]: FINISHED was received [16 bytes]
net.c:1257:GNUTLS: level 6:
BUF[REC][HD]: Read 12 bytes of Data(22)
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Peeked 0 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 4 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Inserted 12 bytes of Data
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Cleared Data from buffer
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Cleared Data from buffer
net.c:1370:handshake succeeded!!
login.c:782:quietly sending TDS 7+ login packet
net.c:1257:GNUTLS: level 6:
BUF[HSK]: Cleared Data from buffer
net.c:1257:GNUTLS: level 4:
REC[0x90ec410]: Epoch #1 freed
token.c:328:tds_process_login_tokens()
net.c:555:Received header
0000 04 01 01 85 00 41 01 00- |.....A..|

net.c:609:Received packet
0000 04 01 01 85 00 41 01 00-e3 21 00 01 09 76 00 61 |.....A.. .!...v.a|
0010 00 72 00 69 00 61 00 6e-00 65 00 6e 00 6d 00 06 |.r.i.a.n .e.n.m..|
0020 6d 00 61 00 73 00 74 00-65 00 72 00 ab 6c 00 45 |m.a.s.t. e.r..l.E|
0030 16 00 00 02 00 28 00 43-00 68 00 61 00 6e 00 67 |.....(.C .h.a.n.g|
0040 00 65 00 64 00 20 00 64-00 61 00 74 00 61 00 62 |.e.d. .d .a.t.a.b|
0050 00 61 00 73 00 65 00 20-00 63 00 6f 00 6e 00 74 |.a.s.e. .c.o.n.t|
0060 00 65 00 78 00 74 00 20-00 74 00 6f 00 20 00 27 |.e.x.t. .t.o. .'|
0070 00 76 00 61 00 72 00 69-00 61 00 6e 00 65 00 6e |.v.a.r.i .a.n.e.n|
0080 00 6d 00 27 00 2e 00 08-56 00 41 00 52 00 49 00 |.m.'.... V.A.R.I.|
0090 41 00 4e 00 44 00 42 00-00 01 00 e3 08 00 07 05 |A.N.D.B. ........|
00a0 09 04 00 02 00 00 e3 17-00 02 0a 75 00 73 00 5f |........ ...u.s._|
00b0 00 65 00 6e 00 67 00 6c-00 69 00 73 00 68 00 00 |.e.n.g.l .i.s.h..|
00c0 ab 6a 00 47 16 00 00 01-00 27 00 43 00 68 00 61 |.j.G.... .'.C.h.a|
00d0 00 6e 00 67 00 65 00 64-00 20 00 6c 00 61 00 6e |.n.g.e.d . .l.a.n|
00e0 00 67 00 75 00 61 00 67-00 65 00 20 00 73 00 65 |.g.u.a.g .e. .s.e|
00f0 00 74 00 74 00 69 00 6e-00 67 00 20 00 74 00 6f |.t.t.i.n .g. .t.o|
0100 00 20 00 75 00 73 00 5f-00 65 00 6e 00 67 00 6c |. .u.s._ .e.n.g.l|
0110 00 69 00 73 00 68 00 2e-00 08 56 00 41 00 52 00 |.i.s.h.. ..V.A.R.|
0120 49 00 41 00 4e 00 44 00-42 00 00 01 00 ad 36 00 |I.A.N.D. B.....6.|
0130 01 71 00 00 01 16 4d 00-69 00 63 00 72 00 6f 00 |.q....M. i.c.r.o.|
0140 73 00 6f 00 66 00 74 00-20 00 53 00 51 00 4c 00 |s.o.f.t. .S.Q.L.|
0150 20 00 53 00 65 00 72 00-76 00 65 00 72 00 00 00 | .S.e.r. v.e.r...|
0160 00 00 0a 32 07 05 e3 13-00 04 04 34 00 30 00 39 |...2.... ...4.0.9|
0170 00 36 00 04 34 00 30 00-39 00 36 00 fd 00 00 00 |.6..4.0. 9.6.....|
0180 00 00 00 00 00 - |.....|

token.c:337:looking for login token, got e3(ENVCHANGE)
token.c:122:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:337:looking for login token, got ab(INFO)
token.c:122:tds_process_default_tokens() marker is ab(INFO)
token.c:2588:tds_process_msg() reading message 5701 from server
token.c:2661:tds_process_msg() calling client msg handler
odbc.c:2270:msgno 5701 20003
token.c:2674:tds_process_msg() returning TDS_SUCCEED
token.c:337:looking for login token, got e3(ENVCHANGE)
token.c:122:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2419:tds_process_env_chg(): 5 bytes of collation data received
token.c:2420:tds->collation was
0000 00 00 00 00 00 - |.....|

iconv.c:988:setting server single-byte charset to "CP1252"
token.c:2430:tds->collation now
0000 09 04 00 02 00 - |.....|

token.c:337:looking for login token, got e3(ENVCHANGE)
token.c:122:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:337:looking for login token, got ab(INFO)
token.c:122:tds_process_default_tokens() marker is ab(INFO)
token.c:2588:tds_process_msg() reading message 5703 from server
token.c:2661:tds_process_msg() calling client msg handler
odbc.c:2270:msgno 5703 20003
token.c:2674:tds_process_msg() returning TDS_SUCCEED
token.c:337:looking for login token, got ad(LOGINACK)
token.c:373:server reports TDS version 71.0.0.1
token.c:375:Product name for 0x71000001 is 2000 SP1
token.c:337:looking for login token, got e3(ENVCHANGE)
token.c:122:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2477:changing block size from 4096 to 4096
token.c:337:looking for login token, got fd(DONE)
token.c:122:tds_process_default_tokens() marker is fd(DONE)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2355:tds_process_end() state set to TDS_IDLE
token.c:2370: rows_affected = 0
token.c:438:tds_process_login_tokens() returning TDS_SUCCEED
odbc.c:4916:SQLGetFunctions: fFunction is 999
odbc.c:5831:SQLGetInfo(0x90c0bf0, 77, 0xbfd91bec, 20, (nil))
odbc.c:5085:_SQLGetInfo(0x90c0bf0, 77, 0xbfd91bec, 20, (nil))
error.c:517:SQLGetDiagRec(2, 0x90c0bf0, 1, 0xbfd91746, 0xbfd91318,
0xbfd91546, 512, 0xbfd9131c)
odbc.c:6113:_SQLSetConnectAttr(0x90c0bf0, 102, 0x1, 0)
odbc.c:235:change_autocommit: executing SET IMPLICIT_TRANSACTIONS OFF
mem.c:615:tds_free_all_results()
util.c:156:Changed query state from IDLE to QUERYING
write.c:140:tds_put_string converting 29 bytes of "SET IMPLICIT_TRANSACTIONS
OFF"
write.c:168:tds_put_string wrote 58 bytes
util.c:156:Changed query state from QUERYING to PENDING
net.c:741:Sending packet
0000 01 01 00 42 00 00 01 00-53 00 45 00 54 00 20 00 |...B.... S.E.T. .|
0010 49 00 4d 00 50 00 4c 00-49 00 43 00 49 00 54 00 |I.M.P.L. I.C.I.T.|
0020 5f 00 54 00 52 00 41 00-4e 00 53 00 41 00 43 00 |_.T.R.A. N.S.A.C.|
0030 54 00 49 00 4f 00 4e 00-53 00 20 00 4f 00 46 00 |T.I.O.N. S. .O.F.|
0040 46 00 - |F.|

token.c:540:tds_process_tokens(0x90c0f70, 0xbfd94ba8, 0xbfd94bac, 0x100)
util.c:156:Changed query state from PENDING to READING
net.c:555:Received header
0000 04 01 00 11 00 41 01 00- |.....A..|

net.c:609:Received packet
0000 04 01 00 11 00 41 01 00-fd 00 00 ba 00 00 00 00 |.....A.. ........|
0010 00 - |.|

token.c:555:processing result tokens. marker is fd(DONE)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2355:tds_process_end() state set to TDS_IDLE
util.c:156:Changed query state from READING to IDLE
token.c:2370: rows_affected = 0
util.c:104:logic error: cannot change query state from IDLE to PENDING
token.c:540:tds_process_tokens(0x90c0f70, 0xbfd94ba8, 0xbfd94bac, 0x100)
token.c:543:tds_process_tokens() state is COMPLETED
odbc.c:5831:SQLGetInfo(0x90c0bf0, 77, 0x8fc9640, 20, 0xbfd94e78)
odbc.c:5085:_SQLGetInfo(0x90c0bf0, 77, 0x8fc9640, 20, 0xbfd94e78)
odbc.c:5831:SQLGetInfo(0x90c0bf0, 6, 0x8fc96b4, 80, 0xbfd94e78)
odbc.c:5085:_SQLGetInfo(0x90c0bf0, 6, 0x8fc96b4, 80, 0xbfd94e78)
odbc.c:5831:SQLGetInfo(0x90c0bf0, 7, 0x8fc9704, 20, 0xbfd94e78)
odbc.c:5085:_SQLGetInfo(0x90c0bf0, 7, 0x8fc9704, 20, 0xbfd94e78)
odbc.c:5831:SQLGetInfo(0x90c0bf0, 17, 0x8fc9718, 80, 0xbfd94e78)
odbc.c:5085:_SQLGetInfo(0x90c0bf0, 17, 0x8fc9718, 80, 0xbfd94e78)
odbc.c:5831:SQLGetInfo(0x90c0bf0, 18, 0x8fc9768, 80, 0xbfd94e78)
odbc.c:5085:_SQLGetInfo(0x90c0bf0, 18, 0x8fc9768, 80, 0xbfd94e78)
odbc.c:5831:SQLGetInfo(0x90c0bf0, 30, 0x8fc9654, 2, 0xbfd94e78)
odbc.c:5085:_SQLGetInfo(0x90c0bf0, 30, 0x8fc9654, 2, 0xbfd94e78)
odbc.c:6113:_SQLSetConnectAttr(0x90c0bf0, 102, 0x1, -5)
odbc.c:235:change_autocommit: executing SET IMPLICIT_TRANSACTIONS OFF
mem.c:615:tds_free_all_results()
util.c:156:Changed query state from IDLE to QUERYING
write.c:140:tds_put_string converting 29 bytes of "SET IMPLICIT_TRANSACTIONS
OFF"
write.c:168:tds_put_string wrote 58 bytes
util.c:156:Changed query state from QUERYING to PENDING
net.c:741:Sending packet
0000 01 01 00 42 00 00 01 00-53 00 45 00 54 00 20 00 |...B.... S.E.T. .|
0010 49 00 4d 00 50 00 4c 00-49 00 43 00 49 00 54 00 |I.M.P.L. I.C.I.T.|
0020 5f 00 54 00 52 00 41 00-4e 00 53 00 41 00 43 00 |_.T.R.A. N.S.A.C.|
0030 54 00 49 00 4f 00 4e 00-53 00 20 00 4f 00 46 00 |T.I.O.N. S. .O.F.|
0040 46 00 - |F.|

token.c:540:tds_process_tokens(0x90c0f70, 0xbfd94f68, 0xbfd94f6c, 0x100)
util.c:156:Changed query state from PENDING to READING
net.c:555:Received header
0000 04 01 00 11 00 41 01 00- |.....A..|

net.c:609:Received packet
0000 04 01 00 11 00 41 01 00-fd 00 00 ba 00 00 00 00 |.....A.. ........|
0010 00 - |.|

token.c:555:processing result tokens. marker is fd(DONE)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2355:tds_process_end() state set to TDS_IDLE
util.c:156:Changed query state from READING to IDLE
token.c:2370: rows_affected = 0
util.c:104:logic error: cannot change query state from IDLE to PENDING
token.c:540:tds_process_tokens(0x90c0f70, 0xbfd94f68, 0xbfd94f6c, 0x100)
token.c:543:tds_process_tokens() state is COMPLETED
odbc.c:1716:SQLAllocStmt(0x90c0bf0, 0x90fd588)
odbc.c:1615:_SQLAllocStmt(0x90c0bf0, 0x90fd588)
odbc.c:4388:SQLGetStmtAttr(0x90fd750, 10010, 0xbfd95208, 4, (nil))
odbc.c:4388:SQLGetStmtAttr(0x90fd750, 10011, 0xbfd95208, 4, (nil))
odbc.c:4388:SQLGetStmtAttr(0x90fd750, 10012, 0xbfd95208, 4, (nil))
odbc.c:4388:SQLGetStmtAttr(0x90fd750, 10013, 0xbfd95208, 4, (nil))
odbc.c:4445:SQLPrepare(0x90fd750, SELECT bill_cd_typ_desc FROM bill_cd_typ,
-3)
odbc.c:3496:SQLExecute(0x90fd750)
prepare_query.c:203:parsing 0 parameters
odbc.c:3211:_SQLExecute(0x90fd750)
odbc.c:3216:_SQLExecute() starting with state 0
mem.c:615:tds_free_all_results()
util.c:156:Changed query state from IDLE to QUERYING
util.c:156:Changed query state from QUERYING to PENDING
net.c:741:Sending packet
0000 03 01 00 83 00 00 01 00-ff ff 0d 00 00 00 00 01 |........ ........|
0010 26 04 00 00 00 63 00 00-00 00 09 04 00 02 00 ff |&....c.. ........|
0020 ff ff ff 00 00 63 50 00-00 00 09 04 00 02 00 50 |.....cP. .......P|
0030 00 00 00 53 00 45 00 4c-00 45 00 43 00 54 00 20 |...S.E.L .E.C.T. |
0040 00 62 00 69 00 6c 00 6c-00 5f 00 63 00 64 00 5f |.b.i.l.l ._.c.d._|
0050 00 74 00 79 00 70 00 5f-00 64 00 65 00 73 00 63 |.t.y.p._ .d.e.s.c|
0060 00 20 00 46 00 52 00 4f-00 4d 00 20 00 62 00 69 |. .F.R.O .M. .b.i|
0070 00 6c 00 6c 00 5f 00 63-00 64 00 5f 00 74 00 79 |.l.l._.c .d._.t.y|
0080 00 70 00 - |.p.|

token.c:540:tds_process_tokens(0x90c0f70, 0xbfd95158, 0xbfd9515c, 0x6914)
util.c:156:Changed query state from PENDING to READING
net.c:555:Received header
0000 04 01 00 a4 00 41 01 00- |.....A..|

net.c:609:Received packet
0000 04 01 00 a4 00 41 01 00-81 01 00 00 00 0a 00 ef |.....A.. ........|
0010 14 00 09 04 00 02 00 10-62 00 69 00 6c 00 6c 00 |........ b.i.l.l.|
0020 5f 00 63 00 64 00 5f 00-74 00 79 00 70 00 5f 00 |_.c.d._. t.y.p._.|
0030 64 00 65 00 73 00 63 00-d1 14 00 43 00 50 00 54 |d.e.s.c. ...C.P.T|
0040 00 20 00 ae 00 20 00 20-00 20 00 20 00 20 00 d1 |. ... . . . . ..|
0050 14 00 48 00 43 00 50 00-43 00 53 00 20 00 20 00 |..H.C.P. C.S. . .|
0060 20 00 20 00 20 00 d1 14-00 4f 00 74 00 68 00 65 | . . ... .O.t.h.e|
0070 00 72 00 20 00 20 00 20-00 20 00 20 00 ff 11 00 |.r. . . . . ....|
0080 c1 00 03 00 00 00 79 00-00 00 00 ac 0d 00 00 01 |......y. ........|
0090 00 00 00 00 26 04 04 01-00 00 00 fe 00 00 e0 00 |....&... ........|
00a0 00 00 00 00 - |....|

token.c:555:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1515:processing TDS7 result metadata.
mem.c:615:tds_free_all_results()
token.c:1540:set current_results (1 column) to tds->res_info
token.c:1547:setting up 1 columns
token.c:1486:tds7_get_data_info:
colname = bill_cd_typ_desc (16 bytes)
type = 47 (char)
server's type = 239 (x UCS-2 char)
column_varint_size = 2
column_size = 20 (20 on server)
token.c:1556: name size/wsize type/wtype utype
token.c:1557: -------------------- --------------- --------------- -------
token.c:1567: bill_cd_typ_desc 20/20 47/239 0
util.c:156:Changed query state from READING to PENDING
odbc.c:3534:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3535: result_type=4049, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3605:odbc_process_tokens: returning result_type 4049
odbc.c:3374:_SQLExecute: odbc_process_tokens returned result_type 4049
token.c:540:tds_process_tokens(0x90c0f70, 0xbfd95158, 0xbfd9515c, 0x6914)
util.c:156:Changed query state from PENDING to READING
token.c:555:processing result tokens. marker is d1(ROW)
token.c:666:tds_process_tokens::SET_RETURN stopping on current token
util.c:156:Changed query state from READING to PENDING
odbc.c:3534:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3535: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3605:odbc_process_tokens: returning result_type 4040
odbc.c:3374:_SQLExecute: odbc_process_tokens returned result_type 4040
odbc.c:3519:SQLExecute returns SQL_SUCCESS
odbc.c:4506:_SQLRowCount(0x90fd750, 0x90ecd84)
odbc.c:4525:SQLRowCount returns 0, row count -1
odbc.c:4420:SQLNumResultCols(0x90fd750, 0xbfd953a4)
odbc.c:4420:SQLNumResultCols(0x90fd750, 0xbfd9533e)
odbc.c:1919:SQLDescribeCol(0x90fd750, 1, 0x90ff548, 128, 0x90ff510,
0x90ff51a, 0x90ff514, 0x90ff518, 0x90ff51c)
odbc.c:1984:_SQLColAttribute(0x90fd750, 1, 6, (nil), 0, (nil), 0x90ff524)
odbc.c:2026:SQLColAttribute: fDescType is 6
odbc.c:1984:_SQLColAttribute(0x90fd750, 1, 1003, (nil), 0, (nil), 0x90ff520)
odbc.c:2026:SQLColAttribute: fDescType is 1003
odbc.c:1731:SQLBindCol(0x90fd750, 1, 1, 0x91017d8, 11, 0x90ff530)
odbc.c:3935:SQLFetch(0x90fd750)
odbc.c:3671:_SQLFetch(0x90fd750, 1, 0)
token.c:540:tds_process_tokens(0x90c0f70, 0xbfd94cf8, 0xbfd94cfc, 0x6508)
util.c:156:Changed query state from PENDING to READING
token.c:555:processing result tokens. marker is d1(ROW)
token.c:2304:tds_process_row(): reading column 0
token.c:2049:tds_get_data: type 47, varint size 2
token.c:2110:tds_get_data(): wire column size is 20
util.c:156:Changed query state from READING to PENDING
odbc.c:3534:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3535: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3605:odbc_process_tokens: returning result_type 4040
convert_tds2sql.c:164:odbc_tds2sql: src is 239 dest = 1
odbc.c:4154:SQLFreeStmt(0x90fd750, 0)
odbc.c:4075:_SQLFreeStmt(0x90fd750, 0, 0)
query.c:2155:tds_send_cancel: not in_cancel and not idle
query.c:2164:tds_send_cancel: sending cancel packet
net.c:741:Sending packet
0000 06 01 00 08 00 00 01 00- |........|

token.c:540:tds_process_tokens(0x90c0f70, 0xbfd9508c, (nil), 0x0)
util.c:156:Changed query state from PENDING to READING
token.c:555:processing result tokens. marker is d1(ROW)
token.c:2304:tds_process_row(): reading column 0
token.c:2049:tds_get_data: type 47, varint size 2
token.c:2110:tds_get_data(): wire column size is 20
token.c:555:processing result tokens. marker is d1(ROW)
token.c:2304:tds_process_row(): reading column 0
token.c:2049:tds_get_data: type 47, varint size 2
token.c:2110:tds_get_data(): wire column size is 20
token.c:555:processing result tokens. marker is ff(DONEINPROC)
token.c:2339:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2370: rows_affected = 3
token.c:555:processing result tokens. marker is 79(RETURNSTATUS)
token.c:555:processing result tokens. marker is ac(PARAM)
token.c:612:processing parameters for sp 13
token.c:614:calling tds_process_param_result
token.c:1247:tds_process_param_result(0x90c0f70, 0xbfd95024)
token.c:1591:tds_get_data_info(0x90c0f70, 0x9105dc0, 1) [for parameter]
token.c:1654:processing result. type = 38(integer-null), varint_size 1
token.c:1659:processing result. column_size 4
token.c:2049:tds_get_data: type 38, varint size 1
token.c:2110:tds_get_data(): wire column size is 4
log.c:493:type integer-null has value 1
token.c:618:1 hidden return parameters
token.c:555:processing result tokens. marker is fe(DONEPROC)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2370: rows_affected = 0
net.c:555:Received header
0000 04 01 00 11 00 41 01 00- |.....A..|

net.c:609:Received packet
0000 04 01 00 11 00 41 01 00-fd 20 00 fd 00 00 00 00 |.....A.. . ......|
0010 00 - |.|

token.c:555:processing result tokens. marker is fd(DONE)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 1
error = 0
done_count_valid = 0
token.c:2355:tds_process_end() state set to TDS_IDLE
util.c:156:Changed query state from READING to IDLE
token.c:2370: rows_affected = 0
odbc.c:3980:SQLFreeHandle(3, 0x90fd750)
odbc.c:4075:_SQLFreeStmt(0x90fd750, 1, 0)
query.c:1935:tds_submit_unprepare() gtj4h36000
mem.c:615:tds_free_all_results()
util.c:156:Changed query state from IDLE to QUERYING
util.c:156:Changed query state from QUERYING to PENDING
net.c:741:Sending packet
0000 03 01 00 17 00 00 01 00-ff ff 0f 00 00 00 00 00 |........ ........|
0010 26 04 04 01 00 00 00 - |&......|

token.c:540:tds_process_tokens(0x90c0f70, 0xbfd95118, 0xbfd9511c, 0x100)
util.c:156:Changed query state from PENDING to READING
net.c:555:Received header
0000 04 01 00 16 00 41 01 00- |.....A..|

net.c:609:Received packet
0000 04 01 00 16 00 41 01 00-79 00 00 00 00 fe 00 00 |.....A.. y.......|
0010 e0 00 00 00 00 00 - |......|

token.c:555:processing result tokens. marker is 79(RETURNSTATUS)
token.c:555:processing result tokens. marker is fe(DONEPROC)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2355:tds_process_end() state set to TDS_IDLE
util.c:156:Changed query state from READING to IDLE
token.c:2370: rows_affected = 0
util.c:104:logic error: cannot change query state from IDLE to PENDING
token.c:540:tds_process_tokens(0x90c0f70, 0xbfd95118, 0xbfd9511c, 0x100)
token.c:543:tds_process_tokens() state is COMPLETED
odbc.c:4718:_SQLGetConnectAttr(0x90c0bf0, 102, 0xbfd95080, -5, (nil))
odbc.c:2240:SQLDisconnect(0x90c0bf0)
mem.c:615:tds_free_all_results()
util.c:156:Changed query state from IDLE to DEAD
odbc.c:3980:SQLFreeHandle(2, 0x90c0bf0)
odbc.c:4006:_SQLFreeConnect(0x90c0bf0)
odbc.c:3980:SQLFreeHandle(1, 0x90c1f08)
odbc.c:4050:_SQLFreeEnv(0x90c1f08)

[freetds] FreeTDS, Perl, unicode, Brian Johnson, 03/11/2013
- Message not available
  - Re: [freetds] FreeTDS, Perl, unicode, Brian Johnson, 03/11/2013
    - Re: [freetds] FreeTDS, Perl, unicode, James K. Lowden, 03/11/2013
      - Re: [freetds] FreeTDS, Perl, unicode, Brian Johnson, 03/11/2013
        
        Re: [freetds] FreeTDS, Perl, unicode, James K. Lowden, 03/11/2013
- Re: [freetds] FreeTDS, Perl, unicode, David Dick, 03/11/2013