Skip to Content.
Sympa Menu

freetds - [freetds] SQLPrepare, SQL Execute fails on SQL 7 but works on SQL 2K

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Rogers, Tom" <tom.rogers AT ccur.com>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: [freetds] SQLPrepare, SQL Execute fails on SQL 7 but works on SQL 2K
  • Date: Thu, 18 Sep 2003 12:15:45 -0400

Hhmm...seems weird. The prepare fails a syntax error on SQL 7 but no SQL
2K.

Here is the dump file. Has anyone seen anything like this:

<<dump.txt>>
Thomas Rogers
System Engineer
Concurrent Computer Corporation
phone: 215.712.7422 x7261
mailto:tomr AT ccur.com

Starting log file for FreeTDS 0.62.dev.20030814
on 2003-09-18 12:22:21 with debug level 99.
names for ISO-8859-1: ISO-8859-1
names for US-ASCII: US-ASCII
names for UCS-2LE: UCS-2LE
names for UCS-2BE: UCS-2BE
iconv to convert client-side data to the "ISO-8859-1" character set
12:22:21.694533 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
12:22:21.694619 tds_iconv_info_init: converting "US-ASCII"->"UCS-2LE"
12:22:21.694666 Connecting to 129.75.32.101 port 1433, TDS 7.0.
12:22:21.695103 tds_put_string converting 0 bytes of "tomr_linux"
12:22:21.695190 tds_put_string wrote 20 bytes
12:22:21.695229 tds_put_string converting 0 bytes of "sa"
12:22:21.695268 tds_put_string wrote 4 bytes
12:22:21.695306 password "" could not be converted to USC-2
12:22:21.695347 tds_put_string wrote 0 bytes
12:22:21.695384 tds_put_string converting 0 bytes of "SYBASE"
12:22:21.695423 tds_put_string wrote 12 bytes
12:22:21.695460 tds_put_string wrote 0 bytes
12:22:21.695496 tds_put_string converting 0 bytes of "us_english"
12:22:21.695535 tds_put_string wrote 20 bytes
12:22:21.695572 tds_put_string converting 0 bytes of "TRINITY_TJR"
12:22:21.695612 tds_put_string wrote 22 bytes
12:22:21.695689 tds_process_login_tokens()
Received header @ 12:22:21.782935
0000 04 01 01 aa 00 00 00 00- |........|


Received packet @ 12:22:21.783092
0000 e3 25 00 01 0b 54 00 52-00 49 00 4e 00 49 00 54 |.%...T.R .I.N.I.T|
0010 00 59 00 5f 00 54 00 4a-00 52 00 06 6d 00 61 00 |.Y._.T.J .R..m.a.|
0020 73 00 74 00 65 00 72 00-ab 6c 00 45 16 00 00 02 |s.t.e.r. .l.E....|
0030 00 2a 00 43 00 68 00 61-00 6e 00 67 00 65 00 64 |.*.C.h.a .n.g.e.d|
0040 00 20 00 64 00 61 00 74-00 61 00 62 00 61 00 73 |. .d.a.t .a.b.a.s|
0050 00 65 00 20 00 63 00 6f-00 6e 00 74 00 65 00 78 |.e. .c.o .n.t.e.x|
0060 00 74 00 20 00 74 00 6f-00 20 00 27 00 54 00 52 |.t. .t.o . .'.T.R|
0070 00 49 00 4e 00 49 00 54-00 59 00 5f 00 54 00 4a |.I.N.I.T .Y._.T.J|
0080 00 52 00 27 00 2e 00 06-44 00 45 00 4c 00 4c 00 |.R.'.... D.E.L.L.|
0090 52 00 4d 00 00 00 00 e3-17 00 02 0a 75 00 73 00 |R.M..... ....u.s.|
00a0 5f 00 65 00 6e 00 67 00-6c 00 69 00 73 00 68 00 |_.e.n.g. l.i.s.h.|
00b0 00 ab 66 00 47 16 00 00-01 00 27 00 43 00 68 00 |..f.G... ..'.C.h.|
00c0 61 00 6e 00 67 00 65 00-64 00 20 00 6c 00 61 00 |a.n.g.e. d. .l.a.|
00d0 6e 00 67 00 75 00 61 00-67 00 65 00 20 00 73 00 |n.g.u.a. g.e. .s.|
00e0 65 00 74 00 74 00 69 00-6e 00 67 00 20 00 74 00 |e.t.t.i. n.g. .t.|
00f0 6f 00 20 00 75 00 73 00-5f 00 65 00 6e 00 67 00 |o. .u.s. _.e.n.g.|
0100 6c 00 69 00 73 00 68 00-2e 00 06 44 00 45 00 4c |l.i.s.h. ...D.E.L|
0110 00 4c 00 52 00 4d 00 00-00 00 e3 0f 00 03 05 69 |.L.R.M.. .......i|
0120 00 73 00 6f 00 5f 00 31-00 01 00 00 e3 0b 00 05 |.s.o._.1 ........|
0130 04 31 00 30 00 33 00 33-00 00 e3 0f 00 06 06 31 |.1.0.3.3 .......1|
0140 00 39 00 36 00 36 00 30-00 39 00 00 ad 36 00 01 |.9.6.6.0 .9...6..|
0150 07 00 00 00 16 4d 00 69-00 63 00 72 00 6f 00 73 |.....M.i .c.r.o.s|
0160 00 6f 00 66 00 74 00 20-00 53 00 51 00 4c 00 20 |.o.f.t. .S.Q.L. |
0170 00 53 00 65 00 72 00 76-00 65 00 72 00 00 00 00 |.S.e.r.v .e.r....|
0180 00 07 00 03 c1 e3 11 00-04 03 35 00 31 00 32 00 |........ ..5.1.2.|
0190 04 34 00 30 00 39 00 36-00 fd 00 00 00 00 00 00 |.4.0.9.6 ........|
01a0 00 00 - |..|


