Skip to Content.
Sympa Menu

freetds - RE: [freetds] dbmorecmds works

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] dbmorecmds works
  • Date: Mon, 28 Jul 2003 16:47:03 +0200


> > >
> > > Sorry, Freddy! I forgot to commit my changes. They're at
> > > work, and I'm home now for the weekend. I hope you'll trust
> > > me that I figured it out and got it working. I'll commit it
> > > on Monday.
> >
> > I trust you, I trust you! That's I don't remember what server
> > test type
> > you use (I though it was only a configuration problem)...
>
> All committed now. Hope you like it. :-) Sorry for the confusion.
>
> I don't think there're any protocol issues. dbmorecmds()
> doesn't even make a call to libtds. It's just a matter of
> getting the semantics right.
>
> For the record, I normally test against a 7.0 server in
> Australia, and sometimes against Sybase's JDBC server. I
> don't have access to an 8.0 machine.
>

Hi!
Australia ?? A public server to test ??

I tried and get still error...

$ ./dbmorecmds
found OPDN014.tempdb for sa in "../../../PWD"
Start
About to logon
after bread crumb
after dblogin
About to open [biancaneve7][sa]
After second bread crumb
After dbopen [OPDN014]
About to dbuse [tempdb]
After dbuse [tempdb]
Dropping table
Msg 3701, Level 11, State 5
Server 'OPDN014', Line 1
Cannot drop the table '#dblib0024', because it does not exist in the
system catalog.
creating table
insert
insert into #dblib0024 values (0, 'row 000')
insert into #dblib0024 values (1, 'row 001')
insert into #dblib0024 values (2, 'row 002')
insert into #dblib0024 values (3, 'row 003')
insert into #dblib0024 values (4, 'row 004')
insert into #dblib0024 values (5, 'row 005')
insert into #dblib0024 values (6, 'row 006')
insert into #dblib0024 values (7, 'row 007')
insert into #dblib0024 values (8, 'row 008')
insert into #dblib0024 values (9, 'row 009')
select 1
DB-LIBRARY error (severity 7, dberr 20019, oserr -1, dberrstr Attempt to
initiate a new SQL Server operation with results pending., oserrstr
OpenClient):
Was expecting more_count = 0.

TDSDUMP attached.

freddy77
Starting log file for FreeTDS 0.62.dev.20030725
on 2003-07-28 16:45:03 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
16:45:03.638886 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
16:45:03.639086 tds_iconv_info_init: converting "US-ASCII"->"UCS-2LE"
16:45:03.639166 Connecting to 10.1.36.114 port 1433, TDS 7.0.
16:45:03.639816 tds_put_string converting 0 bytes of "OPDW001L.omnitel.it"
16:45:03.639926 tds_put_string wrote 38 bytes
16:45:03.639975 tds_put_string converting 0 bytes of "sa"
16:45:03.640056 tds_put_string wrote 4 bytes
16:45:03.640106 password "" could not be converted to USC-2
16:45:03.640156 tds_put_string converting 0 bytes of "t0024"
16:45:03.640206 tds_put_string wrote 10 bytes
16:45:03.640248 tds_put_string converting 0 bytes of "OPDN014"
16:45:03.640295 tds_put_string wrote 14 bytes
16:45:03.640337 tds_put_string converting 0 bytes of "DB-Library"
16:45:03.640384 tds_put_string wrote 20 bytes
16:45:03.640425 tds_put_string converting 0 bytes of "us_english"
16:45:03.640472 tds_put_string wrote 20 bytes
16:45:03.640514 tds_put_string wrote 0 bytes
Sending packet @ 16:45:03.640561
0000 10 01 00 de 00 00 01 00-d6 00 00 00 00 00 00 70 |........ .......p|
0010 00 00 00 00 06 83 f2 f8-6b 1a 00 00 00 00 00 00 |........ k.......|
0020 e0 01 00 00 88 ff ff ff-36 04 00 00 56 00 13 00 |........ 6...V...|
0030 7c 00 02 00 80 00 0b 00-96 00 05 00 a0 00 07 00 ||....... ........|
0040 00 00 00 00 ae 00 0a 00-c2 00 0a 00 d6 00 00 00 |........ ........|
0050 00 10 4b b0 86 c2 d6 00-00 00 d6 00 00 00 4f 00 |..K..... ......O.|
0060 50 00 44 00 57 00 30 00-30 00 31 00 4c 00 2e 00 |P.D.W.0. 0.1.L...|
0070 6f 00 6d 00 6e 00 69 00-74 00 65 00 6c 00 2e 00 |o.m.n.i. t.e.l...|
0080 69 00 74 00 73 00 61 00-83 a5 33 a5 b3 a5 43 a5 |i.t.s.a. ..3...C.|
0090 93 a5 b3 a5 43 a5 f3 a5-c2 a5 f3 a5 d6 a5 74 00 |....C... ......t.|
00a0 30 00 30 00 32 00 34 00-4f 00 50 00 44 00 4e 00 |0.0.2.4. O.P.D.N.|
00b0 30 00 31 00 34 00 44 00-42 00 2d 00 4c 00 69 00 |0.1.4.D. B.-.L.i.|
00c0 62 00 72 00 61 00 72 00-79 00 75 00 73 00 5f 00 |b.r.a.r. y.u.s._.|
00d0 65 00 6e 00 67 00 6c 00-69 00 73 00 68 00 |e.n.g.l. i.s.h.|


