Skip to Content.
Sympa Menu

freetds - Re: [freetds] MSSql, Snow Leopard, & PHP

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Rob Booth <robert.booth AT bridgepointeducation.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] MSSql, Snow Leopard, & PHP
  • Date: Mon, 21 Jun 2010 11:08:47 -0700

Sorry for the delay but here is more from the logs and the PHP functions
that I'm using:
odbc_connect()
odbc_exec()

Entire log from sproc that doesn't work:

10:43:45.037273 41047 (log.c:196):Starting log file for FreeTDS
0.83.dev.20100522
on 2010-06-16 10:43:45 with debug flags 0xffff.
10:43:45.037313 41047 (iconv.c:337):tds_iconv_open(0x101b9f050, ISO-8859-1)
10:43:45.037338 41047 (iconv.c:197):local name for ISO-8859-1 is ISO-8859-1
10:43:45.037347 41047 (iconv.c:197):local name for UTF-8 is UTF-8
10:43:45.037356 41047 (iconv.c:197):local name for UCS-2LE is UCS-2LE
10:43:45.037364 41047 (iconv.c:197):local name for UCS-2BE is UCS-2BE
10:43:45.037372 41047 (iconv.c:365):setting up conversions for client
charset "ISO-8859-1"
10:43:45.037381 41047 (iconv.c:367):preparing iconv for "ISO-8859-1" <->
"UCS-2LE" conversion
10:43:45.037408 41047 (iconv.c:408):preparing iconv for "ISO-8859-1" <->
"UCS-2LE" conversion
10:43:45.037424 41047 (iconv.c:411):tds_iconv_open: done
10:43:45.037439 41047 (net.c:225):Connecting to 10.11.1.43 port 1433 (TDS
version 7.1)
10:43:45.037526 41047 (net.c:281):tds_open_socket: connect(2) returned
"Operation now in progress"
10:43:45.040401 41047 (net.c:321):tds_open_socket() succeeded
10:43:45.040472 41047 (util.c:162):Changed query state from DEAD to IDLE
10:43:45.040531 41047 (net.c:792):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 02 4d 53 53 51-4c 53 65 72 76 65 72 00 |U...MSSQ LServer.|
0030 57 a0 00 00 - |W...|

10:43:45.044358 41047 (net.c:608):Received header
0000 04 01 00 25 00 00 01 00- |...%....|

10:43:45.044425 41047 (net.c:662):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 09 00 0f |........ ........|
0020 c3 00 00 02 00 - |.....|

10:43:45.044474 41047 (login.c:1044):detected flag 2
10:43:45.044493 41047 (login.c:771):quietly sending TDS 7+ login packet
10:43:45.044549 41047 (token.c:328):tds_process_login_tokens()
10:43:45.050059 41047 (net.c:608):Received header
0000 04 01 01 89 00 34 01 00- |.....4..|

10:43:45.050167 41047 (net.c:662):Received packet
0000 04 01 01 89 00 34 01 00-e3 19 00 01 05 63 00 32 |.....4.. .....c.2|
0010 00 30 00 30 00 30 00 06-6d 00 61 00 73 00 74 00 |.0.0.0.. m.a.s.t.|
0020 65 00 72 00 ab 6e 00 45-16 00 00 02 00 24 00 43 |e.r..n.E .....$.C|
0030 00 68 00 61 00 6e 00 67-00 65 00 64 00 20 00 64 |.h.a.n.g .e.d. .d|
0040 00 61 00 74 00 61 00 62-00 61 00 73 00 65 00 20 |.a.t.a.b .a.s.e. |
0050 00 63 00 6f 00 6e 00 74-00 65 00 78 00 74 00 20 |.c.o.n.t .e.x.t. |
0060 00 74 00 6f 00 20 00 27-00 63 00 32 00 30 00 30 |.t.o. .' .c.2.0.0|
0070 00 30 00 27 00 2e 00 0d-43 00 56 00 31 00 31 00 |.0.'.... C.V.1.1.|
0080 42 00 2d 00 53 00 52 00-56 00 2d 00 53 00 51 00 |B.-.S.R. V.-.S.Q.|
0090 4c 00 00 01 00 e3 08 00-07 05 09 04 d0 00 34 00 |L....... ......4.|
00a0 e3 17 00 02 0a 75 00 73-00 5f 00 65 00 6e 00 67 |.....u.s ._.e.n.g|
00b0 00 6c 00 69 00 73 00 68-00 00 ab 74 00 47 16 00 |.l.i.s.h ...t.G..|
00c0 00 01 00 27 00 43 00 68-00 61 00 6e 00 67 00 65 |...'.C.h .a.n.g.e|
00d0 00 64 00 20 00 6c 00 61-00 6e 00 67 00 75 00 61 |.d. .l.a .n.g.u.a|
00e0 00 67 00 65 00 20 00 73-00 65 00 74 00 74 00 69 |.g.e. .s .e.t.t.i|
00f0 00 6e 00 67 00 20 00 74-00 6f 00 20 00 75 00 73 |.n.g. .t .o. .u.s|
0100 00 5f 00 65 00 6e 00 67-00 6c 00 69 00 73 00 68 |._.e.n.g .l.i.s.h|
0110 00 2e 00 0d 43 00 56 00-31 00 31 00 42 00 2d 00 |....C.V. 1.1.B.-.|
0120 53 00 52 00 56 00 2d 00-53 00 51 00 4c 00 00 01 |S.R.V.-. S.Q.L...|
0130 00 ad 36 00 01 71 00 00-01 16 4d 00 69 00 63 00 |..6..q.. ..M.i.c.|
0140 72 00 6f 00 73 00 6f 00-66 00 74 00 20 00 53 00 |r.o.s.o. f.t. .S.|
0150 51 00 4c 00 20 00 53 00-65 00 72 00 76 00 65 00 |Q.L. .S. e.r.v.e.|
0160 72 00 00 00 00 00 09 00-0f c3 e3 13 00 04 04 34 |r....... .......4|
0170 00 30 00 39 00 36 00 04-34 00 30 00 39 00 36 00 |.0.9.6.. 4.0.9.6.|
0180 fd 00 00 00 00 00 00 00-00 |........ .|

10:43:45.050379 41047 (token.c:337):looking for login token, got
e3(ENVCHANGE)
10:43:45.050421 41047 (token.c:122):tds_process_default_tokens() marker is
e3(ENVCHANGE)
10:43:45.050441 41047 (token.c:337):looking for login token, got ab(INFO)
10:43:45.050450 41047 (token.c:122):tds_process_default_tokens() marker is
ab(INFO)
10:43:45.050463 41047 (token.c:2708):tds_process_msg() reading message 5701
from server
10:43:45.050479 41047 (token.c:2781):tds_process_msg() calling client msg
handler
10:43:45.050488 41047 (odbc.c:2118):msgno 5701 20003
10:43:45.050504 41047 (token.c:2794):tds_process_msg() returning TDS_SUCCEED
10:43:45.050514 41047 (token.c:337):looking for login token, got
e3(ENVCHANGE)
10:43:45.050522 41047 (token.c:122):tds_process_default_tokens() marker is
e3(ENVCHANGE)
10:43:45.050531 41047 (token.c:2539):tds_process_env_chg(): 5 bytes of
collation data received
10:43:45.050539 41047 (token.c:2540):tds->collation was
0000 00 00 00 00 00 - |.....|