12:22:21.783480 looking for login token, got e3(ENVCHANGE)
12:22:21.783518 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 22 from wire to give 11 to client.
tds_get_string: reading 12 from wire to give 6 to client.
12:22:21.783668 looking for login token, got ab(INFO)
12:22:21.783706 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 84 from wire to give 42 to client.
tds_get_string: reading 12 from wire to give 6 to client.
12:22:21.783837 looking for login token, got e3(ENVCHANGE)
12:22:21.783875 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 20 from wire to give 10 to client.
12:22:21.783955 looking for login token, got ab(INFO)
12:22:21.783993 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 78 from wire to give 39 to client.
tds_get_string: reading 12 from wire to give 6 to client.
12:22:21.784138 looking for login token, got e3(ENVCHANGE)
12:22:21.784177 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 10 from wire to give 5 to client.
tds_get_string: reading 2 from wire to give 1 to client.
12:22:21.784295 looking for login token, got e3(ENVCHANGE)
12:22:21.784333 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 8 from wire to give 4 to client.
12:22:21.784412 looking for login token, got e3(ENVCHANGE)
12:22:21.784450 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 12 from wire to give 6 to client.
12:22:21.784529 looking for login token, got ad(LOGINACK)
tds_get_string: reading 44 from wire to give 22 to client.
12:22:21.784605 looking for login token, got e3(ENVCHANGE)
12:22:21.784642 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 6 from wire to give 3 to client.
tds_get_string: reading 8 from wire to give 4 to client.
12:22:21.784761 looking for login token, got fd(DONE)
12:22:21.784799 tds_process_default_tokens() marker is fd(DONE)
12:22:21.784838 tds_process_end: more_results = 0
12:22:21.784851 was_cancelled = 0
12:22:21.784860 error = 0
12:22:21.784868 done_count_valid = 0
12:22:21.784904 leaving tds_process_login_tokens() returning 1
12:22:21.784957 tds_put_string converting 0 bytes of "set textsize 64512 "
12:22:21.785001 tds_put_string wrote 38 bytes
Sending packet @ 12:22:21.785043
0000 01 01 00 2e 00 00 01 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. .|


Received header @ 12:22:21.785656
0000 04 01 00 11 00 00 00 00- |........|


Received packet @ 12:22:21.785711
0000 fd 00 00 be 00 00 00 00-00 |........ .|