16:45:03.641467 tds_process_login_tokens()
Received header @ 16:45:03.643403
0000 04 01 01 9c 00 36 01 00- |.....6..|


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


16:45:03.644921 looking for login token, got e3(ENVCHANGE)
16:45:03.644974 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 12 from wire to give 6 to client.
tds_get_string: reading 12 from wire to give 6 to client.
16:45:03.645139 looking for login token, got ab(INFO)
16:45:03.645187 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 74 from wire to give 37 to client.
tds_get_string: reading 14 from wire to give 7 to client.
16:45:03.645359 looking for login token, got e3(ENVCHANGE)
16:45:03.645412 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 20 from wire to give 10 to client.
16:45:03.645493 looking for login token, got ab(INFO)
16:45:03.645540 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 78 from wire to give 39 to client.
tds_get_string: reading 14 from wire to give 7 to client.
16:45:03.645659 looking for login token, got e3(ENVCHANGE)
16:45:03.645707 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.
16:45:03.645816 looking for login token, got e3(ENVCHANGE)
16:45:03.645862 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 8 from wire to give 4 to client.
16:45:03.645941 looking for login token, got e3(ENVCHANGE)
16:45:03.645987 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 12 from wire to give 6 to client.
16:45:03.646066 looking for login token, got ad(LOGINACK)
tds_get_string: reading 44 from wire to give 22 to client.
16:45:03.646149 looking for login token, got e3(ENVCHANGE)
16:45:03.646194 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 8 from wire to give 4 to client.
tds_get_string: reading 8 from wire to give 4 to client.
16:45:03.646301 increasing block size from 4096 to 4096
16:45:03.646379 looking for login token, got fd(DONE)
16:45:03.646431 tds_process_default_tokens() marker is fd(DONE)
16:45:03.646475 tds_process_end() more_results = 0, was_cancelled = 0
16:45:03.646522 leaving tds_process_login_tokens() returning 1
16:45:03.646629 dbuse()
16:45:03.646697 dbcmd() bufsz = 0
16:45:03.646747 in dbsqlexec()
16:45:03.646797 in dbsqlsend()
16:45:03.646854 tds_put_string converting 0 bytes of "use tempdb"
16:45:03.646908 tds_put_string wrote 20 bytes
Sending packet @ 16:45:03.646954
0000 01 01 00 1c 00 00 01 00-75 00 73 00 65 00 20 00 |........ u.s.e. .|
0010 74 00 65 00 6d 00 70 00-64 00 62 00 |t.e.m.p. d.b.|


16:45:03.647175 in dbsqlok()
Received header @ 16:45:03.647977
0000 04 01 00 96 00 36 01 00- |.....6..|


Received packet @ 16:45:03.648157
0000 e3 1b 00 01 06 74 00 65-00 6d 00 70 00 64 00 62 |.....t.e .m.p.d.b|
0010 00 06 6d 00 61 00 73 00-74 00 65 00 72 00 ab 64 |..m.a.s. t.e.r..d|
0020 00 45 16 00 00 01 00 25-00 43 00 68 00 61 00 6e |.E.....% .C.h.a.n|
0030 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d. .d.a.t.a|
0040 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n|
0050 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. |
0060 00 27 00 74 00 65 00 6d-00 70 00 64 00 62 00 27 |.'.t.e.m .p.d.b.'|
0070 00 2e 00 07 4f 00 50 00-44 00 4e 00 30 00 31 00 |....O.P. D.N.0.1.|
0080 34 00 00 01 00 fd 00 00-e2 00 00 00 00 00 |4....... ......|


16:45:03.648668 dbsqlok() marker is e3
16:45:03.648716 processing result tokens. marker is e3(ENVCHANGE)
16:45:03.648768 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 12 from wire to give 6 to client.
tds_get_string: reading 12 from wire to give 6 to client.
16:45:03.648888 processing result tokens. marker is ab(INFO)
16:45:03.648937 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 74 from wire to give 37 to client.
tds_get_string: reading 14 from wire to give 7 to client.
16:45:03.649118 processing result tokens. marker is fd(DONE)
16:45:03.649174 tds_process_end() more_results = 0, was_cancelled = 0
16:45:03.649224 dbsqlok() end status was success
16:45:03.649274 dbresults()
16:45:03.649314 dbresults_r()
16:45:03.649349 tds_process_result_tokens() state is COMPLETED
16:45:03.649386 leaving dbresults() returning 1
16:45:03.649431 tds_process_row_tokens() state is COMPLETED
16:45:03.649510 dbcmd() bufsz = 11
16:45:03.649558 in dbfreebuf()
16:45:03.649605 in dbsqlexec()
16:45:03.649642 in dbsqlsend()
16:45:03.649681 tds_put_string converting 0 bytes of "drop table #dblib0024"
16:45:03.649736 tds_put_string wrote 42 bytes
Sending packet @ 16:45:03.649782
0000 01 01 00 32 00 00 01 00-64 00 72 00 6f 00 70 00 |...2.... d.r.o.p.|
0010 20 00 74 00 61 00 62 00-6c 00 65 00 20 00 23 00 | .t.a.b. l.e. .#.|
0020 64 00 62 00 6c 00 69 00-62 00 30 00 30 00 32 00 |d.b.l.i. b.0.0.2.|
0030 34 00 - |4.|


