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: Thu, 22 Jul 2010 16:26:02 +0200

Fixed! Just committed to CVS.

2010/6/26 Rob Booth <robert.booth AT bridgepointeducation.com>:
> Freddy,
>
> Thank you for taking the time to look into this.  I'm looking forward to the
> day a patch is released.  I know others in my department are eagerly
> awaiting being able to upgrade to Snow Leopard.  Is this being added to the
> bug tracker or somewhere where I can keep an eye on the progress?
>
> Thanks again,
> Rob
>
>
> On 6/26/10 12:30 AM, "Frediano Ziglio" <freddy77 AT gmail.com> wrote:
>
>> 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
>>
> __________________________
>> _____________________
> 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
>



  • Re: [freetds] MSSql, Snow Leopard, & PHP, Frediano Ziglio, 07/22/2010

Archive powered by MHonArc 2.6.24.

Top of Page