12:22:21.785762 processing result tokens. marker is fd(DONE)
12:22:21.785801 tds_process_end: more_results = 0
12:22:21.785813 was_cancelled = 0
12:22:21.785824 error = 0
12:22:21.785832 done_count_valid = 0
12:22:21.785869 tds_process_result_tokens() state is COMPLETED
SQLGetFunctions: fFunction is 1
SQLGetFunctions: fFunction is 2
SQLGetFunctions: fFunction is 1001
SQLGetFunctions: fFunction is 3
SQLGetFunctions: fFunction is 4
SQLGetFunctions: fFunction is 1002
SQLGetFunctions: fFunction is 72
SQLGetFunctions: fFunction is 5
SQLGetFunctions: fFunction is 6
SQLGetFunctions: fFunction is 56
SQLGetFunctions: fFunction is 40
SQLGetFunctions: fFunction is 7
SQLGetFunctions: fFunction is 8
SQLGetFunctions: fFunction is 9
SQLGetFunctions: fFunction is 41
SQLGetFunctions: fFunction is 1005
SQLGetFunctions: fFunction is 10
SQLGetFunctions: fFunction is 11
SQLGetFunctions: fFunction is 12
SQLGetFunctions: fFunction is 13
SQLGetFunctions: fFunction is 60
SQLGetFunctions: fFunction is 15
SQLGetFunctions: fFunction is 1006
SQLGetFunctions: fFunction is 16
SQLGetFunctions: fFunction is 14
SQLGetFunctions: fFunction is 1007
SQLGetFunctions: fFunction is 42
SQLGetFunctions: fFunction is 43
SQLGetFunctions: fFunction is 1009
SQLGetFunctions: fFunction is 1010
SQLGetFunctions: fFunction is 1012
SQLGetFunctions: fFunction is 44
SQLGetFunctions: fFunction is 45
SQLGetFunctions: fFunction is 1014
SQLGetFunctions: fFunction is 46
SQLGetFunctions: fFunction is 47
SQLGetFunctions: fFunction is 61
SQLGetFunctions: fFunction is 62
SQLGetFunctions: fFunction is 63
SQLGetFunctions: fFunction is 18
SQLGetFunctions: fFunction is 48
SQLGetFunctions: fFunction is 19
SQLGetFunctions: fFunction is 65
SQLGetFunctions: fFunction is 66
SQLGetFunctions: fFunction is 67
SQLGetFunctions: fFunction is 49
SQLGetFunctions: fFunction is 20
SQLGetFunctions: fFunction is 1016
SQLGetFunctions: fFunction is 50
SQLGetFunctions: fFunction is 1018
SQLGetFunctions: fFunction is 1019
SQLGetFunctions: fFunction is 22
SQLGetFunctions: fFunction is 51
SQLGetFunctions: fFunction is 52
SQLGetFunctions: fFunction is 53
SQLGetFunctions: fFunction is 70
SQLGetFunctions: fFunction is 54
SQLGetFunctions: fFunction is 23
SQLGetFunctions: fFunction is 1011
odbc:SQLSetStmtOption: Statement option 0 not implemented
Setting input parameters
Creating prepared statement
12:22:21.788154 tds_put_string converting 0 bytes of "SELECT SCOPE_LEVEL_ID,
PARENT_SCOPE_LEVEL_ID, NAME AS SCOPE_LEVEL_NAME FROM VWT_SCOPE_LEVEL order by
SCOPE_LEVEL_ID"
12:22:21.788202 tds_put_string wrote 230 bytes
Sending packet @ 12:22:21.788244
0000 03 01 01 28 00 00 01 00-0a 00 73 00 70 00 5f 00 |...(.... ..s.p._.|
0010 70 00 72 00 65 00 70 00-61 00 72 00 65 00 00 00 |p.r.e.p. a.r.e...|
0020 00 01 26 04 00 00 00 63-00 00 00 00 00 00 00 00 |..&....c ........|
0030 00 00 63 e6 00 00 00 e6-00 00 00 53 00 45 00 4c |..c..... ...S.E.L|
0040 00 45 00 43 00 54 00 20-00 53 00 43 00 4f 00 50 |.E.C.T. .S.C.O.P|
0050 00 45 00 5f 00 4c 00 45-00 56 00 45 00 4c 00 5f |.E._.L.E .V.E.L._|
0060 00 49 00 44 00 2c 00 20-00 50 00 41 00 52 00 45 |.I.D.,. .P.A.R.E|
0070 00 4e 00 54 00 5f 00 53-00 43 00 4f 00 50 00 45 |.N.T._.S .C.O.P.E|
0080 00 5f 00 4c 00 45 00 56-00 45 00 4c 00 5f 00 49 |._.L.E.V .E.L._.I|
0090 00 44 00 2c 00 20 00 4e-00 41 00 4d 00 45 00 20 |.D.,. .N .A.M.E. |
00a0 00 41 00 53 00 20 00 53-00 43 00 4f 00 50 00 45 |.A.S. .S .C.O.P.E|
00b0 00 5f 00 4c 00 45 00 56-00 45 00 4c 00 5f 00 4e |._.L.E.V .E.L._.N|
00c0 00 41 00 4d 00 45 00 20-00 46 00 52 00 4f 00 4d |.A.M.E. .F.R.O.M|
00d0 00 20 00 56 00 57 00 54-00 5f 00 53 00 43 00 4f |. .V.W.T ._.S.C.O|
00e0 00 50 00 45 00 5f 00 4c-00 45 00 56 00 45 00 4c |.P.E._.L .E.V.E.L|
00f0 00 20 00 6f 00 72 00 64-00 65 00 72 00 20 00 62 |. .o.r.d .e.r. .b|
0100 00 79 00 20 00 53 00 43-00 4f 00 50 00 45 00 5f |.y. .S.C .O.P.E._|
0110 00 4c 00 45 00 56 00 45-00 4c 00 5f 00 49 00 44 |.L.E.V.E .L._.I.D|
0120 00 00 00 38 01 00 00 00- |...8....|


Received header @ 12:22:21.789896
0000 04 01 00 f6 00 00 00 00- |........|


Received packet @ 12:22:21.789951
0000 aa 5c 00 aa 00 00 00 01-0f 22 00 4c 00 69 00 6e |.\...... .".L.i.n|
0010 00 65 00 20 00 31 00 3a-00 20 00 49 00 6e 00 63 |.e. .1.: . .I.n.c|
0020 00 6f 00 72 00 72 00 65-00 63 00 74 00 20 00 73 |.o.r.r.e .c.t. .s|
0030 00 79 00 6e 00 74 00 61-00 78 00 20 00 6e 00 65 |.y.n.t.a .x. .n.e|
0040 00 61 00 72 00 20 00 27-00 29 00 27 00 2e 00 06 |.a.r. .' .).'....|
0050 44 00 45 00 4c 00 4c 00-52 00 4d 00 00 01 00 aa |D.E.L.L. R.M.....|
0060 72 00 f4 1f 00 00 01 10-23 00 53 00 74 00 61 00 |r....... #.S.t.a.|
0070 74 00 65 00 6d 00 65 00-6e 00 74 00 28 00 73 00 |t.e.m.e. n.t.(.s.|
0080 29 00 20 00 63 00 6f 00-75 00 6c 00 64 00 20 00 |). .c.o. u.l.d. .|
0090 6e 00 6f 00 74 00 20 00-62 00 65 00 20 00 70 00 |n.o.t. . b.e. .p.|
00a0 72 00 65 00 70 00 61 00-72 00 65 00 64 00 2e 00 |r.e.p.a. r.e.d...|
00b0 06 44 00 45 00 4c 00 4c-00 52 00 4d 00 0a 73 00 |.D.E.L.L .R.M..s.|
00c0 70 00 5f 00 70 00 72 00-65 00 70 00 61 00 72 00 |p._.p.r. e.p.a.r.|
00d0 65 00 01 00 79 f4 1f 00-00 ac 09 00 00 01 38 00 |e...y... ......8.|
00e0 00 00 26 04 00 fe 02 00-e0 00 00 00 00 00 |..&..... ......|


12:22:21.790184 processing result tokens. marker is aa(ERROR)
12:22:21.790224 tds_process_default_tokens() marker is aa(ERROR)
tds_get_string: reading 68 from wire to give 34 to client.
tds_get_string: reading 12 from wire to give 6 to client.
12:22:21.790348 processing result tokens. marker is aa(ERROR)
12:22:21.790388 tds_process_default_tokens() marker is aa(ERROR)
tds_get_string: reading 70 from wire to give 35 to client.
tds_get_string: reading 12 from wire to give 6 to client.
tds_get_string: reading 20 from wire to give 10 to client.
12:22:21.790546 processing result tokens. marker is 79(RETURNSTATUS)
12:22:21.790586 processing result tokens. marker is ac(PARAM)
12:22:21.790638 processing result. type = 38(integer-null), varint_size 1
12:22:21.790679 processing result. column_size 4
12:22:21.790717 processing row. column is 0 varint size = 1
12:22:21.790756 processing row. column size is 0
12:22:21.790811 setting column 0 NULL bit
12:22:21.790849 processing result tokens. marker is fe(DONEPROC)
12:22:21.790889 tds_process_end: more_results = 0
12:22:21.790900 was_cancelled = 0
12:22:21.790910 error = 1
12:22:21.790918 done_count_valid = 0
Setting input parameters
End prepare, execute
12:22:22.298268 tds_submit_execute()
Sending packet @ 12:22:22.298329
0000 03 01 00 27 00 00 01 00-0a 00 73 00 70 00 5f 00 |...'.... ..s.p._.|
0010 65 00 78 00 65 00 63 00-75 00 74 00 65 00 00 00 |e.x.e.c. u.t.e...|
0020 00 00 38 50 13 13 42 - |..8P..B|


Received header @ 12:22:22.299424
0000 04 01 00 b7 00 00 00 00- |........|


Received packet @ 12:22:22.299481
0000 aa 9e 00 f3 1f 00 00 01-10 39 00 43 00 6f 00 75 |........ .9.C.o.u|
0010 00 6c 00 64 00 20 00 6e-00 6f 00 74 00 20 00 66 |.l.d. .n .o.t. .f|
0020 00 69 00 6e 00 64 00 20-00 70 00 72 00 65 00 70 |.i.n.d. .p.r.e.p|
0030 00 61 00 72 00 65 00 64-00 20 00 73 00 74 00 61 |.a.r.e.d . .s.t.a|
0040 00 74 00 65 00 6d 00 65-00 6e 00 74 00 20 00 77 |.t.e.m.e .n.t. .w|
0050 00 69 00 74 00 68 00 20-00 68 00 61 00 6e 00 64 |.i.t.h. .h.a.n.d|
0060 00 6c 00 65 00 20 00 31-00 31 00 30 00 38 00 35 |.l.e. .1 .1.0.8.5|
0070 00 34 00 36 00 33 00 38-00 34 00 2e 00 06 44 00 |.4.6.3.8 .4....D.|
0080 45 00 4c 00 4c 00 52 00-4d 00 0a 73 00 70 00 5f |E.L.L.R. M..s.p._|
0090 00 65 00 78 00 65 00 63-00 75 00 74 00 65 00 01 |.e.x.e.c .u.t.e..|
00a0 00 79 f3 1f 00 00 fe 02-00 e0 00 00 00 00 00 |.y...... .......|


12:22:22.299668 processing result tokens. marker is aa(ERROR)
12:22:22.299708 tds_process_default_tokens() marker is aa(ERROR)
tds_get_string: reading 114 from wire to give 57 to client.
tds_get_string: reading 12 from wire to give 6 to client.
tds_get_string: reading 20 from wire to give 10 to client.
12:22:22.299877 processing result tokens. marker is 79(RETURNSTATUS)
12:22:22.299919 processing result tokens. marker is fe(DONEPROC)
12:22:22.299959 tds_process_end: more_results = 0
12:22:22.299971 was_cancelled = 0
12:22:22.299980 error = 1
12:22:22.299988 done_count_valid = 0
Setting input parameters
End prepare, execute
12:22:22.807580 tds_submit_execute()
Sending packet @ 12:22:22.807641
0000 03 01 00 27 00 00 01 00-0a 00 73 00 70 00 5f 00 |...'.... ..s.p._.|
0010 65 00 78 00 65 00 63 00-75 00 74 00 65 00 00 00 |e.x.e.c. u.t.e...|
0020 00 00 38 50 13 13 42 - |..8P..B|


Received header @ 12:22:22.808568
0000 04 01 00 b7 00 00 00 00- |........|


Received packet @ 12:22:22.808626
0000 aa 9e 00 f3 1f 00 00 01-10 39 00 43 00 6f 00 75 |........ .9.C.o.u|
0010 00 6c 00 64 00 20 00 6e-00 6f 00 74 00 20 00 66 |.l.d. .n .o.t. .f|
0020 00 69 00 6e 00 64 00 20-00 70 00 72 00 65 00 70 |.i.n.d. .p.r.e.p|
0030 00 61 00 72 00 65 00 64-00 20 00 73 00 74 00 61 |.a.r.e.d . .s.t.a|
0040 00 74 00 65 00 6d 00 65-00 6e 00 74 00 20 00 77 |.t.e.m.e .n.t. .w|
0050 00 69 00 74 00 68 00 20-00 68 00 61 00 6e 00 64 |.i.t.h. .h.a.n.d|
0060 00 6c 00 65 00 20 00 31-00 31 00 30 00 38 00 35 |.l.e. .1 .1.0.8.5|
0070 00 34 00 36 00 33 00 38-00 34 00 2e 00 06 44 00 |.4.6.3.8 .4....D.|
0080 45 00 4c 00 4c 00 52 00-4d 00 0a 73 00 70 00 5f |E.L.L.R. M..s.p._|
0090 00 65 00 78 00 65 00 63-00 75 00 74 00 65 00 01 |.e.x.e.c .u.t.e..|
00a0 00 79 f3 1f 00 00 fe 02-00 e0 00 00 00 00 00 |.y...... .......|


12:22:22.808814 processing result tokens. marker is aa(ERROR)
12:22:22.808855 tds_process_default_tokens() marker is aa(ERROR)
tds_get_string: reading 114 from wire to give 57 to client.
tds_get_string: reading 12 from wire to give 6 to client.
tds_get_string: reading 20 from wire to give 10 to client.
12:22:22.809023 processing result tokens. marker is 79(RETURNSTATUS)
12:22:22.809064 processing result tokens. marker is fe(DONEPROC)
12:22:22.809104 tds_process_end: more_results = 0
12:22:22.809116 was_cancelled = 0
12:22:22.809125 error = 1
12:22:22.809133 done_count_valid = 0
SQLFreeHandle(3, 0x8065528)
12:22:22.809732 tds_submit_unprepare() eijz236000
Sending packet @ 12:22:22.809783
0000 03 01 00 2b 00 00 01 00-0c 00 73 00 70 00 5f 00 |...+.... ..s.p._.|
0010 75 00 6e 00 70 00 72 00-65 00 70 00 61 00 72 00 |u.n.p.r. e.p.a.r.|
0020 65 00 00 00 00 00 38 50-13 13 42 |e.....8P ..B|


Received header @ 12:22:22.810811
0000 04 01 00 bb 00 00 00 00- |........|


Received packet @ 12:22:22.810867
0000 aa a2 00 f3 1f 00 00 02-10 39 00 43 00 6f 00 75 |........ .9.C.o.u|
0010 00 6c 00 64 00 20 00 6e-00 6f 00 74 00 20 00 66 |.l.d. .n .o.t. .f|
0020 00 69 00 6e 00 64 00 20-00 70 00 72 00 65 00 70 |.i.n.d. .p.r.e.p|
0030 00 61 00 72 00 65 00 64-00 20 00 73 00 74 00 61 |.a.r.e.d . .s.t.a|
0040 00 74 00 65 00 6d 00 65-00 6e 00 74 00 20 00 77 |.t.e.m.e .n.t. .w|
0050 00 69 00 74 00 68 00 20-00 68 00 61 00 6e 00 64 |.i.t.h. .h.a.n.d|
0060 00 6c 00 65 00 20 00 31-00 31 00 30 00 38 00 35 |.l.e. .1 .1.0.8.5|
0070 00 34 00 36 00 33 00 38-00 34 00 2e 00 06 44 00 |.4.6.3.8 .4....D.|
0080 45 00 4c 00 4c 00 52 00-4d 00 0c 73 00 70 00 5f |E.L.L.R. M..s.p._|
0090 00 75 00 6e 00 70 00 72-00 65 00 70 00 61 00 72 |.u.n.p.r .e.p.a.r|
00a0 00 65 00 01 00 79 f3 1f-00 00 fe 02 00 e0 00 00 |.e...y.. ........|
00b0 00 00 00 - |...|


12:22:22.811055 processing result tokens. marker is aa(ERROR)
12:22:22.811094 tds_process_default_tokens() marker is aa(ERROR)
tds_get_string: reading 114 from wire to give 57 to client.
tds_get_string: reading 12 from wire to give 6 to client.
tds_get_string: reading 24 from wire to give 12 to client.
12:22:22.811257 processing result tokens. marker is 79(RETURNSTATUS)
12:22:22.811297 processing result tokens. marker is fe(DONEPROC)
12:22:22.811336 tds_process_end: more_results = 0
12:22:22.811349 was_cancelled = 0
12:22:22.811360 error = 1
12:22:22.811368 done_count_valid = 0


  • [freetds] SQLPrepare, SQL Execute fails on SQL 7 but works on SQL 2K, Rogers, Tom, 09/18/2003

Archive powered by MHonArc 2.6.24.

Top of Page