16:45:03.650100 in dbsqlok()
Received header @ 16:45:03.651066
0000 04 01 00 d6 00 36 01 00- |.....6..|


Received packet @ 16:45:03.651188
0000 aa c2 00 75 0e 00 00 05-0b 54 00 43 00 61 00 6e |...u.... .T.C.a.n|
0010 00 6e 00 6f 00 74 00 20-00 64 00 72 00 6f 00 70 |.n.o.t. .d.r.o.p|
0020 00 20 00 74 00 68 00 65-00 20 00 74 00 61 00 62 |. .t.h.e . .t.a.b|
0030 00 6c 00 65 00 20 00 27-00 23 00 64 00 62 00 6c |.l.e. .' .#.d.b.l|
0040 00 69 00 62 00 30 00 30-00 32 00 34 00 27 00 2c |.i.b.0.0 .2.4.'.,|
0050 00 20 00 62 00 65 00 63-00 61 00 75 00 73 00 65 |. .b.e.c .a.u.s.e|
0060 00 20 00 69 00 74 00 20-00 64 00 6f 00 65 00 73 |. .i.t. .d.o.e.s|
0070 00 20 00 6e 00 6f 00 74-00 20 00 65 00 78 00 69 |. .n.o.t . .e.x.i|
0080 00 73 00 74 00 20 00 69-00 6e 00 20 00 74 00 68 |.s.t. .i .n. .t.h|
0090 00 65 00 20 00 73 00 79-00 73 00 74 00 65 00 6d |.e. .s.y .s.t.e.m|
00a0 00 20 00 63 00 61 00 74-00 61 00 6c 00 6f 00 67 |. .c.a.t .a.l.o.g|
00b0 00 2e 00 07 4f 00 50 00-44 00 4e 00 30 00 31 00 |....O.P. D.N.0.1.|
00c0 34 00 00 01 00 fd 02 00-c7 00 00 00 00 00 |4....... ......|


16:45:03.651893 dbsqlok() marker is aa
16:45:03.651934 processing result tokens. marker is aa(ERROR)
16:45:03.651977 tds_process_default_tokens() marker is aa(ERROR)
tds_get_string: reading 168 from wire to give 84 to client.
tds_get_string: reading 14 from wire to give 7 to client.
16:45:03.652205 processing result tokens. marker is fd(DONE)
16:45:03.652261 tds_process_end() more_results = 0, was_cancelled = 0
16:45:03.652310 dbsqlok() end status was error
16:45:03.652356 dbresults()
16:45:03.652392 dbresults_r()
16:45:03.652424 tds_process_result_tokens() state is COMPLETED
16:45:03.652461 leaving dbresults() returning 1
16:45:03.652498 dbresults()
16:45:03.652529 dbresults_r()
16:45:03.652561 tds_process_result_tokens() state is COMPLETED
16:45:03.652597 leaving dbresults() returning 2
16:45:03.652652 dbcmd() bufsz = 22
16:45:03.652692 in dbfreebuf()
16:45:03.652732 in dbsqlexec()
16:45:03.652766 in dbsqlsend()
16:45:03.652805 tds_put_string converting 0 bytes of "create table #dblib0024
(i int not null, s char(10) not null)"
16:45:03.652863 tds_put_string wrote 122 bytes
Sending packet @ 16:45:03.652910
0000 01 01 00 82 00 00 01 00-63 00 72 00 65 00 61 00 |........ c.r.e.a.|
0010 74 00 65 00 20 00 74 00-61 00 62 00 6c 00 65 00 |t.e. .t. a.b.l.e.|
0020 20 00 23 00 64 00 62 00-6c 00 69 00 62 00 30 00 | .#.d.b. l.i.b.0.|
0030 30 00 32 00 34 00 20 00-28 00 69 00 20 00 69 00 |0.2.4. . (.i. .i.|
0040 6e 00 74 00 20 00 6e 00-6f 00 74 00 20 00 6e 00 |n.t. .n. o.t. .n.|
0050 75 00 6c 00 6c 00 2c 00-20 00 73 00 20 00 63 00 |u.l.l.,. .s. .c.|
0060 68 00 61 00 72 00 28 00-31 00 30 00 29 00 20 00 |h.a.r.(. 1.0.). .|
0070 6e 00 6f 00 74 00 20 00-6e 00 75 00 6c 00 6c 00 |n.o.t. . n.u.l.l.|
0080 29 00 - |).|


