SELECT querys fine, but INSERT query packets get malformed?
Scott Kovach <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Thanks in advance to anyone that might help with this.
We are interacting remotely with a sql server 2k DB from a unix machine.
We are using the mssql libraries in PHP as our programming environment
on the unix machine.
Here is our test script:
$link = mssql_pconnect (MSDBHOST . ":" . MSDBPORT, MSDBUSER, MSDBPASS);
if(!$link || !mssql_select_db(MSDB, $link))
{
die('Unable to connect or select database!');
}
$query_select = "SELECT * FROM VA_ORDHDR WHERE VA_ORDER_NUMBER = '1409-1'";
$queryid = mssql_query ($query_select, $link);
mssql_free_result($queryid);
$query_insert = "INSERT INTO VA_ORDHDR
(VA_ORDER_NUMBER,VA_BUYERID,SHIP_CODE) VALUES
('1411-1','SC1276191463KO','VA03R')";
$queryid = mssql_query ($query_insert, $link);
$queryid = mssql_query ($query_select, $link);
mssql_free_result($queryid);
We CAN connect, send queries, and get results from querys from the
remote sql server just fine. However, all of the "INSERT" or "UPDATE"
queries fail, and the response is "Incorrect syntax near the keyword
'and'." (note: there is no 'and' in the query) The DBA of the remote
sql server is saying that they fail due to some problem with the packets
sent:
"Error: 17832, Severity: 20, State: 7
Connection opened but invalid login packet(s) sent. Connection closed.
You should have a talk with your provider. It seems that the packets
coming from your service are not valid."
I dont see how the sql server response of Incorrect syntax near the keyword 'and'." can be caused by the packets sent, since the connection is fine and a
response packet is received back from them and the select querys are sent in valid packets. I've attached a log of a
single connection with 3 queries. If anyone can tell me if the failed inserts/updates are a freetds/php issue or whether its an issue on the remote sql server, i would be forever grateful.
-- Scott
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
(unnamed)
(application/applefile, 1.5 KB) - not displayed
freetds_log.log
(application/octet-stream, 56.9 KB)
util.c:288:Starting log file for FreeTDS 0.64
on 2009-01-29 12:26:08 with debug flags 0x4fff.
iconv.c:195:names for ISO-8859-1: ISO-8859-1
iconv.c:195:names for UTF-8: UTF-8
iconv.c:195:names for UCS-2LE: UCS-2LE
iconv.c:195:names for UCS-2BE: UCS-2BE
iconv.c:361:iconv to convert client-side data to the "ISO-8859-1" character set
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:168:Connecting to 69.64.68.208 port 1433.
write.c:134:tds_put_string converting 17 bytes of "vitaminanswer.com"
write.c:162:tds_put_string wrote 34 bytes
write.c:134:tds_put_string converting 2 bytes of "va"
write.c:162:tds_put_string wrote 4 bytes
write.c:134:tds_put_string converting 5 bytes of "PHP 5"
write.c:162:tds_put_string wrote 10 bytes
write.c:134:tds_put_string converting 12 bytes of "69.64.68.208"
write.c:162:tds_put_string wrote 24 bytes
write.c:134:tds_put_string converting 10 bytes of "DB-Library"
write.c:162:tds_put_string wrote 20 bytes
write.c:134:tds_put_string converting 10 bytes of "us_english"
write.c:162:tds_put_string wrote 20 bytes
write.c:162:tds_put_string wrote 0 bytes
token.c:310:tds_process_login_tokens()
net.c:446:Received header
0000 04 01 01 b0 00 3e 01 00- |.....>..|
net.c:542:Received packet
0000 e3 1b 00 01 06 6d 00 61-00 73 00 74 00 65 00 72 |.....m.a .s.t.e.r|
0010 00 06 6d 00 61 00 73 00-74 00 65 00 72 00 ab 6e |..m.a.s. t.e.r..n|
0020 00 45 16 00 00 02 00 25-00 43 00 68 00 61 00 6e |.E.....% .C.h.a.n|
0030 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d. .d.a.t.a|
0040 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n|
0050 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. |
0060 00 27 00 6d 00 61 00 73-00 74 00 65 00 72 00 27 |.'.m.a.s .t.e.r.'|
0070 00 2e 00 0c 36 00 39 00-2d 00 36 00 34 00 2d 00 |....6.9. -.6.4.-.|
0080 36 00 38 00 2d 00 32 00-30 00 38 00 00 00 00 e3 |6.8.-.2. 0.8.....|
0090 17 00 02 0a 75 00 73 00-5f 00 65 00 6e 00 67 00 |....u.s. _.e.n.g.|
00a0 6c 00 69 00 73 00 68 00-00 ab 72 00 47 16 00 00 |l.i.s.h. ..r.G...|
00b0 01 00 27 00 43 00 68 00-61 00 6e 00 67 00 65 00 |..'.C.h. a.n.g.e.|
00c0 64 00 20 00 6c 00 61 00-6e 00 67 00 75 00 61 00 |d. .l.a. n.g.u.a.|
00d0 67 00 65 00 20 00 73 00-65 00 74 00 74 00 69 00 |g.e. .s. e.t.t.i.|
00e0 6e 00 67 00 20 00 74 00-6f 00 20 00 75 00 73 00 |n.g. .t. o. .u.s.|
00f0 5f 00 65 00 6e 00 67 00-6c 00 69 00 73 00 68 00 |_.e.n.g. l.i.s.h.|
0100 2e 00 0c 36 00 39 00 2d-00 36 00 34 00 2d 00 36 |...6.9.- .6.4.-.6|
0110 00 38 00 2d 00 32 00 30-00 38 00 00 00 00 e3 0f |.8.-.2.0 .8......|
0120 00 03 05 69 00 73 00 6f-00 5f 00 31 00 01 00 00 |...i.s.o ._.1....|
0130 e3 0b 00 05 04 31 00 30-00 33 00 33 00 00 e3 0f |.....1.0 .3.3....|
0140 00 06 06 31 00 39 00 36-00 36 00 30 00 39 00 00 |...1.9.6 .6.0.9..|
0150 ad 36 00 01 07 00 00 00-16 4d 00 69 00 63 00 72 |.6...... .M.i.c.r|
0160 00 6f 00 73 00 6f 00 66-00 74 00 20 00 53 00 51 |.o.s.o.f .t. .S.Q|
0170 00 4c 00 20 00 53 00 65-00 72 00 76 00 65 00 72 |.L. .S.e .r.v.e.r|
0180 00 00 00 00 00 08 00 08-02 e3 13 00 04 04 34 00 |........ ......4.|
0190 30 00 39 00 36 00 04 34-00 30 00 39 00 36 00 fd |0.9.6..4 .0.9.6..|
01a0 00 00 00 00 00 00 00 00- |........|
token.c:314:looking for login token, got e3(ENVCHANGE)
token.c:105:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 12 from wire to give 6 to client.
read.c:179:tds_get_string: reading 12 from wire to give 6 to client.
token.c:314:looking for login token, got ab(INFO)
token.c:105:tds_process_default_tokens() marker is ab(INFO)
token.c:2439:tds_process_msg() reading message from server
read.c:179:tds_get_string: reading 74 from wire to give 37 to client.
read.c:179:tds_get_string: reading 24 from wire to give 12 to client.
token.c:2501:tds_process_msg() calling client msg handler
token.c:2514:tds_process_msg() returning TDS_SUCCEED
token.c:314:looking for login token, got e3(ENVCHANGE)
token.c:105:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 20 from wire to give 10 to client.
token.c:314:looking for login token, got ab(INFO)
token.c:105:tds_process_default_tokens() marker is ab(INFO)
token.c:2439:tds_process_msg() reading message from server
read.c:179:tds_get_string: reading 78 from wire to give 39 to client.
read.c:179:tds_get_string: reading 24 from wire to give 12 to client.
token.c:2501:tds_process_msg() calling client msg handler
token.c:2514:tds_process_msg() returning TDS_SUCCEED
token.c:314:looking for login token, got e3(ENVCHANGE)
token.c:105:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 10 from wire to give 5 to client.
read.c:179:tds_get_string: reading 2 from wire to give 1 to client.
token.c:314:looking for login token, got e3(ENVCHANGE)
token.c:105:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
token.c:314:looking for login token, got e3(ENVCHANGE)
token.c:105:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 12 from wire to give 6 to client.
token.c:314:looking for login token, got ad(LOGINACK)
read.c:179:tds_get_string: reading 44 from wire to give 22 to client.
token.c:314:looking for login token, got e3(ENVCHANGE)
token.c:105:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
token.c:2327:increasing block size from 4096 to 4096
token.c:314:looking for login token, got fd(DONE)
token.c:105:tds_process_default_tokens() marker is fd(DONE)
token.c:2143:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2159:tds_process_end() state set to TDS_IDLE
util.c:119:Changing query state from IDLE to IDLE
token.c:387:leaving tds_process_login_tokens() returning 1
util.c:119:Changing query state from IDLE to QUERYING
mem.c:519:tds_free_all_results()
write.c:134:tds_put_string converting 19 bytes of "set textsize 64512 "
write.c:162:tds_put_string wrote 38 bytes
util.c:119:Changing query state from QUERYING to PENDING
net.c:673:Sending packet
0000 01 01 00 2e 00 00 00 00-73 00 65 00 74 00 20 00 |........ s.e.t. .|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.|
0020 20 00 36 00 34 00 35 00-31 00 32 00 20 00 | .6.4.5. 1.2. .|
util.c:119:Changing query state from PENDING to READING
net.c:446:Received header
0000 04 01 00 11 00 3e 01 00- |.....>..|
net.c:542:Received packet
0000 fd 00 00 be 00 00 00 00-00 |........ .|
token.c:526:processing result tokens. marker is fd(DONE)
token.c:2143:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2159:tds_process_end() state set to TDS_IDLE
util.c:119:Changing query state from READING to IDLE
util.c:119:Changing query state from IDLE to PENDING
token.c:514:tds_process_tokens() state is COMPLETED
dblib.c:991:dbuse()
dblib.c:907:dbcmd() bufsz = 0
dblib.c:957:in dbsqlexec()
dblib.c:5867:in dbsqlsend()
util.c:119:Changing query state from IDLE to QUERYING
mem.c:519:tds_free_all_results()
write.c:134:tds_put_string converting 7 bytes of "use edi"
write.c:162:tds_put_string wrote 14 bytes
util.c:119:Changing query state from QUERYING to PENDING
net.c:673:Sending packet
0000 01 01 00 16 00 00 01 00-75 00 73 00 65 00 20 00 |........ u.s.e. .|
0010 65 00 64 00 69 00 - |e.d.i.|
dblib.c:3976:in dbsqlok()
net.c:446:Received header
0000 04 01 00 94 00 3e 01 00- |.....>..|
net.c:542:Received packet
0000 e3 15 00 01 03 45 00 44-00 49 00 06 6d 00 61 00 |.....E.D .I..m.a.|
0010 73 00 74 00 65 00 72 00-ab 68 00 45 16 00 00 01 |s.t.e.r. .h.E....|
0020 00 22 00 43 00 68 00 61-00 6e 00 67 00 65 00 64 |.".C.h.a .n.g.e.d|
0030 00 20 00 64 00 61 00 74-00 61 00 62 00 61 00 73 |. .d.a.t .a.b.a.s|
0040 00 65 00 20 00 63 00 6f-00 6e 00 74 00 65 00 78 |.e. .c.o .n.t.e.x|
0050 00 74 00 20 00 74 00 6f-00 20 00 27 00 45 00 44 |.t. .t.o . .'.E.D|
0060 00 49 00 27 00 2e 00 0c-36 00 39 00 2d 00 36 00 |.I.'.... 6.9.-.6.|
0070 34 00 2d 00 36 00 38 00-2d 00 32 00 30 00 38 00 |4.-.6.8. -.2.0.8.|
0080 00 01 00 fd 00 00 e2 00-00 00 00 00 |........ ....|
dblib.c:3995:dbsqlok() marker is e3
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is e3(ENVCHANGE)
token.c:105:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 6 from wire to give 3 to client.
read.c:179:tds_get_string: reading 12 from wire to give 6 to client.
token.c:526:processing result tokens. marker is ab(INFO)
token.c:105:tds_process_default_tokens() marker is ab(INFO)
token.c:2439:tds_process_msg() reading message from server
read.c:179:tds_get_string: reading 68 from wire to give 34 to client.
read.c:179:tds_get_string: reading 24 from wire to give 12 to client.
token.c:2501:tds_process_msg() calling client msg handler
token.c:2514:tds_process_msg() returning TDS_SUCCEED
token.c:526:processing result tokens. marker is fd(DONE)
token.c:2143:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2159:tds_process_end() state set to TDS_IDLE
util.c:119:Changing query state from READING to IDLE
util.c:119:Changing query state from IDLE to PENDING
dblib.c:4042:dbsqlok() end status was success
dblib.c:1161:dbresults()
token.c:514:tds_process_tokens() state is COMPLETED
dblib.c:907:dbcmd() bufsz = 8
dblib.c:4978:in dbfreebuf()
dblib.c:957:in dbsqlexec()
dblib.c:5867:in dbsqlsend()
util.c:119:Changing query state from IDLE to QUERYING
mem.c:519:tds_free_all_results()
write.c:134:tds_put_string converting 56 bytes of "SELECT * FROM VA_ORDHDR WHERE VA_ORDER_NUMBER = '1409-1'"
write.c:162:tds_put_string wrote 112 bytes
util.c:119:Changing query state from QUERYING to PENDING
net.c:673:Sending packet
0000 01 01 00 78 00 00 01 00-53 00 45 00 4c 00 45 00 |...x.... S.E.L.E.|
0010 43 00 54 00 20 00 2a 00-20 00 46 00 52 00 4f 00 |C.T. .*. .F.R.O.|
0020 4d 00 20 00 56 00 41 00-5f 00 4f 00 52 00 44 00 |M. .V.A. _.O.R.D.|
0030 48 00 44 00 52 00 20 00-57 00 48 00 45 00 52 00 |H.D.R. . W.H.E.R.|
0040 45 00 20 00 56 00 41 00-5f 00 4f 00 52 00 44 00 |E. .V.A. _.O.R.D.|
0050 45 00 52 00 5f 00 4e 00-55 00 4d 00 42 00 45 00 |E.R._.N. U.M.B.E.|
0060 52 00 20 00 3d 00 20 00-27 00 31 00 34 00 30 00 |R. .=. . '.1.4.0.|
0070 39 00 2d 00 31 00 27 00- |9.-.1.'.|
dblib.c:3976:in dbsqlok()
net.c:446:Received header
0000 04 01 02 e6 00 3e 01 00- |.....>..|
net.c:542:Received packet
0000 81 11 00 00 00 08 00 e7-64 00 0f 56 00 41 00 5f |........ d..V.A._|
0010 00 4f 00 52 00 44 00 45-00 52 00 5f 00 4e 00 55 |.O.R.D.E .R._.N.U|
0020 00 4d 00 42 00 45 00 52-00 00 00 09 00 a7 32 00 |.M.B.E.R ......2.|
0030 0a 56 00 41 00 5f 00 42-00 55 00 59 00 45 00 52 |.V.A._.B .U.Y.E.R|
0040 00 49 00 44 00 00 00 08-00 3a 12 56 00 41 00 5f |.I.D.... .:.V.A._|
0050 00 4f 00 52 00 44 00 45-00 52 00 5f 00 54 00 49 |.O.R.D.E .R._.T.I|
0060 00 4d 00 45 00 53 00 54-00 41 00 4d 00 50 00 00 |.M.E.S.T .A.M.P..|
0070 00 09 00 a7 32 00 04 4e-00 41 00 4d 00 45 00 00 |....2..N .A.M.E..|
0080 00 09 00 a7 32 00 07 41-00 44 00 44 00 52 00 45 |....2..A .D.D.R.E|
0090 00 53 00 53 00 00 00 09-00 a7 32 00 04 43 00 49 |.S.S.... ..2..C.I|
00a0 00 54 00 59 00 00 00 09-00 a7 32 00 05 53 00 54 |.T.Y.... ..2..S.T|
00b0 00 41 00 54 00 45 00 00-00 09 00 a7 32 00 07 5a |.A.T.E.. ....2..Z|
00c0 00 49 00 50 00 43 00 4f-00 44 00 45 00 00 00 09 |.I.P.C.O .D.E....|
00d0 00 a7 32 00 07 43 00 4f-00 55 00 4e 00 54 00 52 |..2..C.O .U.N.T.R|
00e0 00 59 00 00 00 08 00 e7-2c 00 09 53 00 48 00 49 |.Y...... ,..S.H.I|
00f0 00 50 00 5f 00 43 00 4f-00 44 00 45 00 00 00 09 |.P._.C.O .D.E....|
0100 00 a7 32 00 08 53 00 48-00 49 00 50 00 5f 00 56 |..2..S.H .I.P._.V|
0110 00 49 00 41 00 00 00 20-00 e7 6a 00 0f 54 00 48 |.I.A... ..j..T.H|
0120 00 5f 00 4f 00 52 00 44-00 45 00 52 00 5f 00 4e |._.O.R.D .E.R._.N|
0130 00 55 00 4d 00 42 00 45-00 52 00 00 00 09 00 a7 |.U.M.B.E .R......|
0140 06 00 11 54 00 48 00 5f-00 49 00 4e 00 56 00 4f |...T.H._ .I.N.V.O|
0150 00 49 00 43 00 45 00 5f-00 4e 00 55 00 4d 00 42 |.I.C.E._ .N.U.M.B|
0160 00 45 00 52 00 00 00 09-00 a7 32 00 0f 54 00 52 |.E.R.... ..2..T.R|
0170 00 41 00 43 00 4b 00 49-00 4e 00 47 00 5f 00 4e |.A.C.K.I .N.G._.N|
0180 00 55 00 4d 00 42 00 45-00 52 00 00 00 09 00 a7 |.U.M.B.E .R......|
0190 32 00 0d 53 00 48 00 49-00 50 00 5f 00 44 00 41 |2..S.H.I .P._.D.A|
01a0 00 54 00 45 00 54 00 49-00 4d 00 45 00 00 00 09 |.T.E.T.I .M.E....|
01b0 00 6e 08 10 54 00 48 00-5f 00 49 00 4e 00 56 00 |.n..T.H. _.I.N.V.|
01c0 4f 00 49 00 43 00 45 00-5f 00 54 00 4f 00 54 00 |O.I.C.E. _.T.O.T.|
01d0 41 00 4c 00 00 00 08 00-38 09 54 00 52 00 41 00 |A.L..... 8.T.R.A.|
01e0 4e 00 5f 00 53 00 54 00-41 00 54 00 d1 0c 00 31 |N._.S.T. A.T....1|
01f0 00 34 00 30 00 39 00 2d-00 31 00 1b 00 56 49 33 |.4.0.9.- .1...VI3|
0200 34 37 30 37 34 37 34 36-32 30 30 38 30 39 30 34 |47074746 20080904|
0210 31 32 31 32 34 30 47 41-74 9b b7 02 0d 00 4a 6f |121240GA t.....Jo|
0220 68 6e 20 50 68 69 6c 6c-69 70 73 12 00 32 36 38 |hn Phill ips..268|
0230 35 20 4a 61 63 6b 73 6f-6e 20 52 6f 61 64 20 06 |5 Jackso n Road .|
0240 00 4d 6f 72 72 69 73 02-00 41 4c 05 00 33 35 31 |.Morris. .AL..351|
0250 31 36 0d 00 55 6e 69 74-65 64 20 53 74 61 74 65 |16..Unit ed State|
0260 73 0a 00 56 00 41 00 30-00 31 00 52 00 1a 00 46 |s..V.A.0 .1.R...F|
0270 65 64 45 78 20 47 72 6f-75 6e 64 20 48 6f 6d 65 |edEx Gro und Home|
0280 20 44 65 6c 69 76 65 72-79 12 00 56 00 41 00 2d | Deliver y..V.A.-|
0290 00 31 00 34 00 30 00 39-00 2d 00 31 00 06 00 43 |.1.4.0.9 .-.1...C|
02a0 36 37 34 37 37 0c 00 39-37 38 34 39 32 31 37 30 |67477..9 78492170|
02b0 38 33 38 13 00 44 65 63-20 31 36 20 32 30 30 38 |838..Dec 16 2008|
02c0 20 20 34 3a 34 31 50 4d-08 00 00 00 00 bc 4f 08 | 4:41PM ......O.|
02d0 00 1d 00 00 00 fd 10 00-c1 00 01 00 00 00 |........ ......|
dblib.c:3995:dbsqlok() marker is 81
dblib.c:3999:dbsqlok() found result token
dblib.c:1161:dbresults()
mem.c:519:tds_free_all_results()
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is 81(TDS7_RESULT)
mem.c:519:tds_free_all_results()
token.c:1472:processing TDS7 result. set current_results to tds->res_info
token.c:3395:adjust_character_column_size:
Server charset: UCS-2LE
Server column_size: 100
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 30 from wire to give 15 to client.
token.c:1414:tds7_get_data_info:
colname = VA_ORDER_NUMBER (15 bytes)
type = 39 (varchar)
server's type = 231 (x UCS-2 varchar)
column_varint_size = 2
column_size = 50 (100 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 20 from wire to give 10 to client.
token.c:1414:tds7_get_data_info:
colname = VA_BUYERID (10 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
read.c:179:tds_get_string: reading 36 from wire to give 18 to client.
token.c:1414:tds7_get_data_info:
colname = VA_ORDER_TIMESTAMP (18 bytes)
type = 58 (smalldatetime)
server's type = 58 (smalldatetime)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
token.c:1414:tds7_get_data_info:
colname = NAME (4 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 14 from wire to give 7 to client.
token.c:1414:tds7_get_data_info:
colname = ADDRESS (7 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
token.c:1414:tds7_get_data_info:
colname = CITY (4 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 10 from wire to give 5 to client.
token.c:1414:tds7_get_data_info:
colname = STATE (5 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 14 from wire to give 7 to client.
token.c:1414:tds7_get_data_info:
colname = ZIPCODE (7 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 14 from wire to give 7 to client.
token.c:1414:tds7_get_data_info:
colname = COUNTRY (7 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: UCS-2LE
Server column_size: 44
Client charset: ISO-8859-1
Client column_size: 22
read.c:179:tds_get_string: reading 18 from wire to give 9 to client.
token.c:1414:tds7_get_data_info:
colname = SHIP_CODE (9 bytes)
type = 39 (varchar)
server's type = 231 (x UCS-2 varchar)
column_varint_size = 2
column_size = 22 (44 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 16 from wire to give 8 to client.
token.c:1414:tds7_get_data_info:
colname = SHIP_VIA (8 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: UCS-2LE
Server column_size: 106
Client charset: ISO-8859-1
Client column_size: 53
read.c:179:tds_get_string: reading 30 from wire to give 15 to client.
token.c:1414:tds7_get_data_info:
colname = TH_ORDER_NUMBER (15 bytes)
type = 39 (varchar)
server's type = 231 (x UCS-2 varchar)
column_varint_size = 2
column_size = 53 (106 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 6
Client charset: ISO-8859-1
Client column_size: 6
read.c:179:tds_get_string: reading 34 from wire to give 17 to client.
token.c:1414:tds7_get_data_info:
colname = TH_INVOICE_NUMBER (17 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 6 (6 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 30 from wire to give 15 to client.
token.c:1414:tds7_get_data_info:
colname = TRACKING_NUMBER (15 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 26 from wire to give 13 to client.
token.c:1414:tds7_get_data_info:
colname = SHIP_DATETIME (13 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
read.c:179:tds_get_string: reading 32 from wire to give 16 to client.
token.c:1414:tds7_get_data_info:
colname = TH_INVOICE_TOTAL (16 bytes)
type = 110 (money-null)
server's type = 110 (money-null)
column_varint_size = 1
column_size = 8 (8 on server)
read.c:179:tds_get_string: reading 18 from wire to give 9 to client.
token.c:1414:tds7_get_data_info:
colname = TRAN_STAT (9 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
util.c:119:Changing query state from READING to PENDING
dblib.c:1196:dbresults() process_result_tokens returned result_type = 4049 retcode = 1
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is d1(ROW)
util.c:119:Changing query state from READING to PENDING
dblib.c:1196:dbresults() process_result_tokens returned result_type = 4040 retcode = 1
dblib.c:1433:dbnextrow()
dblib.c:1447:dbnextrow() dbresults_state = 2
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is d1(ROW)
token.c:1863:tds_get_data: column 0, type 39, varint size 2
token.c:1920:processing row. column size is 12
token.c:1863:tds_get_data: column 1, type 39, varint size 2
token.c:1920:processing row. column size is 27
token.c:1863:tds_get_data: column 2, type 58, varint size 0
token.c:1920:processing row. column size is 4
token.c:2051:datetime4 116 155 183 2
token.c:1863:tds_get_data: column 3, type 39, varint size 2
token.c:1920:processing row. column size is 13
token.c:1863:tds_get_data: column 4, type 39, varint size 2
token.c:1920:processing row. column size is 18
token.c:1863:tds_get_data: column 5, type 39, varint size 2
token.c:1920:processing row. column size is 6
token.c:1863:tds_get_data: column 6, type 39, varint size 2
token.c:1920:processing row. column size is 2
token.c:1863:tds_get_data: column 7, type 39, varint size 2
token.c:1920:processing row. column size is 5
token.c:1863:tds_get_data: column 8, type 39, varint size 2
token.c:1920:processing row. column size is 13
token.c:1863:tds_get_data: column 9, type 39, varint size 2
token.c:1920:processing row. column size is 10
token.c:1863:tds_get_data: column 10, type 39, varint size 2
token.c:1920:processing row. column size is 26
token.c:1863:tds_get_data: column 11, type 39, varint size 2
token.c:1920:processing row. column size is 18
token.c:1863:tds_get_data: column 12, type 39, varint size 2
token.c:1920:processing row. column size is 6
token.c:1863:tds_get_data: column 13, type 39, varint size 2
token.c:1920:processing row. column size is 12
token.c:1863:tds_get_data: column 14, type 39, varint size 2
token.c:1920:processing row. column size is 19
token.c:1863:tds_get_data: column 15, type 110, varint size 1
token.c:1920:processing row. column size is 8
token.c:1863:tds_get_data: column 16, type 56, varint size 0
token.c:1920:processing row. column size is 4
util.c:119:Changing query state from READING to PENDING
dblib.c:1509:leaving dbnextrow() returning -1
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 6
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 27
convert.c:2776:tds_willconvert()
convert.c:2780:tds_willconvert() 58 47 1
dblib.c:2480:dbdatlen() type = 58
dblib.c:2486:leaving dbdatlen() returning 4
dblib.c:1620:dbconvert(58 [SYBDATETIME4] len 24 => 47 [SYBCHAR] len -1)
dblib.c:1760:dbconvert() calling tds_convert
dblib.c:1763:dbconvert() called tds_convert returned 26
dblib.c:1866:dbconvert() outputting 26 bytes character data destlen = -1
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 13
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 18
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 6
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 2
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 5
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 13
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 5
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 26
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 9
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 6
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 12
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 19
dblib.c:1620:dbconvert(60 [SYBMONEY] len 8 => 62 [SYBFLT8] len -1)
dblib.c:1760:dbconvert() calling tds_convert
convert.c:1176:tds_convert_money()
dblib.c:1763:dbconvert() called tds_convert returned 8
dblib.c:1433:dbnextrow()
dblib.c:1447:dbnextrow() dbresults_state = 2
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is fd(DONE)
token.c:2143:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2159:tds_process_end() state set to TDS_IDLE
util.c:119:Changing query state from READING to IDLE
token.c:2175: rows_affected = 1
util.c:119:Changing query state from IDLE to PENDING
dblib.c:1509:leaving dbnextrow() returning -2
token.c:514:tds_process_tokens() state is COMPLETED
dblib.c:1161:dbresults()
mem.c:519:tds_free_all_results()
token.c:514:tds_process_tokens() state is COMPLETED
dblib.c:1196:dbresults() process_result_tokens returned result_type = 4052 retcode = 2
dblib.c:907:dbcmd() bufsz = 57
dblib.c:4978:in dbfreebuf()
dblib.c:957:in dbsqlexec()
dblib.c:5867:in dbsqlsend()
util.c:119:Changing query state from IDLE to QUERYING
mem.c:519:tds_free_all_results()
write.c:134:tds_put_string converting 103 bytes of "INSERT INTO VA_ORDHDR (VA_ORDER_NUMBER,VA_BUYERID,SHIP_CODE) VALUES ('1411-1','SC1276191463KO','VA03R')"
write.c:162:tds_put_string wrote 206 bytes
util.c:119:Changing query state from QUERYING to PENDING
net.c:673:Sending packet
0000 01 01 00 d6 00 00 01 00-49 00 4e 00 53 00 45 00 |........ I.N.S.E.|
0010 52 00 54 00 20 00 49 00-4e 00 54 00 4f 00 20 00 |R.T. .I. N.T.O. .|
0020 56 00 41 00 5f 00 4f 00-52 00 44 00 48 00 44 00 |V.A._.O. R.D.H.D.|
0030 52 00 20 00 28 00 56 00-41 00 5f 00 4f 00 52 00 |R. .(.V. A._.O.R.|
0040 44 00 45 00 52 00 5f 00-4e 00 55 00 4d 00 42 00 |D.E.R._. N.U.M.B.|
0050 45 00 52 00 2c 00 56 00-41 00 5f 00 42 00 55 00 |E.R.,.V. A._.B.U.|
0060 59 00 45 00 52 00 49 00-44 00 2c 00 53 00 48 00 |Y.E.R.I. D.,.S.H.|
0070 49 00 50 00 5f 00 43 00-4f 00 44 00 45 00 29 00 |I.P._.C. O.D.E.).|
0080 20 00 56 00 41 00 4c 00-55 00 45 00 53 00 20 00 | .V.A.L. U.E.S. .|
0090 28 00 27 00 31 00 34 00-31 00 31 00 2d 00 31 00 |(.'.1.4. 1.1.-.1.|
00a0 27 00 2c 00 27 00 53 00-43 00 31 00 32 00 37 00 |'.,.'.S. C.1.2.7.|
00b0 36 00 31 00 39 00 31 00-34 00 36 00 33 00 4b 00 |6.1.9.1. 4.6.3.K.|
00c0 4f 00 27 00 2c 00 27 00-56 00 41 00 30 00 33 00 |O.'.,.'. V.A.0.3.|
00d0 52 00 27 00 29 00 - |R.'.).|
dblib.c:3976:in dbsqlok()
net.c:446:Received header
0000 04 01 01 b1 00 3e 01 00- |.....>..|
net.c:542:Received packet
0000 ff 11 00 c1 00 01 00 00-00 ff 11 00 c1 00 01 00 |........ ........|
0010 00 00 ff 01 00 c0 00 00-00 00 00 ff 01 00 c0 00 |........ ........|
0020 00 00 00 00 ff 11 00 c1-00 01 00 00 00 ff 01 00 |........ ........|
0030 ca 00 01 00 00 00 ff 11-00 c2 00 01 00 00 00 ff |........ ........|
0040 11 00 c2 00 00 00 00 00-ff 11 00 c1 00 01 00 00 |........ ........|
0050 00 ff 11 00 c1 00 01 00-00 00 ff 01 00 c0 00 00 |........ ........|
0060 00 00 00 ff 11 00 c1 00-01 00 00 00 ff 01 00 c0 |........ ........|
0070 00 00 00 00 00 ff 11 00-c1 00 01 00 00 00 ff 11 |........ ........|
0080 00 c1 00 01 00 00 00 ff-11 00 c1 00 01 00 00 00 |........ ........|
0090 ff 11 00 c1 00 01 00 00-00 ff 01 00 c0 00 00 00 |........ ........|
00a0 00 00 ff 11 00 c1 00 01-00 00 00 ff 11 00 c1 00 |........ ........|
00b0 01 00 00 00 ff 11 00 c1-00 01 00 00 00 ff 11 00 |........ ........|
00c0 c1 00 01 00 00 00 ff 11-00 c1 00 01 00 00 00 ff |........ ........|
00d0 11 00 c1 00 01 00 00 00-ff 11 00 c1 00 01 00 00 |........ ........|
00e0 00 ff 11 00 c1 00 01 00-00 00 ff 11 00 c1 00 01 |........ ........|
00f0 00 00 00 ff 11 00 c1 00-01 00 00 00 ff 11 00 c1 |........ ........|
0100 00 01 00 00 00 ff 11 00-c1 00 01 00 00 00 ff 11 |........ ........|
0110 00 c1 00 01 00 00 00 ff-11 00 c1 00 01 00 00 00 |........ ........|
0120 ff 11 00 c1 00 01 00 00-00 aa 74 00 9c 00 00 00 |........ ..t.....|
0130 01 0f 28 00 49 00 6e 00-63 00 6f 00 72 00 72 00 |..(.I.n. c.o.r.r.|
0140 65 00 63 00 74 00 20 00-73 00 79 00 6e 00 74 00 |e.c.t. . s.y.n.t.|
0150 61 00 78 00 20 00 6e 00-65 00 61 00 72 00 20 00 |a.x. .n. e.a.r. .|
0160 74 00 68 00 65 00 20 00-6b 00 65 00 79 00 77 00 |t.h.e. . k.e.y.w.|
0170 6f 00 72 00 64 00 20 00-27 00 61 00 6e 00 64 00 |o.r.d. . '.a.n.d.|
0180 27 00 2e 00 0c 36 00 39-00 2d 00 36 00 34 00 2d |'....6.9 .-.6.4.-|
0190 00 36 00 38 00 2d 00 32-00 30 00 38 00 00 01 00 |.6.8.-.2 .0.8....|
01a0 fd 02 00 c3 00 00 00 00-00 |........ .|
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 0
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is ff
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is ff(DONEINPROC)
token.c:2143:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2175: rows_affected = 1
util.c:119:Changing query state from READING to PENDING
dblib.c:3995:dbsqlok() marker is aa
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is aa(ERROR)
token.c:105:tds_process_default_tokens() marker is aa(ERROR)
token.c:2439:tds_process_msg() reading message from server
read.c:179:tds_get_string: reading 80 from wire to give 40 to client.
read.c:179:tds_get_string: reading 24 from wire to give 12 to client.
token.c:2501:tds_process_msg() calling client msg handler
token.c:2252:tds_client_msg: #20018: "General SQL Server error: Check messages from the SQL Server.". Connection state is now 3.
token.c:2514:tds_process_msg() returning TDS_SUCCEED
token.c:526:processing result tokens. marker is fd(DONE)
token.c:2143:tds_process_end: more_results = 0
was_cancelled = 0
error = 1
done_count_valid = 0
token.c:2159:tds_process_end() state set to TDS_IDLE
util.c:119:Changing query state from READING to IDLE
util.c:119:Changing query state from IDLE to PENDING
dblib.c:4032:dbsqlok() end status was error
dblib.c:907:dbcmd() bufsz = 104
dblib.c:4978:in dbfreebuf()
dblib.c:957:in dbsqlexec()
dblib.c:5867:in dbsqlsend()
util.c:119:Changing query state from IDLE to QUERYING
mem.c:519:tds_free_all_results()
write.c:134:tds_put_string converting 54 bytes of "SELECT * FROM VA_ORDHDR WHERE VA_ORDER_NUMBER='1409-1'"
write.c:162:tds_put_string wrote 108 bytes
util.c:119:Changing query state from QUERYING to PENDING
net.c:673:Sending packet
0000 01 01 00 74 00 00 01 00-53 00 45 00 4c 00 45 00 |...t.... S.E.L.E.|
0010 43 00 54 00 20 00 2a 00-20 00 46 00 52 00 4f 00 |C.T. .*. .F.R.O.|
0020 4d 00 20 00 56 00 41 00-5f 00 4f 00 52 00 44 00 |M. .V.A. _.O.R.D.|
0030 48 00 44 00 52 00 20 00-57 00 48 00 45 00 52 00 |H.D.R. . W.H.E.R.|
0040 45 00 20 00 56 00 41 00-5f 00 4f 00 52 00 44 00 |E. .V.A. _.O.R.D.|
0050 45 00 52 00 5f 00 4e 00-55 00 4d 00 42 00 45 00 |E.R._.N. U.M.B.E.|
0060 52 00 3d 00 27 00 31 00-34 00 30 00 39 00 2d 00 |R.=.'.1. 4.0.9.-.|
0070 31 00 27 00 - |1.'.|
dblib.c:3976:in dbsqlok()
net.c:446:Received header
0000 04 01 02 e6 00 3e 01 00- |.....>..|
net.c:542:Received packet
0000 81 11 00 00 00 08 00 e7-64 00 0f 56 00 41 00 5f |........ d..V.A._|
0010 00 4f 00 52 00 44 00 45-00 52 00 5f 00 4e 00 55 |.O.R.D.E .R._.N.U|
0020 00 4d 00 42 00 45 00 52-00 00 00 09 00 a7 32 00 |.M.B.E.R ......2.|
0030 0a 56 00 41 00 5f 00 42-00 55 00 59 00 45 00 52 |.V.A._.B .U.Y.E.R|
0040 00 49 00 44 00 00 00 08-00 3a 12 56 00 41 00 5f |.I.D.... .:.V.A._|
0050 00 4f 00 52 00 44 00 45-00 52 00 5f 00 54 00 49 |.O.R.D.E .R._.T.I|
0060 00 4d 00 45 00 53 00 54-00 41 00 4d 00 50 00 00 |.M.E.S.T .A.M.P..|
0070 00 09 00 a7 32 00 04 4e-00 41 00 4d 00 45 00 00 |....2..N .A.M.E..|
0080 00 09 00 a7 32 00 07 41-00 44 00 44 00 52 00 45 |....2..A .D.D.R.E|
0090 00 53 00 53 00 00 00 09-00 a7 32 00 04 43 00 49 |.S.S.... ..2..C.I|
00a0 00 54 00 59 00 00 00 09-00 a7 32 00 05 53 00 54 |.T.Y.... ..2..S.T|
00b0 00 41 00 54 00 45 00 00-00 09 00 a7 32 00 07 5a |.A.T.E.. ....2..Z|
00c0 00 49 00 50 00 43 00 4f-00 44 00 45 00 00 00 09 |.I.P.C.O .D.E....|
00d0 00 a7 32 00 07 43 00 4f-00 55 00 4e 00 54 00 52 |..2..C.O .U.N.T.R|
00e0 00 59 00 00 00 08 00 e7-2c 00 09 53 00 48 00 49 |.Y...... ,..S.H.I|
00f0 00 50 00 5f 00 43 00 4f-00 44 00 45 00 00 00 09 |.P._.C.O .D.E....|
0100 00 a7 32 00 08 53 00 48-00 49 00 50 00 5f 00 56 |..2..S.H .I.P._.V|
0110 00 49 00 41 00 00 00 20-00 e7 6a 00 0f 54 00 48 |.I.A... ..j..T.H|
0120 00 5f 00 4f 00 52 00 44-00 45 00 52 00 5f 00 4e |._.O.R.D .E.R._.N|
0130 00 55 00 4d 00 42 00 45-00 52 00 00 00 09 00 a7 |.U.M.B.E .R......|
0140 06 00 11 54 00 48 00 5f-00 49 00 4e 00 56 00 4f |...T.H._ .I.N.V.O|
0150 00 49 00 43 00 45 00 5f-00 4e 00 55 00 4d 00 42 |.I.C.E._ .N.U.M.B|
0160 00 45 00 52 00 00 00 09-00 a7 32 00 0f 54 00 52 |.E.R.... ..2..T.R|
0170 00 41 00 43 00 4b 00 49-00 4e 00 47 00 5f 00 4e |.A.C.K.I .N.G._.N|
0180 00 55 00 4d 00 42 00 45-00 52 00 00 00 09 00 a7 |.U.M.B.E .R......|
0190 32 00 0d 53 00 48 00 49-00 50 00 5f 00 44 00 41 |2..S.H.I .P._.D.A|
01a0 00 54 00 45 00 54 00 49-00 4d 00 45 00 00 00 09 |.T.E.T.I .M.E....|
01b0 00 6e 08 10 54 00 48 00-5f 00 49 00 4e 00 56 00 |.n..T.H. _.I.N.V.|
01c0 4f 00 49 00 43 00 45 00-5f 00 54 00 4f 00 54 00 |O.I.C.E. _.T.O.T.|
01d0 41 00 4c 00 00 00 08 00-38 09 54 00 52 00 41 00 |A.L..... 8.T.R.A.|
01e0 4e 00 5f 00 53 00 54 00-41 00 54 00 d1 0c 00 31 |N._.S.T. A.T....1|
01f0 00 34 00 30 00 39 00 2d-00 31 00 1b 00 56 49 33 |.4.0.9.- .1...VI3|
0200 34 37 30 37 34 37 34 36-32 30 30 38 30 39 30 34 |47074746 20080904|
0210 31 32 31 32 34 30 47 41-74 9b b7 02 0d 00 4a 6f |121240GA t.....Jo|
0220 68 6e 20 50 68 69 6c 6c-69 70 73 12 00 32 36 38 |hn Phill ips..268|
0230 35 20 4a 61 63 6b 73 6f-6e 20 52 6f 61 64 20 06 |5 Jackso n Road .|
0240 00 4d 6f 72 72 69 73 02-00 41 4c 05 00 33 35 31 |.Morris. .AL..351|
0250 31 36 0d 00 55 6e 69 74-65 64 20 53 74 61 74 65 |16..Unit ed State|
0260 73 0a 00 56 00 41 00 30-00 31 00 52 00 1a 00 46 |s..V.A.0 .1.R...F|
0270 65 64 45 78 20 47 72 6f-75 6e 64 20 48 6f 6d 65 |edEx Gro und Home|
0280 20 44 65 6c 69 76 65 72-79 12 00 56 00 41 00 2d | Deliver y..V.A.-|
0290 00 31 00 34 00 30 00 39-00 2d 00 31 00 06 00 43 |.1.4.0.9 .-.1...C|
02a0 36 37 34 37 37 0c 00 39-37 38 34 39 32 31 37 30 |67477..9 78492170|
02b0 38 33 38 13 00 44 65 63-20 31 36 20 32 30 30 38 |838..Dec 16 2008|
02c0 20 20 34 3a 34 31 50 4d-08 00 00 00 00 bc 4f 08 | 4:41PM ......O.|
02d0 00 1d 00 00 00 fd 10 00-c1 00 01 00 00 00 |........ ......|
dblib.c:3995:dbsqlok() marker is 81
dblib.c:3999:dbsqlok() found result token
dblib.c:1161:dbresults()
mem.c:519:tds_free_all_results()
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is 81(TDS7_RESULT)
mem.c:519:tds_free_all_results()
token.c:1472:processing TDS7 result. set current_results to tds->res_info
token.c:3395:adjust_character_column_size:
Server charset: UCS-2LE
Server column_size: 100
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 30 from wire to give 15 to client.
token.c:1414:tds7_get_data_info:
colname = VA_ORDER_NUMBER (15 bytes)
type = 39 (varchar)
server's type = 231 (x UCS-2 varchar)
column_varint_size = 2
column_size = 50 (100 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 20 from wire to give 10 to client.
token.c:1414:tds7_get_data_info:
colname = VA_BUYERID (10 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
read.c:179:tds_get_string: reading 36 from wire to give 18 to client.
token.c:1414:tds7_get_data_info:
colname = VA_ORDER_TIMESTAMP (18 bytes)
type = 58 (smalldatetime)
server's type = 58 (smalldatetime)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
token.c:1414:tds7_get_data_info:
colname = NAME (4 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 14 from wire to give 7 to client.
token.c:1414:tds7_get_data_info:
colname = ADDRESS (7 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
token.c:1414:tds7_get_data_info:
colname = CITY (4 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 10 from wire to give 5 to client.
token.c:1414:tds7_get_data_info:
colname = STATE (5 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 14 from wire to give 7 to client.
token.c:1414:tds7_get_data_info:
colname = ZIPCODE (7 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 14 from wire to give 7 to client.
token.c:1414:tds7_get_data_info:
colname = COUNTRY (7 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: UCS-2LE
Server column_size: 44
Client charset: ISO-8859-1
Client column_size: 22
read.c:179:tds_get_string: reading 18 from wire to give 9 to client.
token.c:1414:tds7_get_data_info:
colname = SHIP_CODE (9 bytes)
type = 39 (varchar)
server's type = 231 (x UCS-2 varchar)
column_varint_size = 2
column_size = 22 (44 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 16 from wire to give 8 to client.
token.c:1414:tds7_get_data_info:
colname = SHIP_VIA (8 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: UCS-2LE
Server column_size: 106
Client charset: ISO-8859-1
Client column_size: 53
read.c:179:tds_get_string: reading 30 from wire to give 15 to client.
token.c:1414:tds7_get_data_info:
colname = TH_ORDER_NUMBER (15 bytes)
type = 39 (varchar)
server's type = 231 (x UCS-2 varchar)
column_varint_size = 2
column_size = 53 (106 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 6
Client charset: ISO-8859-1
Client column_size: 6
read.c:179:tds_get_string: reading 34 from wire to give 17 to client.
token.c:1414:tds7_get_data_info:
colname = TH_INVOICE_NUMBER (17 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 6 (6 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 30 from wire to give 15 to client.
token.c:1414:tds7_get_data_info:
colname = TRACKING_NUMBER (15 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
Server charset: ISO-8859-1
Server column_size: 50
Client charset: ISO-8859-1
Client column_size: 50
read.c:179:tds_get_string: reading 26 from wire to give 13 to client.
token.c:1414:tds7_get_data_info:
colname = SHIP_DATETIME (13 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 50 (50 on server)
read.c:179:tds_get_string: reading 32 from wire to give 16 to client.
token.c:1414:tds7_get_data_info:
colname = TH_INVOICE_TOTAL (16 bytes)
type = 110 (money-null)
server's type = 110 (money-null)
column_varint_size = 1
column_size = 8 (8 on server)
read.c:179:tds_get_string: reading 18 from wire to give 9 to client.
token.c:1414:tds7_get_data_info:
colname = TRAN_STAT (9 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
util.c:119:Changing query state from READING to PENDING
dblib.c:1196:dbresults() process_result_tokens returned result_type = 4049 retcode = 1
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is d1(ROW)
util.c:119:Changing query state from READING to PENDING
dblib.c:1196:dbresults() process_result_tokens returned result_type = 4040 retcode = 1
dblib.c:1433:dbnextrow()
dblib.c:1447:dbnextrow() dbresults_state = 2
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is d1(ROW)
token.c:1863:tds_get_data: column 0, type 39, varint size 2
token.c:1920:processing row. column size is 12
token.c:1863:tds_get_data: column 1, type 39, varint size 2
token.c:1920:processing row. column size is 27
token.c:1863:tds_get_data: column 2, type 58, varint size 0
token.c:1920:processing row. column size is 4
token.c:2051:datetime4 116 155 183 2
token.c:1863:tds_get_data: column 3, type 39, varint size 2
token.c:1920:processing row. column size is 13
token.c:1863:tds_get_data: column 4, type 39, varint size 2
token.c:1920:processing row. column size is 18
token.c:1863:tds_get_data: column 5, type 39, varint size 2
token.c:1920:processing row. column size is 6
token.c:1863:tds_get_data: column 6, type 39, varint size 2
token.c:1920:processing row. column size is 2
token.c:1863:tds_get_data: column 7, type 39, varint size 2
token.c:1920:processing row. column size is 5
token.c:1863:tds_get_data: column 8, type 39, varint size 2
token.c:1920:processing row. column size is 13
token.c:1863:tds_get_data: column 9, type 39, varint size 2
token.c:1920:processing row. column size is 10
token.c:1863:tds_get_data: column 10, type 39, varint size 2
token.c:1920:processing row. column size is 26
token.c:1863:tds_get_data: column 11, type 39, varint size 2
token.c:1920:processing row. column size is 18
token.c:1863:tds_get_data: column 12, type 39, varint size 2
token.c:1920:processing row. column size is 6
token.c:1863:tds_get_data: column 13, type 39, varint size 2
token.c:1920:processing row. column size is 12
token.c:1863:tds_get_data: column 14, type 39, varint size 2
token.c:1920:processing row. column size is 19
token.c:1863:tds_get_data: column 15, type 110, varint size 1
token.c:1920:processing row. column size is 8
token.c:1863:tds_get_data: column 16, type 56, varint size 0
token.c:1920:processing row. column size is 4
util.c:119:Changing query state from READING to PENDING
dblib.c:1509:leaving dbnextrow() returning -1
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 6
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 27
convert.c:2776:tds_willconvert()
convert.c:2780:tds_willconvert() 58 47 1
dblib.c:2480:dbdatlen() type = 58
dblib.c:2486:leaving dbdatlen() returning 4
dblib.c:1620:dbconvert(58 [SYBDATETIME4] len 24 => 47 [SYBCHAR] len -1)
dblib.c:1760:dbconvert() calling tds_convert
dblib.c:1763:dbconvert() called tds_convert returned 26
dblib.c:1866:dbconvert() outputting 26 bytes character data destlen = -1
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 13
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 18
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 6
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 2
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 5
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 13
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 5
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 26
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 9
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 6
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 12
dblib.c:2480:dbdatlen() type = 39
dblib.c:2486:leaving dbdatlen() returning 19
dblib.c:1620:dbconvert(60 [SYBMONEY] len 8 => 62 [SYBFLT8] len -1)
dblib.c:1760:dbconvert() calling tds_convert
convert.c:1176:tds_convert_money()
dblib.c:1763:dbconvert() called tds_convert returned 8
dblib.c:1433:dbnextrow()
dblib.c:1447:dbnextrow() dbresults_state = 2
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens. marker is fd(DONE)
token.c:2143:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2159:tds_process_end() state set to TDS_IDLE
util.c:119:Changing query state from READING to IDLE
token.c:2175: rows_affected = 1
util.c:119:Changing query state from IDLE to PENDING
dblib.c:1509:leaving dbnextrow() returning -2
mem.c:519:tds_free_all_results()
util.c:119:Changing query state from IDLE to DEAD
dblib.c:4978:in dbfreebuf()