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: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] MSSql, Snow Leopard, & PHP
  • Date: Sat, 26 Jun 2010 09:30:06 +0200

Thanks for your reply. I'm able to reproduce your problem. I extended
cursor2 unittests in order to catch this problem. This does not means
it has been fixed but that is going to be fixed. The problem is that a
sp_cursoropen call instead of returning the prepared statement execute
it. In odbc.c we call tds_process_simple_query after tds_cursor_open
which discard all results so at next fetch you get not rows.

Frediano

2010/6/21 Rob Booth <robert.booth AT bridgepointeducation.com>:
> 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.
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page