16:45:03.653464 in dbsqlok()
Received header @ 16:45:03.654909
0000 04 01 00 11 00 36 01 00- |.....6..|


Received packet @ 16:45:03.655059
0000 fd 00 00 c6 00 00 00 00-00 |........ .|


16:45:03.655147 dbsqlok() marker is fd
16:45:03.655187 processing result tokens. marker is fd(DONE)
16:45:03.655232 tds_process_end() more_results = 0, was_cancelled = 0
16:45:03.655279 dbsqlok() end status was success
16:45:03.655316 dbresults()
16:45:03.655348 dbresults_r()
16:45:03.655379 tds_process_result_tokens() state is COMPLETED
16:45:03.655416 leaving dbresults() returning 1
16:45:03.655453 dbresults()
16:45:03.655485 dbresults_r()
16:45:03.655517 tds_process_result_tokens() state is COMPLETED
16:45:03.655553 leaving dbresults() returning 2
16:45:03.655645 dbcmd() bufsz = 62
16:45:03.655688 in dbfreebuf()
16:45:03.655728 in dbsqlexec()
16:45:03.655762 in dbsqlsend()
16:45:03.655800 tds_put_string converting 0 bytes of "insert into #dblib0024
values (0, 'row 000')"
16:45:03.655858 tds_put_string wrote 88 bytes
Sending packet @ 16:45:03.655905
0000 01 01 00 60 00 00 01 00-69 00 6e 00 73 00 65 00 |...`.... i.n.s.e.|
0010 72 00 74 00 20 00 69 00-6e 00 74 00 6f 00 20 00 |r.t. .i. n.t.o. .|
0020 23 00 64 00 62 00 6c 00-69 00 62 00 30 00 30 00 |#.d.b.l. i.b.0.0.|
0030 32 00 34 00 20 00 76 00-61 00 6c 00 75 00 65 00 |2.4. .v. a.l.u.e.|
0040 73 00 20 00 28 00 30 00-2c 00 20 00 27 00 72 00 |s. .(.0. ,. .'.r.|
0050 6f 00 77 00 20 00 30 00-30 00 30 00 27 00 29 00 |o.w. .0. 0.0.'.).|


16:45:03.656330 in dbsqlok()
Received header @ 16:45:03.659268
0000 04 01 00 11 00 36 01 00- |.....6..|


Received packet @ 16:45:03.659388
0000 fd 10 00 c3 00 01 00 00-00 |........ .|


16:45:03.659472 dbsqlok() marker is fd
16:45:03.659511 processing result tokens. marker is fd(DONE)
16:45:03.659555 tds_process_end() more_results = 0, was_cancelled = 0
16:45:03.659602 dbsqlok() end status was success
16:45:03.659639 dbresults()
16:45:03.659671 dbresults_r()
16:45:03.659703 tds_process_result_tokens() state is COMPLETED
16:45:03.659739 leaving dbresults() returning 1
16:45:03.659777 dbresults()
16:45:03.659809 dbresults_r()
16:45:03.659840 tds_process_result_tokens() state is COMPLETED
16:45:03.659877 leaving dbresults() returning 2
16:45:03.659943 dbcmd() bufsz = 45
16:45:03.659983 in dbfreebuf()
16:45:03.660045 in dbsqlexec()
16:45:03.660082 in dbsqlsend()
16:45:03.660120 tds_put_string converting 0 bytes of "insert into #dblib0024
values (1, 'row 001')"
16:45:03.660178 tds_put_string wrote 88 bytes
Sending packet @ 16:45:03.660224
0000 01 01 00 60 00 00 01 00-69 00 6e 00 73 00 65 00 |...`.... i.n.s.e.|
0010 72 00 74 00 20 00 69 00-6e 00 74 00 6f 00 20 00 |r.t. .i. n.t.o. .|
0020 23 00 64 00 62 00 6c 00-69 00 62 00 30 00 30 00 |#.d.b.l. i.b.0.0.|
0030 32 00 34 00 20 00 76 00-61 00 6c 00 75 00 65 00 |2.4. .v. a.l.u.e.|
0040 73 00 20 00 28 00 31 00-2c 00 20 00 27 00 72 00 |s. .(.1. ,. .'.r.|
0050 6f 00 77 00 20 00 30 00-30 00 31 00 27 00 29 00 |o.w. .0. 0.1.'.).|


16:45:03.660650 in dbsqlok()
Received header @ 16:45:03.662511
0000 04 01 00 11 00 36 01 00- |.....6..|


Received packet @ 16:45:03.662630
0000 fd 10 00 c3 00 01 00 00-00 |........ .|


16:45:03.662714 dbsqlok() marker is fd
16:45:03.662753 processing result tokens. marker is fd(DONE)
16:45:03.662797 tds_process_end() more_results = 0, was_cancelled = 0
16:45:03.662844 dbsqlok() end status was success
16:45:03.662881 dbresults()
16:45:03.662913 dbresults_r()
16:45:03.662946 tds_process_result_tokens() state is COMPLETED
16:45:03.662982 leaving dbresults() returning 1
16:45:03.663020 dbresults()
16:45:03.663052 dbresults_r()
16:45:03.663083 tds_process_result_tokens() state is COMPLETED
16:45:03.663120 leaving dbresults() returning 2
16:45:03.663186 dbcmd() bufsz = 45
16:45:03.663227 in dbfreebuf()
16:45:03.663266 in dbsqlexec()
16:45:03.663300 in dbsqlsend()
16:45:03.663338 tds_put_string converting 0 bytes of "insert into #dblib0024
values (2, 'row 002')"
16:45:03.663396 tds_put_string wrote 88 bytes
Sending packet @ 16:45:03.663442
0000 01 01 00 60 00 00 01 00-69 00 6e 00 73 00 65 00 |...`.... i.n.s.e.|
0010 72 00 74 00 20 00 69 00-6e 00 74 00 6f 00 20 00 |r.t. .i. n.t.o. .|
0020 23 00 64 00 62 00 6c 00-69 00 62 00 30 00 30 00 |#.d.b.l. i.b.0.0.|
0030 32 00 34 00 20 00 76 00-61 00 6c 00 75 00 65 00 |2.4. .v. a.l.u.e.|
0040 73 00 20 00 28 00 32 00-2c 00 20 00 27 00 72 00 |s. .(.2. ,. .'.r.|
0050 6f 00 77 00 20 00 30 00-30 00 32 00 27 00 29 00 |o.w. .0. 0.2.'.).|


16:45:03.663897 in dbsqlok()
Received header @ 16:45:03.665721
0000 04 01 00 11 00 36 01 00- |.....6..|


Received packet @ 16:45:03.665840
0000 fd 10 00 c3 00 01 00 00-00 |........ .|


16:45:03.665923 dbsqlok() marker is fd
16:45:03.665962 processing result tokens. marker is fd(DONE)
16:45:03.666007 tds_process_end() more_results = 0, was_cancelled = 0
16:45:03.666053 dbsqlok() end status was success
16:45:03.666091 dbresults()
16:45:03.666122 dbresults_r()
16:45:03.666154 tds_process_result_tokens() state is COMPLETED
16:45:03.666191 leaving dbresults() returning 1
16:45:03.666229 dbresults()
16:45:03.666261 dbresults_r()
16:45:03.666292 tds_process_result_tokens() state is COMPLETED
16:45:03.666329 leaving dbresults() returning 2
16:45:03.666395 dbcmd() bufsz = 45
16:45:03.666436 in dbfreebuf()
16:45:03.666475 in dbsqlexec()
16:45:03.666509 in dbsqlsend()
16:45:03.666548 tds_put_string converting 0 bytes of "insert into #dblib0024
values (3, 'row 003')"
16:45:03.666605 tds_put_string wrote 88 bytes
Sending packet @ 16:45:03.666652
0000 01 01 00 60 00 00 01 00-69 00 6e 00 73 00 65 00 |...`.... i.n.s.e.|
0010 72 00 74 00 20 00 69 00-6e 00 74 00 6f 00 20 00 |r.t. .i. n.t.o. .|
0020 23 00 64 00 62 00 6c 00-69 00 62 00 30 00 30 00 |#.d.b.l. i.b.0.0.|
0030 32 00 34 00 20 00 76 00-61 00 6c 00 75 00 65 00 |2.4. .v. a.l.u.e.|
0040 73 00 20 00 28 00 33 00-2c 00 20 00 27 00 72 00 |s. .(.3. ,. .'.r.|
0050 6f 00 77 00 20 00 30 00-30 00 33 00 27 00 29 00 |o.w. .0. 0.3.'.).|


16:45:03.667076 in dbsqlok()
Received header @ 16:45:03.668905
0000 04 01 00 11 00 36 01 00- |.....6..|


Received packet @ 16:45:03.669024
0000 fd 10 00 c3 00 01 00 00-00 |........ .|


16:45:03.669107 dbsqlok() marker is fd
16:45:03.669146 processing result tokens. marker is fd(DONE)
16:45:03.669190 tds_process_end() more_results = 0, was_cancelled = 0
16:45:03.669237 dbsqlok() end status was success
16:45:03.669274 dbresults()
16:45:03.669305 dbresults_r()
16:45:03.669337 tds_process_result_tokens() state is COMPLETED
16:45:03.669374 leaving dbresults() returning 1
16:45:03.669411 dbresults()
16:45:03.669443 dbresults_r()
16:45:03.669475 tds_process_result_tokens() state is COMPLETED
16:45:03.669511 leaving dbresults() returning 2
16:45:03.669577 dbcmd() bufsz = 45
16:45:03.669618 in dbfreebuf()
16:45:03.669657 in dbsqlexec()
16:45:03.669691 in dbsqlsend()
16:45:03.669729 tds_put_string converting 0 bytes of "insert into #dblib0024
values (4, 'row 004')"
16:45:03.669786 tds_put_string wrote 88 bytes
Sending packet @ 16:45:03.669833
0000 01 01 00 60 00 00 01 00-69 00 6e 00 73 00 65 00 |...`.... i.n.s.e.|
0010 72 00 74 00 20 00 69 00-6e 00 74 00 6f 00 20 00 |r.t. .i. n.t.o. .|
0020 23 00 64 00 62 00 6c 00-69 00 62 00 30 00 30 00 |#.d.b.l. i.b.0.0.|
0030 32 00 34 00 20 00 76 00-61 00 6c 00 75 00 65 00 |2.4. .v. a.l.u.e.|
0040 73 00 20 00 28 00 34 00-2c 00 20 00 27 00 72 00 |s. .(.4. ,. .'.r.|
0050 6f 00 77 00 20 00 30 00-30 00 34 00 27 00 29 00 |o.w. .0. 0.4.'.).|


16:45:03.670274 in dbsqlok()
Received header @ 16:45:03.672096
0000 04 01 00 11 00 36 01 00- |.....6..|


Received packet @ 16:45:03.672215
0000 fd 10 00 c3 00 01 00 00-00 |........ .|


16:45:03.672298 dbsqlok() marker is fd
16:45:03.672338 processing result tokens. marker is fd(DONE)
16:45:03.672382 tds_process_end() more_results = 0, was_cancelled = 0
16:45:03.672428 dbsqlok() end status was success
16:45:03.672465 dbresults()
16:45:03.672497 dbresults_r()
16:45:03.672529 tds_process_result_tokens() state is COMPLETED
16:45:03.672565 leaving dbresults() returning 1
16:45:03.672631 dbresults()
16:45:03.672670 dbresults_r()
16:45:03.672702 tds_process_result_tokens() state is COMPLETED
16:45:03.672739 leaving dbresults() returning 2
16:45:03.672806 dbcmd() bufsz = 45
16:45:03.672848 in dbfreebuf()
16:45:03.672887 in dbsqlexec()
16:45:03.672921 in dbsqlsend()
16:45:03.672961 tds_put_string converting 0 bytes of "insert into #dblib0024
values (5, 'row 005')"
16:45:03.673018 tds_put_string wrote 88 bytes
Sending packet @ 16:45:03.673064
0000 01 01 00 60 00 00 01 00-69 00 6e 00 73 00 65 00 |...`.... i.n.s.e.|
0010 72 00 74 00 20 00 69 00-6e 00 74 00 6f 00 20 00 |r.t. .i. n.t.o. .|
0020 23 00 64 00 62 00 6c 00-69 00 62 00 30 00 30 00 |#.d.b.l. i.b.0.0.|
0030 32 00 34 00 20 00 76 00-61 00 6c 00 75 00 65 00 |2.4. .v. a.l.u.e.|
0040 73 00 20 00 28 00 35 00-2c 00 20 00 27 00 72 00 |s. .(.5. ,. .'.r.|
0050 6f 00 77 00 20 00 30 00-30 00 35 00 27 00 29 00 |o.w. .0. 0.5.'.).|


16:45:03.673489 in dbsqlok()
Received header @ 16:45:03.675314
0000 04 01 00 11 00 36 01 00- |.....6..|


Received packet @ 16:45:03.675433
0000 fd 10 00 c3 00 01 00 00-00 |........ .|


16:45:03.675517 dbsqlok() marker is fd
16:45:03.675557 processing result tokens. marker is fd(DONE)
16:45:03.675601 tds_process_end() more_results = 0, was_cancelled = 0
16:45:03.675648 dbsqlok() end status was success
16:45:03.675685 dbresults()
16:45:03.675716 dbresults_r()
16:45:03.675748 tds_process_result_tokens() state is COMPLETED
16:45:03.675785 leaving dbresults() returning 1
16:45:03.675822 dbresults()
16:45:03.675854 dbresults_r()
16:45:03.675885 tds_process_result_tokens() state is COMPLETED
16:45:03.675922 leaving dbresults() returning 2
16:45:03.675987 dbcmd() bufsz = 45
16:45:03.676028 in dbfreebuf()
16:45:03.676068 in dbsqlexec()
16:45:03.676101 in dbsqlsend()
16:45:03.676140 tds_put_string converting 0 bytes of "insert into #dblib0024
values (6, 'row 006')"
16:45:03.676197 tds_put_string wrote 88 bytes
Sending packet @ 16:45:03.676243
0000 01 01 00 60 00 00 01 00-69 00 6e 00 73 00 65 00 |...`.... i.n.s.e.|
0010 72 00 74 00 20 00 69 00-6e 00 74 00 6f 00 20 00 |r.t. .i. n.t.o. .|
0020 23 00 64 00 62 00 6c 00-69 00 62 00 30 00 30 00 |#.d.b.l. i.b.0.0.|
0030 32 00 34 00 20 00 76 00-61 00 6c 00 75 00 65 00 |2.4. .v. a.l.u.e.|
0040 73 00 20 00 28 00 36 00-2c 00 20 00 27 00 72 00 |s. .(.6. ,. .'.r.|
0050 6f 00 77 00 20 00 30 00-30 00 36 00 27 00 29 00 |o.w. .0. 0.6.'.).|


16:45:03.676667 in dbsqlok()
Received header @ 16:45:03.678485
0000 04 01 00 11 00 36 01 00- |.....6..|


Received packet @ 16:45:03.678604
0000 fd 10 00 c3 00 01 00 00-00 |........ .|


16:45:03.678688 dbsqlok() marker is fd
16:45:03.678727 processing result tokens. marker is fd(DONE)
16:45:03.678771 tds_process_end() more_results = 0, was_cancelled = 0
16:45:03.678818 dbsqlok() end status was success
16:45:03.678855 dbresults()
16:45:03.678886 dbresults_r()
16:45:03.678918 tds_process_result_tokens() state is COMPLETED
16:45:03.678955 leaving dbresults() returning 1
16:45:03.678992 dbresults()
16:45:03.679024 dbresults_r()
16:45:03.679056 tds_process_result_tokens() state is COMPLETED
16:45:03.679093 leaving dbresults() returning 2
16:45:03.679159 dbcmd() bufsz = 45
16:45:03.679200 in dbfreebuf()
16:45:03.679239 in dbsqlexec()
16:45:03.679273 in dbsqlsend()
16:45:03.679311 tds_put_string converting 0 bytes of "insert into #dblib0024
values (7, 'row 007')"
16:45:03.679368 tds_put_string wrote 88 bytes
Sending packet @ 16:45:03.679415
0000 01 01 00 60 00 00 01 00-69 00 6e 00 73 00 65 00 |...`.... i.n.s.e.|
0010 72 00 74 00 20 00 69 00-6e 00 74 00 6f 00 20 00 |r.t. .i. n.t.o. .|
0020 23 00 64 00 62 00 6c 00-69 00 62 00 30 00 30 00 |#.d.b.l. i.b.0.0.|
0030 32 00 34 00 20 00 76 00-61 00 6c 00 75 00 65 00 |2.4. .v. a.l.u.e.|
0040 73 00 20 00 28 00 37 00-2c 00 20 00 27 00 72 00 |s. .(.7. ,. .'.r.|
0050 6f 00 77 00 20 00 30 00-30 00 37 00 27 00 29 00 |o.w. .0. 0.7.'.).|


16:45:03.679838 in dbsqlok()
Received header @ 16:45:03.681897
0000 04 01 00 11 00 36 01 00- |.....6..|


Received packet @ 16:45:03.682046
0000 fd 10 00 c3 00 01 00 00-00 |........ .|


16:45:03.682134 dbsqlok() marker is fd
16:45:03.682173 processing result tokens. marker is fd(DONE)
16:45:03.682218 tds_process_end() more_results = 0, was_cancelled = 0
16:45:03.682265 dbsqlok() end status was success
16:45:03.682302 dbresults()
16:45:03.682334 dbresults_r()
16:45:03.682365 tds_process_result_tokens() state is COMPLETED
16:45:03.682402 leaving dbresults() returning 1
16:45:03.682439 dbresults()
16:45:03.682471 dbresults_r()
16:45:03.682503 tds_process_result_tokens() state is COMPLETED
16:45:03.682539 leaving dbresults() returning 2
16:45:03.682606 dbcmd() bufsz = 45
16:45:03.682647 in dbfreebuf()
16:45:03.682687 in dbsqlexec()
16:45:03.682720 in dbsqlsend()
16:45:03.682759 tds_put_string converting 0 bytes of "insert into #dblib0024
values (8, 'row 008')"
16:45:03.682817 tds_put_string wrote 88 bytes
Sending packet @ 16:45:03.682863
0000 01 01 00 60 00 00 01 00-69 00 6e 00 73 00 65 00 |...`.... i.n.s.e.|
0010 72 00 74 00 20 00 69 00-6e 00 74 00 6f 00 20 00 |r.t. .i. n.t.o. .|
0020 23 00 64 00 62 00 6c 00-69 00 62 00 30 00 30 00 |#.d.b.l. i.b.0.0.|
0030 32 00 34 00 20 00 76 00-61 00 6c 00 75 00 65 00 |2.4. .v. a.l.u.e.|
0040 73 00 20 00 28 00 38 00-2c 00 20 00 27 00 72 00 |s. .(.8. ,. .'.r.|
0050 6f 00 77 00 20 00 30 00-30 00 38 00 27 00 29 00 |o.w. .0. 0.8.'.).|


16:45:03.683288 in dbsqlok()
Received header @ 16:45:03.685121
0000 04 01 00 11 00 36 01 00- |.....6..|


Received packet @ 16:45:03.685240
0000 fd 10 00 c3 00 01 00 00-00 |........ .|


16:45:03.685323 dbsqlok() marker is fd
16:45:03.685362 processing result tokens. marker is fd(DONE)
16:45:03.685407 tds_process_end() more_results = 0, was_cancelled = 0
16:45:03.685453 dbsqlok() end status was success
16:45:03.685490 dbresults()
16:45:03.685522 dbresults_r()
16:45:03.685554 tds_process_result_tokens() state is COMPLETED
16:45:03.685590 leaving dbresults() returning 1
16:45:03.685627 dbresults()
16:45:03.685659 dbresults_r()
16:45:03.685691 tds_process_result_tokens() state is COMPLETED
16:45:03.685727 leaving dbresults() returning 2
16:45:03.685793 dbcmd() bufsz = 45
16:45:03.685834 in dbfreebuf()
16:45:03.685873 in dbsqlexec()
16:45:03.685907 in dbsqlsend()
16:45:03.685945 tds_put_string converting 0 bytes of "insert into #dblib0024
values (9, 'row 009')"
16:45:03.686001 tds_put_string wrote 88 bytes
Sending packet @ 16:45:03.686048
0000 01 01 00 60 00 00 01 00-69 00 6e 00 73 00 65 00 |...`.... i.n.s.e.|
0010 72 00 74 00 20 00 69 00-6e 00 74 00 6f 00 20 00 |r.t. .i. n.t.o. .|
0020 23 00 64 00 62 00 6c 00-69 00 62 00 30 00 30 00 |#.d.b.l. i.b.0.0.|
0030 32 00 34 00 20 00 76 00-61 00 6c 00 75 00 65 00 |2.4. .v. a.l.u.e.|
0040 73 00 20 00 28 00 39 00-2c 00 20 00 27 00 72 00 |s. .(.9. ,. .'.r.|
0050 6f 00 77 00 20 00 30 00-30 00 39 00 27 00 29 00 |o.w. .0. 0.9.'.).|


16:45:03.686472 in dbsqlok()
Received header @ 16:45:03.688324
0000 04 01 00 11 00 36 01 00- |.....6..|


Received packet @ 16:45:03.688443
0000 fd 10 00 c3 00 01 00 00-00 |........ .|


16:45:03.688526 dbsqlok() marker is fd
16:45:03.688566 processing result tokens. marker is fd(DONE)
16:45:03.688610 tds_process_end() more_results = 0, was_cancelled = 0
16:45:03.688657 dbsqlok() end status was success
16:45:03.688694 dbresults()
16:45:03.688726 dbresults_r()
16:45:03.688758 tds_process_result_tokens() state is COMPLETED
16:45:03.688795 leaving dbresults() returning 1
16:45:03.688832 dbresults()
16:45:03.688864 dbresults_r()
16:45:03.688895 tds_process_result_tokens() state is COMPLETED
16:45:03.688932 leaving dbresults() returning 2
16:45:03.688985 dbcmd() bufsz = 45
16:45:03.689026 in dbfreebuf()
16:45:03.689066 in dbsqlexec()
16:45:03.689100 in dbsqlsend()
16:45:03.689139 tds_put_string converting 0 bytes of "select count(*) from
#dblib0024 -- order by i"
16:45:03.689197 tds_put_string wrote 90 bytes
Sending packet @ 16:45:03.689243
0000 01 01 00 62 00 00 01 00-73 00 65 00 6c 00 65 00 |...b.... s.e.l.e.|
0010 63 00 74 00 20 00 63 00-6f 00 75 00 6e 00 74 00 |c.t. .c. o.u.n.t.|
0020 28 00 2a 00 29 00 20 00-66 00 72 00 6f 00 6d 00 |(.*.). . f.r.o.m.|
0030 20 00 23 00 64 00 62 00-6c 00 69 00 62 00 30 00 | .#.d.b. l.i.b.0.|
0040 30 00 32 00 34 00 20 00-2d 00 2d 00 20 00 6f 00 |0.2.4. . -.-. .o.|
0050 72 00 64 00 65 00 72 00-20 00 62 00 79 00 20 00 |r.d.e.r. .b.y. .|
0060 69 00 - |i.|


16:45:03.689725 in dbsqlok()
Received header @ 16:45:03.691610
0000 04 01 00 21 00 36 01 00- |...!.6..|


Received packet @ 16:45:03.691730
0000 81 01 00 00 00 09 00 26-04 00 d1 04 0a 00 00 00 |.......& ........|
0010 fd 10 00 c1 00 01 00 00-00 |........ .|


16:45:03.691866 dbsqlok() marker is 81
16:45:03.691905 dbsqlok() found result token
16:45:03.691954 dbmorecmds()
16:45:03.691990 dbresults_r()
16:45:03.692024 processing result tokens. marker is 81(TDS7_RESULT)
16:45:03.692094 tds7_get_data_info:1293:
type = 38 (integer-null)
column_varint_size = 1
colname = (0 bytes)
column_size = 4 (4 on server)
16:45:03.692175 dbresults_r() result_type = 4049 retcode = 1
16:45:03.692225 processing result tokens. marker is d1(ROW)
16:45:03.692268 dbresults_r() result_type = 4040 retcode = 1
16:45:03.692311 dbresults()
16:45:03.692343 dbresults_r()
16:45:03.692377 leaving dbresults() returning 1
16:45:03.692415 dbmorecmds()
16:45:03.692447 dbresults_r()
16:45:03.692480 processing result tokens. marker is d1(ROW)
16:45:03.692521 dbresults_r() result_type = 4040 retcode = 1



Archive powered by MHonArc 2.6.24.

Top of Page