10:43:45.050552 41047 (iconv.c:1025):setting server single-byte charset to
"CP1252"
10:43:45.050568 41047 (token.c:2550):tds->collation now
0000 09 04 d0 00 34 - |....4|

10:43:45.050580 41047 (token.c:337):looking for login token, got
e3(ENVCHANGE)
10:43:45.050589 41047 (token.c:122):tds_process_default_tokens() marker is
e3(ENVCHANGE)
10:43:45.050599 41047 (token.c:337):looking for login token, got ab(INFO)
10:43:45.050608 41047 (token.c:122):tds_process_default_tokens() marker is
ab(INFO)
10:43:45.050617 41047 (token.c:2708):tds_process_msg() reading message 5703
from server
10:43:45.050627 41047 (token.c:2781):tds_process_msg() calling client msg
handler
10:43:45.050636 41047 (odbc.c:2118):msgno 5703 20003
10:43:45.050647 41047 (token.c:2794):tds_process_msg() returning TDS_SUCCEED
10:43:45.050655 41047 (token.c:337):looking for login token, got
ad(LOGINACK)
10:43:45.050664 41047 (token.c:372):server reports TDS version 71.0.0.1
10:43:45.050673 41047 (token.c:374):Product name for 0x71000001 is 2000 SP1
10:43:45.050683 41047 (token.c:337):looking for login token, got
e3(ENVCHANGE)
10:43:45.050692 41047 (token.c:122):tds_process_default_tokens() marker is
e3(ENVCHANGE)
10:43:45.050703 41047 (token.c:2597):changing block size from 4096 to 4096
10:43:45.050712 41047 (token.c:337):looking for login token, got fd(DONE)
10:43:45.050721 41047 (token.c:122):tds_process_default_tokens() marker is
fd(DONE)
10:43:45.050734 41047 (token.c:2459):tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
10:43:45.050743 41047 (token.c:2475):tds_process_end() state set to TDS_IDLE
10:43:45.050752 41047 (token.c:2490): rows_affected = 0
10:43:45.050760 41047 (token.c:437):tds_process_login_tokens() returning
TDS_SUCCEED
10:43:45.050778 41047 (mem.c:615):tds_free_all_results()
10:43:45.050787 41047 (util.c:162):Changed query state from IDLE to QUERYING
10:43:45.050796 41047 (write.c:140):tds_put_string converting 19 bytes of
"set textsize 64512 "
10:43:45.050806 41047 (write.c:168):tds_put_string wrote 38 bytes
10:43:45.050818 41047 (util.c:162):Changed query state from QUERYING to
PENDING
10:43:45.050827 41047 (net.c:792):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. .|

10:43:45.050880 41047 (token.c:539):tds_process_tokens(0x101b9f050,
0x7fff5fbfca8c, 0x7fff5fbfca88, 0x100)
10:43:45.050891 41047 (util.c:162):Changed query state from PENDING to
READING
10:43:45.053940 41047 (net.c:608):Received header
0000 04 01 00 11 00 34 01 00- |.....4..|

10:43:45.054019 41047 (net.c:662):Received packet
0000 04 01 00 11 00 34 01 00-fd 00 00 be 00 00 00 00 |.....4.. ........|
0010 00 - |.|

10:43:45.054075 41047 (token.c:554):processing result tokens. marker is
fd(DONE)
10:43:45.054084 41047 (token.c:2459):tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
10:43:45.054093 41047 (token.c:2475):tds_process_end() state set to TDS_IDLE
10:43:45.054117 41047 (util.c:162):Changed query state from READING to IDLE
10:43:45.054127 41047 (token.c:2490): rows_affected = 0
10:43:45.054135 41047 (util.c:110):logic error: cannot change query state
from IDLE to PENDING
10:43:45.054144 41047 (token.c:539):tds_process_tokens(0x101b9f050,
0x7fff5fbfca8c, 0x7fff5fbfca88, 0x100)
10:43:45.054153 41047 (token.c:542):tds_process_tokens() state is COMPLETED
10:43:45.054179 41047 (odbc.c:5734):SQLGetInfo(0x101b94c40, 23, 0x101b937a8,
2, 0x0)
10:43:45.054189 41047 (odbc.c:4988):_SQLGetInfo(0x101b94c40, 23,
0x101b937a8, 2, 0x0
10:43:45.054199 41047 (odbc.c:5734):SQLGetInfo(0x101b94c40, 24, 0x101b937aa,
2, 0x0)
10:43:45.054207 41047 (odbc.c:4988):_SQLGetInfo(0x101b94c40, 24,
0x101b937aa, 2, 0x0
10:43:45.054298 41047 (odbc.c:1590):SQLAllocStmt(0x101b94c40, 0x101ba48d8)
10:43:45.054309 41047 (odbc.c:1489):_SQLAllocStmt(0x101b94c40, 0x101ba48d8)
10:43:45.054333 41047 (odbc.c:4231):SQLGetStmtAttr(0x101b9e920, 10010,
0x101ba38b8, 0, 0x0)
10:43:45.054348 41047 (odbc.c:4231):SQLGetStmtAttr(0x101b9e920, 10011,
0x101ba38f8, 0, 0x0)
10:43:45.054358 41047 (odbc.c:4231):SQLGetStmtAttr(0x101b9e920, 10012,
0x101ba3938, 0, 0x0)
10:43:45.054368 41047 (odbc.c:4231):SQLGetStmtAttr(0x101b9e920, 10013,
0x101ba3978, 0, 0x0)
10:43:45.054388 41047 (odbc.c:5734):SQLGetInfo(0x101b94c40, 8,
0x7fff5fbfd908, 4, 0x0)
10:43:45.054398 41047 (odbc.c:4988):_SQLGetInfo(0x101b94c40, 8,
0x7fff5fbfd908, 4, 0x0
10:43:45.054415 41047 (odbc.c:6392):SQLSetStmtOption(0x101b9e920, 6, 3)
10:43:45.054424 41047 (odbc.c:6106):_SQLSetStmtAttr(0x101b9e920, 6, 0x3, -3)
10:43:45.054442 41047 (odbc.c:3312):SQLExecDirect(0x101b9e920, 0x102234c98,
-3)
10:43:45.054463 41047 (prepare_query.c:203):parsing 0 parameters
10:43:45.054476 41047 (odbc.c:3067):_SQLExecute(0x101b9e920)
10:43:45.054485 41047 (odbc.c:3072):_SQLExecute() starting with state 0
10:43:45.054499 41047 (query.c:2151):tds_cursor_declare() cursor id = 0
10:43:45.054515 41047 (query.c:2198):tds_cursor_open() cursor id = 0
10:43:45.054524 41047 (mem.c:615):tds_free_all_results()
10:43:45.054532 41047 (util.c:162):Changed query state from IDLE to QUERYING
10:43:45.054544 41047 (query.c:2328):tds_cursor_open (): RPC call set up
10:43:45.054552 41047 (query.c:2332):tds_cursor_open (): cursor open
completed
10:43:45.054561 41047 (net.c:792):Sending packet
0000 03 01 00 a4 00 00 01 00-ff ff 02 00 00 00 00 01 |........ ........|
0010 26 04 00 00 00 63 66 00-00 00 09 04 d0 00 34 66 |&....cf. ......4f|
0020 00 00 00 65 00 78 00 65-00 63 00 20 00 64 00 62 |...e.x.e .c. .d.b|
0030 00 6f 00 2e 00 75 00 73-00 70 00 6d 00 61 00 5f |.o...u.s .p.m.a._|
0040 00 66 00 61 00 53 00 74-00 75 00 64 00 65 00 6e |.f.a.S.t .u.d.e.n|
0050 00 74 00 4c 00 65 00 64-00 67 00 65 00 72 00 43 |.t.L.e.d .g.e.r.C|
0060 00 61 00 72 00 64 00 49-00 6e 00 66 00 6f 00 20 |.a.r.d.I .n.f.o. |
0070 00 27 00 52 00 4f 00 42-00 45 00 41 00 4e 00 32 |.'.R.O.B .E.A.N.2|
0080 00 33 00 34 00 36 00 27-00 00 01 26 04 04 08 00 |.3.4.6.' ...&....|
0090 00 00 00 01 26 04 04 01-20 00 00 00 01 26 04 04 |....&... ....&..|
00a0 00 00 00 00 - |....|

10:43:45.054653 41047 (util.c:162):Changed query state from QUERYING to
PENDING
10:43:45.054664 41047 (token.c:539):tds_process_tokens(0x101b9f050,
0x7fff5fbfd77c, 0x7fff5fbfd778, 0x100)
10:43:45.054673 41047 (util.c:162):Changed query state from PENDING to
READING
10:43:45.162374 41047 (net.c:608):Received header
0000 04 01 04 8e 00 34 01 00- |.....4..|

10:43:45.162481 41047 (net.c:662):Received packet
0000 04 01 04 8e 00 34 01 00-ab a4 00 3a 42 00 00 01 |.....4.. ...:B...|
0010 00 22 00 45 00 78 00 65-00 63 00 75 00 74 00 69 |.".E.x.e .c.u.t.i|
0020 00 6e 00 67 00 20 00 53-00 51 00 4c 00 20 00 64 |.n.g. .S .Q.L. .d|
0030 00 69 00 72 00 65 00 63-00 74 00 6c 00 79 00 3b |.i.r.e.c .t.l.y.;|
0040 00 20 00 6e 00 6f 00 20-00 63 00 75 00 72 00 73 |. .n.o. .c.u.r.s|
0050 00 6f 00 72 00 2e 00 0d-43 00 56 00 31 00 31 00 |.o.r.... C.V.1.1.|
0060 42 00 2d 00 53 00 52 00-56 00 2d 00 53 00 51 00 |B.-.S.R. V.-.S.Q.|
0070 4c 00 1d 75 00 73 00 70-00 6d 00 61 00 5f 00 66 |L..u.s.p .m.a._.f|
0080 00 61 00 53 00 74 00 75-00 64 00 65 00 6e 00 74 |.a.S.t.u .d.e.n.t|
0090 00 4c 00 65 00 64 00 67-00 65 00 72 00 43 00 61 |.L.e.d.g .e.r.C.a|
00a0 00 72 00 64 00 49 00 6e-00 66 00 6f 00 37 00 ff |.r.d.I.n .f.o.7..|
00b0 01 00 c6 00 00 00 00 00-ff 01 00 c8 00 00 00 00 |........ ........|
00c0 00 ff 11 00 c3 00 06 00-00 00 ff 11 00 c5 00 06 |........ ........|
00d0 00 00 00 81 0a 00 00 00-10 00 38 08 4c 00 65 00 |........ ..8.L.e.|
00e0 64 00 67 00 65 00 72 00-49 00 44 00 00 00 08 00 |d.g.e.r. I.D.....|
00f0 38 09 53 00 61 00 54 00-72 00 61 00 6e 00 73 00 |8.S.a.T. r.a.n.s.|
0100 69 00 64 00 00 00 08 00-38 07 54 00 72 00 61 00 |i.d..... 8.T.r.a.|
0110 6e 00 4e 00 75 00 6d 00-00 00 08 00 3d 04 44 00 |n.N.u.m. ....=.D.|
0120 61 00 74 00 65 00 00 00-08 00 a7 50 00 09 04 d0 |a.t.e... ...P....|
0130 00 34 04 54 00 79 00 70-00 65 00 00 00 08 00 a7 |.4.T.y.p .e......|
0140 64 00 09 04 d0 00 34 07-64 00 65 00 73 00 63 00 |d.....4. d.e.s.c.|
0150 72 00 69 00 70 00 00 00-09 00 6e 08 07 63 00 68 |r.i.p... ..n..c.h|
0160 00 61 00 72 00 67 00 65-00 73 00 00 00 09 00 6e |.a.r.g.e .s.....n|
0170 08 08 70 00 61 00 79 00-6d 00 65 00 6e 00 74 00 |..p.a.y. m.e.n.t.|
0180 73 00 00 00 09 00 6e 08-07 62 00 61 00 6c 00 61 |s.....n. .b.a.l.a|
0190 00 6e 00 63 00 65 00 00-00 09 00 a7 10 00 09 04 |.n.c.e.. ........|
01a0 d0 00 34 08 54 00 65 00-72 00 6d 00 4e 00 61 00 |..4.T.e. r.m.N.a.|
01b0 6d 00 65 00 d1 01 00 00-00 c0 7f 1c 00 01 00 00 |m.e..... ........|
01c0 00 70 9c 00 00 00 00 00-00 07 00 54 75 69 74 69 |.p...... ...Tuiti|
01d0 6f 6e 1b 00 50 53 59 20-36 33 30 30 3a 20 41 64 |on..PSY 6300: Ad|
01e0 75 6c 74 20 44 65 76 65-6c 6f 70 6d 65 6e 74 08 |ult Deve lopment.|
01f0 00 00 00 00 00 f8 24 01-00 08 00 00 00 00 00 f8 |......$. ........|
0200 24 01 10 00 36 5f 30 39-33 35 20 20 20 20 20 20 |$...6_09 35 |
0210 20 20 20 20 d1 02 00 00-00 ec 9a 1e 00 02 00 00 | .... ........|
0220 00 8c 9c 00 00 00 00 00-00 22 00 46 65 64 65 72 |........ .".Feder|
0230 61 6c 20 55 6e 73 75 62-73 69 64 69 7a 65 64 20 |al Unsub sidized |
0240 53 74 61 66 66 6f 72 64-20 4c 6f 61 6e 28 00 46 |Stafford Loan(.F|
0250 65 64 65 72 61 6c 20 55-6e 73 75 62 73 69 64 69 |ederal U nsubsidi|
0260 7a 65 64 20 53 74 61 66-66 6f 72 64 20 4c 6f 61 |zed Staf ford Loa|
0270 6e 20 32 30 30 39 2d 00-08 00 00 00 00 c4 90 04 |n 2009-. ........|
0280 06 08 ff ff ff ff 3c 67-20 fb ff ff d1 03 00 00 |......<g .......|
0290 00 16 8f 1f 00 03 00 00-00 96 9c 00 00 50 36 d3 |........ .....P6.|
02a0 00 07 00 50 61 79 6d 65-6e 74 1b 00 53 74 69 70 |...Payme nt..Stip|
02b0 65 6e 64 20 2d 20 20 55-52 46 55 4e 53 55 42 20 |end - U RFUNSUB |
02c0 32 30 30 39 2d 31 30 00-08 ff ff ff ff dc 7c 90 |2009-10. ......|.|
02d0 fd 08 ff ff ff ff 60 ea-8f fd ff ff d1 04 00 00 |......`. ........|
02e0 00 02 69 22 00 04 00 00-00 af 9c 00 00 00 00 00 |..i".... ........|
02f0 00 07 00 54 75 69 74 69-6f 6e 3a 00 4f 52 47 20 |...Tuiti on:.ORG |
0300 35 32 37 30 3a 20 4d 65-6e 74 61 6c 20 48 65 61 |5270: Me ntal Hea|
0310 6c 74 68 20 26 20 50 73-79 63 68 6f 70 61 74 68 |lth & Ps ychopath|
0320 6f 6c 6f 67 79 20 69 6e-20 74 68 65 20 57 6f 72 |ology in the Wor|
0330 6b 70 6c 61 63 65 08 00-00 00 00 00 f8 24 01 00 |kplace.. .....$..|
0340 08 ff ff ff ff 60 e2 b4-fe 10 00 36 5f 30 39 34 |.....`.. ...6_094|
0350 34 20 20 20 20 20 20 20-20 20 20 d1 05 00 00 00 |4 .....|
0360 43 e7 26 00 05 00 00 00-d9 9c 00 00 00 00 00 00 |C.&..... ........|
0370 07 00 54 75 69 74 69 6f-6e 3b 00 4f 52 47 20 36 |..Tuitio n;.ORG 6|
0380 35 33 30 3a 20 54 68 65-6f 72 69 65 73 20 26 20 |530: The ories & |
0390 54 65 63 68 6e 69 71 75-65 73 20 6f 66 20 43 6f |Techniqu es of Co|
03a0 75 6e 73 65 6c 69 6e 67-26 50 73 79 63 68 6f 74 |unseling &Psychot|
03b0 68 65 72 61 70 79 08 00-00 00 00 00 f8 24 01 00 |herapy.. .....$..|
03c0 08 ff ff ff ff 60 da d9-ff 10 00 36 5f 30 39 35 |.....`.. ...6_095|
03d0 30 20 20 20 20 20 20 20-20 20 20 d1 06 00 00 00 |0 .....|
03e0 fc 39 28 00 06 00 00 00-ee 9c 00 00 00 00 00 00 |.9(..... ........|
03f0 0e 00 54 65 63 68 6e 6f-6c 6f 67 79 20 46 65 65 |..Techno logy Fee|
0400 0e 00 54 65 63 68 6e 6f-6c 6f 67 79 20 46 65 65 |..Techno logy Fee|
0410 08 00 00 00 00 a0 25 26-00 00 08 00 00 00 00 00 |......%& ........|
0420 00 00 00 ff ff ff 11 00-c1 00 06 00 00 00 ff 01 |........ ........|
0430 00 c7 00 00 00 00 00 ff-01 00 e0 00 00 00 00 00 |........ ........|
0440 79 00 00 00 00 ac 0d 00-00 01 00 00 00 00 26 04 |y....... ......&.|
0450 04 00 00 00 00 ac 0d 00-00 01 00 00 00 00 26 04 |........ ......&.|
0460 04 08 00 00 00 ac 0d 00-00 01 00 00 00 00 26 04 |........ ......&.|
0470 04 01 20 00 00 ac 0d 00-00 01 00 00 00 00 26 04 |.. ..... ......&.|
0480 04 00 00 00 00 fe 00 00-e0 00 00 00 00 00 |........ ......|

10:43:45.163487 41047 (token.c:554):processing result tokens. marker is
ab(INFO)
10:43:45.163506 41047 (token.c:122):tds_process_default_tokens() marker is
ab(INFO)
10:43:45.163523 41047 (token.c:2708):tds_process_msg() reading message 16954
from server
10:43:45.163563 41047 (token.c:2794):tds_process_msg() returning TDS_SUCCEED
10:43:45.163579 41047 (token.c:554):processing result tokens. marker is
ff(DONEINPROC)
10:43:45.163595 41047 (token.c:2459):tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
10:43:45.163610 41047 (token.c:2490): rows_affected = 0
10:43:45.163625 41047 (token.c:554):processing result tokens. marker is
ff(DONEINPROC)
10:43:45.163640 41047 (token.c:2459):tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
10:43:45.163655 41047 (token.c:2490): rows_affected = 0
10:43:45.163669 41047 (token.c:554):processing result tokens. marker is
ff(DONEINPROC)
10:43:45.163684 41047 (token.c:2459):tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
10:43:45.163699 41047 (token.c:2490): rows_affected = 6
10:43:45.163713 41047 (token.c:554):processing result tokens. marker is
ff(DONEINPROC)
10:43:45.163728 41047 (token.c:2459):tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
10:43:45.163742 41047 (token.c:2490): rows_affected = 6
10:43:45.163757 41047 (token.c:554):processing result tokens. marker is
81(TDS7_RESULT)
10:43:45.163772 41047 (token.c:1570):processing TDS7 result metadata.
10:43:45.163786 41047 (mem.c:615):tds_free_all_results()
10:43:45.163860 41047 (token.c:1591):set current_results to cursor->res_info
10:43:45.163876 41047 (token.c:1601):setting up 10 columns
10:43:45.163911 41047 (token.c:1541):tds7_get_data_info:
colname = LedgerID (8 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
10:43:45.163931 41047 (token.c:1541):tds7_get_data_info:
colname = SaTransid (9 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
10:43:45.163949 41047 (token.c:1541):tds7_get_data_info:
colname = TranNum (7 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
10:43:45.163967 41047 (token.c:1541):tds7_get_data_info:
colname = Date (4 bytes)
type = 61 (datetime)
server's type = 61 (datetime)
column_varint_size = 0
column_size = 8 (8 on server)
10:43:45.163987 41047 (token.c:1541):tds7_get_data_info:
colname = Type (4 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 80 (80 on server)
10:43:45.164005 41047 (token.c:1541):tds7_get_data_info:
colname = descrip (7 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 100 (100 on server)
10:43:45.164023 41047 (token.c:1541):tds7_get_data_info:
colname = charges (7 bytes)
type = 110 (money-null)
server's type = 110 (money-null)
column_varint_size = 1
column_size = 8 (8 on server)
10:43:45.164042 41047 (token.c:1541):tds7_get_data_info:
colname = payments (8 bytes)
type = 110 (money-null)
server's type = 110 (money-null)
column_varint_size = 1
column_size = 8 (8 on server)
10:43:45.164077 41047 (token.c:1541):tds7_get_data_info:
colname = balance (7 bytes)
type = 110 (money-null)
server's type = 110 (money-null)
column_varint_size = 1
column_size = 8 (8 on server)
10:43:45.164097 41047 (token.c:1541):tds7_get_data_info:
colname = TermName (8 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 16 (16 on server)
10:43:45.164114 41047 (token.c:1610): name size/wsize
type/wtype utype
10:43:45.164130 41047 (token.c:1611): -------------------- ---------------
--------------- -------
10:43:45.164145 41047 (token.c:1621): LedgerID 4/4
56/56 0
10:43:45.164161 41047 (token.c:1621): SaTransid 4/4
56/56 0
10:43:45.164177 41047 (token.c:1621): TranNum 4/4
56/56 0
10:43:45.164192 41047 (token.c:1621): Date 8/8
61/61 0
10:43:45.164208 41047 (token.c:1621): Type 80/80
39/167 0
10:43:45.164223 41047 (token.c:1621): descrip 100/100
39/167 0
10:43:45.164239 41047 (token.c:1621): charges 8/8
110/110 0
10:43:45.164254 41047 (token.c:1621): payments 8/8
110/110 0
10:43:45.164270 41047 (token.c:1621): balance 8/8
110/110 0
10:43:45.164285 41047 (token.c:1621): TermName 16/16
39/167 0
10:43:45.164303 41047 (token.c:554):processing result tokens. marker is
d1(ROW)
10:43:45.164318 41047 (token.c:656):tds_process_tokens(). set
current_results to cursor->res_info
10:43:45.164333 41047 (token.c:2424):tds_process_row(): reading column 0
10:43:45.164347 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.164362 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.164377 41047 (token.c:2424):tds_process_row(): reading column 1
10:43:45.164391 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.164406 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.164420 41047 (token.c:2424):tds_process_row(): reading column 2
10:43:45.164434 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.164449 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.164463 41047 (token.c:2424):tds_process_row(): reading column 3
10:43:45.164477 41047 (token.c:2169):tds_get_data: type 61, varint size 0
10:43:45.164492 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.164506 41047 (token.c:2424):tds_process_row(): reading column 4
10:43:45.164520 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.164535 41047 (token.c:2230):tds_get_data(): wire column size is 7
10:43:45.164549 41047 (token.c:2424):tds_process_row(): reading column 5
10:43:45.164563 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.164578 41047 (token.c:2230):tds_get_data(): wire column size is 27
10:43:45.164592 41047 (token.c:2424):tds_process_row(): reading column 6
10:43:45.164606 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.164621 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.164635 41047 (token.c:2424):tds_process_row(): reading column 7
10:43:45.164649 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.164664 41047 (token.c:2230):tds_get_data(): wire column size is -1
10:43:45.164678 41047 (token.c:2424):tds_process_row(): reading column 8
10:43:45.164692 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.164707 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.164721 41047 (token.c:2424):tds_process_row(): reading column 9
10:43:45.164735 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.164750 41047 (token.c:2230):tds_get_data(): wire column size is 16
10:43:45.164764 41047 (token.c:554):processing result tokens. marker is
d1(ROW)
10:43:45.164795 41047 (token.c:656):tds_process_tokens(). set
current_results to cursor->res_info
10:43:45.164810 41047 (token.c:2424):tds_process_row(): reading column 0
10:43:45.164825 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.164839 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.164854 41047 (token.c:2424):tds_process_row(): reading column 1
10:43:45.164868 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.164882 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.164897 41047 (token.c:2424):tds_process_row(): reading column 2
10:43:45.164911 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.164925 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.164940 41047 (token.c:2424):tds_process_row(): reading column 3
10:43:45.164954 41047 (token.c:2169):tds_get_data: type 61, varint size 0
10:43:45.164968 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.164983 41047 (token.c:2424):tds_process_row(): reading column 4
10:43:45.164997 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.165011 41047 (token.c:2230):tds_get_data(): wire column size is 34
10:43:45.165026 41047 (token.c:2424):tds_process_row(): reading column 5
10:43:45.165040 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.165055 41047 (token.c:2230):tds_get_data(): wire column size is 40
10:43:45.165069 41047 (token.c:2424):tds_process_row(): reading column 6
10:43:45.165083 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.165098 41047 (token.c:2230):tds_get_data(): wire column size is -1
10:43:45.165112 41047 (token.c:2424):tds_process_row(): reading column 7
10:43:45.165126 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.165140 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.165155 41047 (token.c:2424):tds_process_row(): reading column 8
10:43:45.165169 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.165183 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.165197 41047 (token.c:2424):tds_process_row(): reading column 9
10:43:45.165211 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.165226 41047 (token.c:2230):tds_get_data(): wire column size is -1
10:43:45.165240 41047 (token.c:554):processing result tokens. marker is
d1(ROW)
10:43:45.165255 41047 (token.c:656):tds_process_tokens(). set
current_results to cursor->res_info
10:43:45.165269 41047 (token.c:2424):tds_process_row(): reading column 0
10:43:45.165283 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.165298 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.165312 41047 (token.c:2424):tds_process_row(): reading column 1
10:43:45.165326 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.165340 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.165355 41047 (token.c:2424):tds_process_row(): reading column 2
10:43:45.165369 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.165383 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.165397 41047 (token.c:2424):tds_process_row(): reading column 3
10:43:45.165412 41047 (token.c:2169):tds_get_data: type 61, varint size 0
10:43:45.165426 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.165440 41047 (token.c:2424):tds_process_row(): reading column 4
10:43:45.165454 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.165469 41047 (token.c:2230):tds_get_data(): wire column size is 7
10:43:45.165483 41047 (token.c:2424):tds_process_row(): reading column 5
10:43:45.165497 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.165511 41047 (token.c:2230):tds_get_data(): wire column size is 27
10:43:45.165526 41047 (token.c:2424):tds_process_row(): reading column 6
10:43:45.165540 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.165554 41047 (token.c:2230):tds_get_data(): wire column size is -1
10:43:45.165585 41047 (token.c:2424):tds_process_row(): reading column 7
10:43:45.165600 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.165614 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.165629 41047 (token.c:2424):tds_process_row(): reading column 8
10:43:45.165642 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.165657 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.165671 41047 (token.c:2424):tds_process_row(): reading column 9
10:43:45.165685 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.165699 41047 (token.c:2230):tds_get_data(): wire column size is -1
10:43:45.165714 41047 (token.c:554):processing result tokens. marker is
d1(ROW)
10:43:45.165728 41047 (token.c:656):tds_process_tokens(). set
current_results to cursor->res_info
10:43:45.165742 41047 (token.c:2424):tds_process_row(): reading column 0
10:43:45.165756 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.165771 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.165785 41047 (token.c:2424):tds_process_row(): reading column 1
10:43:45.165799 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.165813 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.165828 41047 (token.c:2424):tds_process_row(): reading column 2
10:43:45.165842 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.165857 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.165871 41047 (token.c:2424):tds_process_row(): reading column 3
10:43:45.165885 41047 (token.c:2169):tds_get_data: type 61, varint size 0
10:43:45.165899 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.165914 41047 (token.c:2424):tds_process_row(): reading column 4
10:43:45.165928 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.165942 41047 (token.c:2230):tds_get_data(): wire column size is 7
10:43:45.165956 41047 (token.c:2424):tds_process_row(): reading column 5
10:43:45.165971 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.165985 41047 (token.c:2230):tds_get_data(): wire column size is 58
10:43:45.165999 41047 (token.c:2424):tds_process_row(): reading column 6
10:43:45.166013 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.166028 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.166042 41047 (token.c:2424):tds_process_row(): reading column 7
10:43:45.166056 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.166071 41047 (token.c:2230):tds_get_data(): wire column size is -1
10:43:45.166085 41047 (token.c:2424):tds_process_row(): reading column 8
10:43:45.166099 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.166113 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.166127 41047 (token.c:2424):tds_process_row(): reading column 9
10:43:45.166141 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.166156 41047 (token.c:2230):tds_get_data(): wire column size is 16
10:43:45.166170 41047 (token.c:554):processing result tokens. marker is
d1(ROW)
10:43:45.166185 41047 (token.c:656):tds_process_tokens(). set
current_results to cursor->res_info
10:43:45.166199 41047 (token.c:2424):tds_process_row(): reading column 0
10:43:45.166213 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.166227 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.166242 41047 (token.c:2424):tds_process_row(): reading column 1
10:43:45.166256 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.166270 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.166284 41047 (token.c:2424):tds_process_row(): reading column 2
10:43:45.166298 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.166313 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.166327 41047 (token.c:2424):tds_process_row(): reading column 3
10:43:45.166341 41047 (token.c:2169):tds_get_data: type 61, varint size 0
10:43:45.166370 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.166386 41047 (token.c:2424):tds_process_row(): reading column 4
10:43:45.166400 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.166415 41047 (token.c:2230):tds_get_data(): wire column size is 7
10:43:45.166429 41047 (token.c:2424):tds_process_row(): reading column 5
10:43:45.166443 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.166457 41047 (token.c:2230):tds_get_data(): wire column size is 59
10:43:45.166472 41047 (token.c:2424):tds_process_row(): reading column 6
10:43:45.166486 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.166500 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.166514 41047 (token.c:2424):tds_process_row(): reading column 7
10:43:45.166528 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.166543 41047 (token.c:2230):tds_get_data(): wire column size is -1
10:43:45.166557 41047 (token.c:2424):tds_process_row(): reading column 8
10:43:45.166571 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.166585 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.166599 41047 (token.c:2424):tds_process_row(): reading column 9
10:43:45.166613 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.166627 41047 (token.c:2230):tds_get_data(): wire column size is 16
10:43:45.166642 41047 (token.c:554):processing result tokens. marker is
d1(ROW)
10:43:45.166656 41047 (token.c:656):tds_process_tokens(). set
current_results to cursor->res_info
10:43:45.166671 41047 (token.c:2424):tds_process_row(): reading column 0
10:43:45.166685 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.166699 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.166713 41047 (token.c:2424):tds_process_row(): reading column 1
10:43:45.166727 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.166742 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.166756 41047 (token.c:2424):tds_process_row(): reading column 2
10:43:45.166770 41047 (token.c:2169):tds_get_data: type 56, varint size 0
10:43:45.166784 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.166798 41047 (token.c:2424):tds_process_row(): reading column 3
10:43:45.166812 41047 (token.c:2169):tds_get_data: type 61, varint size 0
10:43:45.166827 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.166841 41047 (token.c:2424):tds_process_row(): reading column 4
10:43:45.166855 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.166869 41047 (token.c:2230):tds_get_data(): wire column size is 14
10:43:45.166883 41047 (token.c:2424):tds_process_row(): reading column 5
10:43:45.166897 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.166912 41047 (token.c:2230):tds_get_data(): wire column size is 14
10:43:45.166926 41047 (token.c:2424):tds_process_row(): reading column 6
10:43:45.166940 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.166954 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.166978 41047 (token.c:2424):tds_process_row(): reading column 7
10:43:45.166992 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.167006 41047 (token.c:2230):tds_get_data(): wire column size is -1
10:43:45.167021 41047 (token.c:2424):tds_process_row(): reading column 8
10:43:45.167035 41047 (token.c:2169):tds_get_data: type 110, varint size 1
10:43:45.167049 41047 (token.c:2230):tds_get_data(): wire column size is 8
10:43:45.167063 41047 (token.c:2424):tds_process_row(): reading column 9
10:43:45.167077 41047 (token.c:2169):tds_get_data: type 39, varint size 2
10:43:45.167092 41047 (token.c:2230):tds_get_data(): wire column size is -1
10:43:45.167106 41047 (token.c:554):processing result tokens. marker is
ff(DONEINPROC)
10:43:45.167121 41047 (token.c:2459):tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
10:43:45.167159 41047 (token.c:2490): rows_affected = 6
10:43:45.167174 41047 (token.c:554):processing result tokens. marker is
ff(DONEINPROC)
10:43:45.167190 41047 (token.c:2459):tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
10:43:45.167205 41047 (token.c:2490): rows_affected = 0
10:43:45.167220 41047 (token.c:554):processing result tokens. marker is
ff(DONEINPROC)
10:43:45.167234 41047 (token.c:2459):tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
10:43:45.167249 41047 (token.c:2490): rows_affected = 0
10:43:45.167264 41047 (token.c:554):processing result tokens. marker is
79(RETURNSTATUS)
10:43:45.167278 41047 (token.c:554):processing result tokens. marker is
ac(PARAM)
10:43:45.167293 41047 (token.c:611):processing parameters for sp 2
10:43:45.167307 41047 (token.c:613):calling tds_process_param_result
10:43:45.167321 41047 (token.c:1242):tds_process_param_result(0x101b9f050,
0x7fff5fbfd6f8)
10:43:45.167338 41047 (token.c:1645):tds_get_data_info(0x101b9f050,
0x100a1f200, 1) [for parameter]
10:43:45.167355 41047 (token.c:1708):processing result. type =
38(integer-null), varint_size 1
10:43:45.167370 41047 (token.c:1734):processing result. column_size 4
10:43:45.167385 41047 (token.c:2169):tds_get_data: type 38, varint size 1
10:43:45.167399 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.167414 41047 (log.c:493):type integer-null has value 0
10:43:45.167428 41047 (token.c:613):calling tds_process_param_result
10:43:45.167442 41047 (token.c:1242):tds_process_param_result(0x101b9f050,
0x7fff5fbfd6f8)
10:43:45.167458 41047 (token.c:1645):tds_get_data_info(0x101b9f050,
0x100a1f800, 1) [for parameter]
10:43:45.167473 41047 (token.c:1708):processing result. type =
38(integer-null), varint_size 1
10:43:45.167488 41047 (token.c:1734):processing result. column_size 4
10:43:45.167503 41047 (token.c:2169):tds_get_data: type 38, varint size 1
10:43:45.167518 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.167532 41047 (log.c:493):type integer-null has value 8
10:43:45.167546 41047 (token.c:613):calling tds_process_param_result
10:43:45.167560 41047 (token.c:1242):tds_process_param_result(0x101b9f050,
0x7fff5fbfd6f8)
10:43:45.167593 41047 (token.c:1645):tds_get_data_info(0x101b9f050,
0x100a1fe00, 1) [for parameter]
10:43:45.167610 41047 (token.c:1708):processing result. type =
38(integer-null), varint_size 1
10:43:45.167625 41047 (token.c:1734):processing result. column_size 4
10:43:45.167640 41047 (token.c:2169):tds_get_data: type 38, varint size 1
10:43:45.167654 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.167669 41047 (log.c:493):type integer-null has value 8193
10:43:45.167683 41047 (token.c:613):calling tds_process_param_result
10:43:45.167697 41047 (token.c:1242):tds_process_param_result(0x101b9f050,
0x7fff5fbfd6f8)
10:43:45.167712 41047 (token.c:1645):tds_get_data_info(0x101b9f050,
0x100a20400, 1) [for parameter]
10:43:45.167728 41047 (token.c:1708):processing result. type =
38(integer-null), varint_size 1
10:43:45.167742 41047 (token.c:1734):processing result. column_size 4
10:43:45.167757 41047 (token.c:2169):tds_get_data: type 38, varint size 1
10:43:45.167771 41047 (token.c:2230):tds_get_data(): wire column size is 4
10:43:45.167785 41047 (log.c:493):type integer-null has value 0
10:43:45.167800 41047 (token.c:617):4 hidden return parameters
10:43:45.167814 41047 (token.c:624):stored internal cursor id 0
10:43:45.167832 41047 (token.c:554):processing result tokens. marker is
fe(DONEPROC)
10:43:45.167847 41047 (token.c:2459):tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
10:43:45.167863 41047 (token.c:2475):tds_process_end() state set to TDS_IDLE
10:43:45.167877 41047 (util.c:162):Changed query state from READING to IDLE
10:43:45.167892 41047 (token.c:2490): rows_affected = 0
10:43:45.167906 41047 (util.c:110):logic error: cannot change query state
from IDLE to PENDING
10:43:45.167938 41047 (token.c:539):tds_process_tokens(0x101b9f050,
0x7fff5fbfd77c, 0x7fff5fbfd778, 0x100)
10:43:45.167955 41047 (token.c:542):tds_process_tokens() state is COMPLETED
10:43:45.167978 41047 (mem.c:942):tds_cursor_deallocated() : freeing
cursor_id 0
10:43:45.167994 41047 (mem.c:967):tds_cursor_deallocated() : cursor_id 0
found
10:43:45.168008 41047 (mem.c:971):tds_cursor_deallocated() : relinking list
10:43:45.168022 41047 (mem.c:978):tds_cursor_deallocated() : relinked list
10:43:45.168036 41047 (mem.c:994):tds_release_cursor() : freeing cursor_id 0
10:43:45.168050 41047 (mem.c:996):tds_release_cursor() : freeing cursor
results
10:43:45.168068 41047 (mem.c:1002):tds_release_cursor() : freeing cursor
name
10:43:45.168083 41047 (mem.c:1007):tds_release_cursor() : freeing cursor
query
10:43:45.168098 41047 (mem.c:1011):tds_release_cursor() : cursor_id 0 freed
10:43:45.168120 41047 (token.c:539):tds_process_tokens(0x101b9f050,
0x7fff5fbfd76c, 0x7fff5fbfd768, 0x6914)
10:43:45.168136 41047 (token.c:542):tds_process_tokens() state is COMPLETED
10:43:45.168150 41047 (odbc.c:3383):odbc_process_tokens: tds_process_tokens
returned 2
10:43:45.168165 41047 (odbc.c:3384): result_type=4052, TDS_DONE_COUNT=0,
TDS_DONE_ERROR=0
10:43:45.168180 41047 (odbc.c:3223):_SQLExecute: odbc_process_tokens
returned result_type 4046
10:43:45.168222 41047 (odbc.c:4252):SQLNumResultCols(0x101b9e920,
0x7fff5fbfd80e)
10:43:45.168247 41047 (odbc.c:4252):SQLNumResultCols(0x101b9e920,
0x7fff5fbfd86e)
10:43:45.169213 41047 (odbc.c:3997):SQLFreeStmt(0x101b9e920, 1)
10:43:45.169235 41047 (odbc.c:3918):_SQLFreeStmt(0x101b9e920, 1, 0)
10:43:45.174371 41047 (odbc.c:2091):SQLDisconnect(0x101b94c40)
10:43:45.174421 41047 (mem.c:615):tds_free_all_results()
10:43:45.174487 41047 (util.c:162):Changed query state from IDLE to DEAD
10:43:45.174509 41047 (odbc.c:3829):SQLFreeHandle(2, 0x101b94c40)
10:43:45.174522 41047 (odbc.c:3855):_SQLFreeConnect(0x101b94c40)
10:43:45.174537 41047 (odbc.c:3829):SQLFreeHandle(1, 0x101b937d0)
10:43:45.174549 41047 (odbc.c:3893):_SQLFreeEnv(0x101b937d0)



On 6/18/10 5:59 AM, "Frediano Ziglio" <freddy77 AT gmail.com> wrote:

> Could you post some more lot, describing what query are you issuing to
server
> and how (which PHP functions are you using) ?

freddy77

2010/6/16 Rob Booth
> <robert.booth AT bridgepointeducation.com>:
> Ok, I've now tried this with 0.82.1
> and 0.83 with the same results. ?Let me
> know if there is any other
> information that I can supply to help figure this
> out.
>
> Thanks,
>
> Rob
>
>
> On 6/16/10 12:43 AM, "Frediano Ziglio" <freddy77 AT gmail.com>
> wrote:
>
>>> 2010/6/15 Rob Booth
> <robert.booth AT bridgepointeducation.com>:
>
>>> I sent an email to the list a
> week or so ago about this, but didn¹t get any
>
>>> responses so I thought I¹d
> try again. ?I installed freetds-0.82 on my Mac
>
>>> after upgrading to Snow
> Leopard. ?Everything seemed to go fine until I ran
>
>>> into some stored
> procedure calls from my PHP code that returned this
>>> error:
>
>>>
>>>³No
> tuples available at this result index²
>
>>>
>
>>> After looking into the logs
> and searching the internet I wasn¹t able to
>>> find
> any solution. ?I did
> however see that when I call a stored procedure
>>> that works and one that
> doesn¹t I get some different results.
>
>>>
>
>>> Good Results Log:
>
>>>
> 13:04:15.516355 1650
>>> (net.c:671):Received packet
>> 0000 81 22 00 00 00 01
> 00 a7-0a 00 09 04 d0 00
>>> 34 04 |."...... ......4.|
>> 0010 62 00 62 00 69
> 00 64 00-00 00 10 00 38 0b 53
>>> 00 |b.b.i.d. ....8.S.|
>> 0020 79 00 53 00
> 74 00 75 00-64 00 65 00 6e 00 74 00
>>> |y.S.t.u. d.e.n.t.|
>> 0030 49 00 44
> 00 00 00 01 00-a7 34 00 09 04 d0 00 34
>>> |I.D..... .4.....4|
>> 0040 0b 73
> 00 74 00 75 00 64-00 65 00 6e 00 74 00 4e
>>> |.s.t.u.d .e.n.t.N|
>> 0050 00
> 61 00 6d 00 65 00 00-00 09 00 af 23 00 09 04
>>> |.a.m.e.. ....#...|
>> 0060
> d0 00 34 04 74 00 65 00-72 00 6d 00 00 00 01 00
>>> |..4.t.e. r.m.....|
>>
> 0070 a7 0c 00 09 04 d0 00 34-0a 63 00 6f 00 75 00 72
>>> |.......4
> .c.o.u.r|
>> 0080 00 73 00 65 00 43 00 6f-00 64 00 65 00 00 00 08
>>>
> |.s.e.C.o .d.e....|
>> 0090 00 a7 4b 00 09 04 d0 00-34 0a 63 00 6f 00 75
> 00
>>> |..K..... 4.c.o.u.|
>>
>> 13:04:15.518419 1650 (token.c:573):4 hidden
> return
>>> parameters
>
>>> 13:04:15.518427 1650 (token.c:580):stored internal
> cursor id
>>> 180150003
>
>>>
>
>>> Bad Results Log:
>> 13:04:34.240256 1649
> (net.c:671):Received
>>> packet
>
>>> 0000 ab 9e 00 3a 42 00 00 01-00 22 00 45
> 00 78 00 65 |...:B....".E.x.e|
>
>>> 0010 00 63 00 75 00 74 00 69-00 6e 00 67
> 00 20 00 53 |.c.u.t.i.n.g. .S|
>
>>> 0020 00 51 00 4c 00 20 00 64-00 69 00 72
> 00 65 00 63 |.Q.L. .d.i.r.e.c|
>
>>> 0030 00 74 00 6c 00 79 00 3b-00 20 00 6e
> 00 6f 00 20 |.t.l.y.; ..n.o. |
>
>>> 0040 00 63 00 75 00 72 00 73-00 6f 00 72
> 00 2e 00 0a |.c.u.r.s.o.r....|
>
>>> 0050 41 00 55 00 43 00 41 00-2d 00 53 00
> 51 00 4c 00 |A.U.C.A.-.S.Q.L.|
>
>>> 0060 30 00 32 00 1d 75 00 73-00 70 00 6d
> 00 61 00 5f |0.2..u.s.p.m.a._|
>
>>> 0070 00 66 00 61 00 53 00 74-00 75 00 64
> 00 65 00 6e |.f.a.S.t.u.d.e.n|
>
>>> 0080 00 74 00 4c 00 65 00 64-00 67 00 65
> 00 72 00 43 |.t.L.e.d.g.e.r.C|
>
>>> 0090 00 61 00 72 00 64 00 49-00 6e 00 66
> 00 6f 00 37 |.a.r.d.I.n.f.o.7|
>
>>> 00a0 00 ff 01 00 c6 00 00 00-00 00 ff 01
> 00 c8 00 00 |................|
>
>>> 00b0 00 00 00 ff 11 00 c3 00-0c 00 00 00
> ff 11 00 c5 |................|
>
>>> 00c0 00 0c 00 00 00 81 0a 00-00 00 10 00
> 38 08 4c 00 |............8.L.|
>
>>> 00d0 65 00 64 00 67 00 65 00-72 00 49 00
> 44 00 00 00 |e.d.g.e.r.I.D...|
>
>>> 00e0 08 00 38 09 53 00 61 00-54 00 72 00
> 61 00 6e 00 |..8.S.a.T.r.a.n.|
>
>>> 00f0 73 00 69 00 64 00 00 00-08 00 38 07
> 54 00 72 00 |s.i.d.....8.T.r.|
>
>>>
>
>>> 13:04:34.245846 1649
> (token.c:573):4 hidden return parameters
>
>>>
>>> 13:04:34.245855 1649
> (token.c:580):stored internal cursor id 0
>
>>>
>
>>> For some reason the Bad
> results have this header block before the column
>>> names actually start, and
> a 0 for the cursor id that is getting stored.
>
>>> Does anyone have any
> thoughts on this. ?Is there some setup that I can do to
>
>>> make this
> work?
>
>>>
>
>>> Thanks,
>
>>> Rob
>
>>>
>
>
>
>> Thanks to post again.
>
>
> It would be interesting to understand client query
>> (packets
> pre-results).
> Are you applied post 0.82 patches at freetds.sf.net ??
>> I
> remember a fix
> for cursor request that do not return a cursor.
>
>
>
>> freddy77
>
>
>
> IMPORTANT NOTICE: This e-mail message is intended to be received only by
> persons entitled to receive the confidential information it may contain.
> E-mail messages sent from this company may contain information that is
> confidential and may be legally privileged. Please do not read, copy,
> forward
> or store this message unless you are an intended recipient of it. If you
> received this transmission in error, please notify the sender by reply
> e-mail
> and delete the message and any attachments.
>
> _______________________________________________
> FreeTDS mailing list
>
> FreeTDS AT lists.ibiblio.org
>
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
__________________________
> _____________________
FreeTDS mailing
> list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freet
> ds


Rob Booth | Senior Software Engineer
Bridgepoint Education | Higher access to higher education
858.513.9240 x2716 Office

robert.booth AT bridgepointeducation.com
http://www.bridgepointeducation.com


IMPORTANT NOTICE: This e-mail message is intended to be received only by
persons entitled to receive the confidential information it may contain.
E-mail messages sent from this company may contain information that is
confidential and may be legally privileged. Please do not read, copy, forward
or store this message unless you are an intended recipient of it. If you
received this transmission in error, please notify the sender by reply e-mail
and delete the message and any attachments.




Archive powered by MHonArc 2.6.24.

Top of Page