Skip to Content.
Sympa Menu

freetds - [freetds] RE: FreeTDS Digest, Vol 11, Issue 16

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "David Nsengiyumva" <davidn AT finsolutions.co.za>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] RE: FreeTDS Digest, Vol 11, Issue 16
  • Date: Fri, 5 Dec 2003 09:35:22 +0200

Hi there,

I am having a problem with retrieving a result set that contains Numbers and
Dates.
In the 'cs_convert' It goes to the switch where 'src_type == desttype' and
then to
case 'SYBNUMERIC' and 'SYBDECIMAL', but the 'memcpy(dest, srcdata, src_len)'
copies an empty string. What can be wrong??

My log file looks like this:

Starting log file with debug level 99.
2003-12-05 09:22:46 iconv library not employed, relying on ISO-8859-1
compatibility
2003-12-05 09:22:46 Connecting addr 10.0.3.73 port 1433 with TDS version 7.0
2003-12-05 09:22:46 inside tds_process_login_tokens()
Received header @ 2003-12-05 09:22:46
0000 04 01 01 b0 00 45 01 00 |.....E..|


Received packet @ 2003-12-05 09:22:46
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 6e |..m.a.s. t.e.r..n|
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 0c 46 00 49 00 4e 00 53 00 4f 00 4c 00 |....F.I. N.S.O.L.|
0080 53 00 51 00 4c 00 44 00 45 00 56 00 00 00 00 e3 |S.Q.L.D. E.V.....|
0090 17 00 02 0a 75 00 73 00 5f 00 65 00 6e 00 67 00 |....u.s. _.e.n.g.|
00a0 6c 00 69 00 73 00 68 00 00 ab 72 00 47 16 00 00 |l.i.s.h. ..r.G...|
00b0 01 00 27 00 43 00 68 00 61 00 6e 00 67 00 65 00 |..'.C.h. a.n.g.e.|
00c0 64 00 20 00 6c 00 61 00 6e 00 67 00 75 00 61 00 |d. .l.a. n.g.u.a.|
00d0 67 00 65 00 20 00 73 00 65 00 74 00 74 00 69 00 |g.e. .s. e.t.t.i.|
00e0 6e 00 67 00 20 00 74 00 6f 00 20 00 75 00 73 00 |n.g. .t. o. .u.s.|
00f0 5f 00 65 00 6e 00 67 00 6c 00 69 00 73 00 68 00 |_.e.n.g. l.i.s.h.|
0100 2e 00 0c 46 00 49 00 4e 00 53 00 4f 00 4c 00 53 |...F.I.N .S.O.L.S|
0110 00 51 00 4c 00 44 00 45 00 56 00 00 00 00 e3 0f |.Q.L.D.E .V......|
0120 00 03 05 69 00 73 00 6f 00 5f 00 31 00 01 00 00 |...i.s.o ._.1....|
0130 e3 0b 00 05 04 31 00 30 00 33 00 33 00 00 e3 0f |.....1.0 .3.3....|
0140 00 06 06 31 00 39 00 36 00 36 00 30 00 39 00 00 |...1.9.6 .6.0.9..|
0150 ad 36 00 01 07 00 00 00 16 4d 00 69 00 63 00 72 |.6...... .M.i.c.r|
0160 00 6f 00 73 00 6f 00 66 00 74 00 20 00 53 00 51 |.o.s.o.f .t. .S.Q|
0170 00 4c 00 20 00 53 00 65 00 72 00 76 00 65 00 72 |.L. .S.e .r.v.e.r|
0180 00 00 00 00 00 08 00 02 f8 e3 13 00 04 04 34 00 |........ ......4.|
0190 30 00 39 00 36 00 04 34 00 30 00 39 00 36 00 fd |0.9.6..4 .0.9.6..|
01a0 00 00 00 00 00 00 00 00 |........|


2003-12-05 09:22:46 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-12-05 09:22:46 inside tds_process_default_tokens() marker is ab(INFO)
2003-12-05 09:22:46 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-12-05 09:22:46 inside tds_process_default_tokens() marker is ab(INFO)
2003-12-05 09:22:46 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-12-05 09:22:46 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-12-05 09:22:46 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-12-05 09:22:46 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-12-05 09:22:46 increasing block size from 4096 to 4096
2003-12-05 09:22:46 inside tds_process_default_tokens() marker is fd(DONE)
2003-12-05 09:22:46 inside tds_process_end() more_results = 0, was_cancelled
= 0
2003-12-05 09:22:46 inside tds_process_default_tokens() setting state to
COMPLETED
Sending packet @ 2003-12-05 09:22:46
0000 01 01 00 22 00 00 01 00 73 00 65 00 6c 00 65 00 |...".... s.e.l.e.|
0010 63 00 74 00 20 00 40 00 40 00 73 00 70 00 69 00 |c.t. .@. @.s.p.i.|
0020 64 00 |d.|


Received header @ 2003-12-05 09:22:46
0000 04 01 00 1d 00 45 01 00 |.....E..|


Received packet @ 2003-12-05 09:22:46
0000 81 01 00 00 00 00 00 34 00 d1 45 00 fd 10 00 c1 |.......4 ..E.....|
0010 00 01 00 00 00 |.....|


2003-12-05 09:22:46 processing result tokens. marker is 81(TDS7_RESULT)
2003-12-05 09:22:46 tds7_get_data_info:1083:
type = 52 (smallint)
column_varint_size = 0
colname =
colnamelen = 0
2003-12-05 09:22:46 processing row tokens. marker is d1(ROW)
2003-12-05 09:22:46 processing row. column is 0 varint size = 0
2003-12-05 09:22:46 processing row. column size is 2
2003-12-05 09:22:46 clearing column 0 NULL bit
2003-12-05 09:22:46 processing row tokens. marker is fd(DONE)
2003-12-05 09:22:46 inside tds_process_end() more_results = 0, was_cancelled
= 0
2003-12-05 09:22:46 inside tds_process_result_tokens() state is COMPLETED
2003-12-05 09:22:46 leaving tds_process_login_tokens() returning 1
2003-12-05 09:22:46 leaving ct_connect() returning 1
2003-12-05 09:22:46 inside ct_cmd_alloc()
2003-12-05 09:22:47 inside ct_command()
2003-12-05 09:22:47 inside ct_send()
Sending packet @ 2003-12-05 09:22:47
0000 01 01 00 2a 00 00 01 00 75 00 73 00 65 00 20 00 |...*.... u.s.e. .|
0010 71 00 75 00 61 00 6e 00 74 00 5f 00 62 00 61 00 |q.u.a.n. t._.b.a.|
0020 73 00 65 00 5f 00 76 00 33 00 |s.e._.v. 3.|


2003-12-05 09:22:47 ct_send() succeeded
2003-12-05 09:22:47 inside ct_results()
Received header @ 2003-12-05 09:22:47
0000 04 01 00 bc 00 45 01 00 |.....E..|


Received packet @ 2003-12-05 09:22:48
0000 e3 29 00 01 0d 71 00 75 00 61 00 6e 00 74 00 5f |.)...q.u .a.n.t._|
0010 00 62 00 61 00 73 00 65 00 5f 00 76 00 33 00 06 |.b.a.s.e ._.v.3..|
0020 6d 00 61 00 73 00 74 00 65 00 72 00 ab 7c 00 45 |m.a.s.t. e.r..|.E|
0030 16 00 00 01 00 2c 00 43 00 68 00 61 00 6e 00 67 |.....,.C .h.a.n.g|
0040 00 65 00 64 00 20 00 64 00 61 00 74 00 61 00 62 |.e.d. .d .a.t.a.b|
0050 00 61 00 73 00 65 00 20 00 63 00 6f 00 6e 00 74 |.a.s.e. .c.o.n.t|
0060 00 65 00 78 00 74 00 20 00 74 00 6f 00 20 00 27 |.e.x.t. .t.o. .'|
0070 00 71 00 75 00 61 00 6e 00 74 00 5f 00 62 00 61 |.q.u.a.n .t._.b.a|
0080 00 73 00 65 00 5f 00 76 00 33 00 27 00 2e 00 0c |.s.e._.v .3.'....|
0090 46 00 49 00 4e 00 53 00 4f 00 4c 00 53 00 51 00 |F.I.N.S. O.L.S.Q.|
00a0 4c 00 44 00 45 00 56 00 00 01 00 fd 00 00 e2 00 |L.D.E.V. ........|
00b0 00 00 00 00 |....|


2003-12-05 09:22:48 processing result tokens. marker is e3(ENVCHANGE)
2003-12-05 09:22:48 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-12-05 09:22:48 processing result tokens. marker is ab(INFO)
2003-12-05 09:22:48 inside tds_process_default_tokens() marker is ab(INFO)
2003-12-05 09:22:48 processing result tokens. marker is fd(DONE)
2003-12-05 09:22:48 inside tds_process_end() more_results = 0, was_cancelled
= 0
2003-12-05 09:22:48 inside ct_results() process_result_tokens returned 1
(type 4047)
2003-12-05 09:22:48 inside ct_results()
2003-12-05 09:22:48 inside tds_process_result_tokens() state is COMPLETED
2003-12-05 09:22:48 inside ct_results() process_result_tokens returned 2
(type 4046)
2003-12-05 09:22:54 inside ct_command()
2003-12-05 09:22:54 inside ct_send()
Sending packet @ 2003-12-05 09:22:54
0000 01 01 01 c2 00 00 01 00 53 00 45 00 4c 00 45 00 |........ S.E.L.E.|
0010 43 00 54 00 20 00 63 00 2e 00 6e 00 61 00 6d 00 |C.T. .c. ..n.a.m.|
0020 65 00 20 00 27 00 70 00 61 00 72 00 61 00 6d 00 |e. .'.p. a.r.a.m.|
0030 65 00 74 00 65 00 72 00 5f 00 6e 00 61 00 6d 00 |e.t.e.r. _.n.a.m.|
0040 65 00 27 00 2c 00 20 00 74 00 2e 00 6e 00 61 00 |e.'.,. . t...n.a.|
0050 6d 00 65 00 20 00 27 00 70 00 61 00 72 00 61 00 |m.e. .'. p.a.r.a.|
0060 6d 00 65 00 74 00 65 00 72 00 5f 00 74 00 79 00 |m.e.t.e. r._.t.y.|
0070 70 00 65 00 27 00 20 00 46 00 52 00 4f 00 4d 00 |p.e.'. . F.R.O.M.|
0080 20 00 73 00 79 00 73 00 6f 00 62 00 6a 00 65 00 | .s.y.s. o.b.j.e.|
0090 63 00 74 00 73 00 20 00 6f 00 20 00 49 00 4e 00 |c.t.s. . o. .I.N.|
00a0 4e 00 45 00 52 00 20 00 4a 00 4f 00 49 00 4e 00 |N.E.R. . J.O.I.N.|
00b0 20 00 73 00 79 00 73 00 63 00 6f 00 6c 00 75 00 | .s.y.s. c.o.l.u.|
00c0 6d 00 6e 00 73 00 20 00 63 00 20 00 4f 00 4e 00 |m.n.s. . c. .O.N.|
00d0 20 00 28 00 6f 00 2e 00 69 00 64 00 20 00 3d 00 | .(.o... i.d. .=.|
00e0 20 00 63 00 2e 00 69 00 64 00 29 00 20 00 49 00 | .c...i. d.). .I.|
00f0 4e 00 4e 00 45 00 52 00 20 00 4a 00 4f 00 49 00 |N.N.E.R. .J.O.I.|
0100 4e 00 20 00 73 00 79 00 73 00 74 00 79 00 70 00 |N. .s.y. s.t.y.p.|
0110 65 00 73 00 20 00 74 00 20 00 4f 00 4e 00 20 00 |e.s. .t. .O.N. .|
0120 28 00 63 00 2e 00 78 00 74 00 79 00 70 00 65 00 |(.c...x. t.y.p.e.|
0130 20 00 3d 00 20 00 74 00 2e 00 78 00 74 00 79 00 | .=. .t. ..x.t.y.|
0140 70 00 65 00 29 00 20 00 57 00 48 00 45 00 52 00 |p.e.). . W.H.E.R.|
0150 45 00 20 00 6f 00 2e 00 6e 00 61 00 6d 00 65 00 |E. .o... n.a.m.e.|
0160 20 00 3d 00 20 00 27 00 61 00 70 00 5f 00 73 00 | .=. .'. a.p._.s.|
0170 65 00 6c 00 5f 00 65 00 71 00 75 00 69 00 74 00 |e.l._.e. q.u.i.t.|
0180 79 00 5f 00 6d 00 65 00 74 00 61 00 5f 00 64 00 |y._.m.e. t.a._.d.|
0190 61 00 74 00 61 00 27 00 20 00 4f 00 52 00 44 00 |a.t.a.'. .O.R.D.|
01a0 45 00 52 00 20 00 42 00 59 00 20 00 63 00 2e 00 |E.R. .B. Y. .c...|
01b0 63 00 6f 00 6c 00 6f 00 72 00 64 00 65 00 72 00 |c.o.l.o. r.d.e.r.|
01c0 3b 00 |;.|


2003-12-05 09:22:54 ct_send() succeeded
2003-12-05 09:22:55 inside ct_results()
Received header @ 2003-12-05 09:22:55
0000 04 01 00 8c 00 45 01 00 |.....E..|


Received packet @ 2003-12-05 09:22:55
0000 81 02 00 00 01 08 00 e7 00 01 0e 70 00 61 00 72 |........ ...p.a.r|
0010 00 61 00 6d 00 65 00 74 00 65 00 72 00 5f 00 6e |.a.m.e.t .e.r._.n|
0020 00 61 00 6d 00 65 00 00 01 08 00 e7 00 01 0e 70 |.a.m.e.. .......p|
0030 00 61 00 72 00 61 00 6d 00 65 00 74 00 65 00 72 |.a.r.a.m .e.t.e.r|
0040 00 5f 00 74 00 79 00 70 00 65 00 a9 02 00 00 00 |._.t.y.p .e......|
0050 d1 18 00 40 00 70 00 5f 00 65 00 71 00 75 00 69 |...@.p._ .e.q.u.i|
0060 00 74 00 79 00 5f 00 69 00 64 00 0e 00 6e 00 75 |.t.y._.i .d...n.u|
0070 00 6d 00 65 00 72 00 69 00 63 00 fd 10 00 c1 00 |.m.e.r.i .c......|
0080 01 00 00 00 |....|


2003-12-05 09:22:55 processing result tokens. marker is 81(TDS7_RESULT)
2003-12-05 09:22:55 tds7_get_data_info:1083:
type = 39 (varchar)
column_varint_size = 2
colname = parameter_name
colnamelen = 14
2003-12-05 09:22:55 tds7_get_data_info:1083:
type = 39 (varchar)
column_varint_size = 2
colname = parameter_type
colnamelen = 14
2003-12-05 09:22:55 inside ct_results() process_result_tokens returned 1
(type 4049)
2003-12-05 09:22:55 processing result tokens. marker is a9(ORDERBY)
2003-12-05 09:22:55 inside tds_process_default_tokens() marker is
a9(ORDERBY)
eating token 169
2003-12-05 09:22:55 processing result tokens. marker is d1(ROW)
2003-12-05 09:22:55 inside ct_results() process_result_tokens returned 1
(type 4040)
2003-12-05 09:22:58 inside ct_res_info()
2003-12-05 09:22:58 ct_res_info(): Number of columns is 2
2003-12-05 09:23:11 inside ct_describe()
2003-12-05 09:23:14 inside _ct_get_client_type(type 39, size 256)
2003-12-05 09:23:14 inside ct_describe() datafmt->datatype = 1 server type
39
2003-12-05 09:23:22 inside ct_bind()
2003-12-05 09:23:25 inside ct_bind() item = 1 datafmt->datatype = 1
2003-12-05 09:23:29 inside ct_describe()
2003-12-05 09:23:32 inside _ct_get_client_type(type 39, size 256)
2003-12-05 09:23:33 inside ct_describe() datafmt->datatype = 1 server type
39
2003-12-05 09:23:45 inside ct_bind()
2003-12-05 09:23:47 inside ct_bind() item = 2 datafmt->datatype = 1
2003-12-05 09:24:12 inside ct_fetch()
2003-12-05 09:24:17 processing row tokens. marker is d1(ROW)
2003-12-05 09:24:17 processing row. column is 0 varint size = 2
2003-12-05 09:24:17 processing row. column size is 24
2003-12-05 09:24:17 clearing column 0 NULL bit
2003-12-05 09:24:17 processing row. column is 1 varint size = 2
2003-12-05 09:24:17 processing row. column size is 14
2003-12-05 09:24:17 clearing column 1 NULL bit
2003-12-05 09:24:17 inside ct_fetch() process_row_tokens returned 1
2003-12-05 09:24:21 inside _ct_bind_data()
2003-12-05 09:24:23 inside _ct_get_server_type(1)
2003-12-05 09:24:25 inside _ct_get_client_type(type 39, size 256)
2003-12-05 09:24:26 inside _ct_bind_data() setting source length for 0 = 12
destlen = 256
2003-12-05 09:24:30 inside cs_convert()
2003-12-05 09:24:31 inside _ct_get_server_type(1)
2003-12-05 09:24:31 inside _ct_get_server_type(1)
2003-12-05 09:24:32 inside cs_convert() srctype = 47 (12) desttype = 47 (50)
2003-12-05 09:24:35 inside cs_convert() srctype = desttype
2003-12-05 09:24:35 inside cs_convert() desttype = character
2003-12-05 09:24:54 inside _ct_bind_data() length binding len = 13
2003-12-05 09:24:59 inside _ct_get_server_type(1)
2003-12-05 09:25:00 inside _ct_get_client_type(type 39, size 256)
2003-12-05 09:25:02 inside _ct_bind_data() setting source length for 1 = 7
destlen = 256
2003-12-05 09:25:05 inside cs_convert()
2003-12-05 09:25:05 inside _ct_get_server_type(1)
2003-12-05 09:25:05 inside _ct_get_server_type(1)
2003-12-05 09:25:05 inside cs_convert() srctype = 47 (7) desttype = 47 (50)
2003-12-05 09:25:05 inside cs_convert() srctype = desttype
2003-12-05 09:25:05 inside cs_convert() desttype = character
2003-12-05 09:25:07 inside _ct_bind_data() length binding len = 8
2003-12-05 09:25:20 inside ct_describe()
2003-12-05 09:25:23 inside _ct_get_client_type(type 39, size 256)
2003-12-05 09:25:23 inside ct_describe() datafmt->datatype = 1 server type
39
2003-12-05 09:25:32 inside ct_bind()
2003-12-05 09:25:34 inside ct_bind() item = 1 datafmt->datatype = 1
2003-12-05 09:25:41 inside ct_describe()
2003-12-05 09:25:43 inside _ct_get_client_type(type 39, size 256)
2003-12-05 09:25:43 inside ct_describe() datafmt->datatype = 1 server type
39
2003-12-05 09:25:52 inside ct_bind()
2003-12-05 09:25:54 inside ct_bind() item = 2 datafmt->datatype = 1
2003-12-05 09:26:03 inside ct_fetch()
2003-12-05 09:26:13 inside ct_results()
2003-12-05 09:26:13 processing result tokens. marker is fd(DONE)
2003-12-05 09:26:13 inside tds_process_end() more_results = 0, was_cancelled
= 0
2003-12-05 09:26:13 inside ct_results() process_result_tokens returned 1
(type 4046)
2003-12-05 09:26:14 inside ct_results()
2003-12-05 09:26:14 inside tds_process_result_tokens() state is COMPLETED
2003-12-05 09:26:14 inside ct_results() process_result_tokens returned 2
(type 4046)
2003-12-05 09:26:22 inside ct_command()
2003-12-05 09:26:23 inside ct_send()
Sending packet @ 2003-12-05 09:26:23
0000 01 01 00 62 00 00 01 00 65 00 78 00 65 00 63 00 |...b.... e.x.e.c.|
0010 20 00 61 00 70 00 5f 00 73 00 65 00 6c 00 5f 00 | .a.p._. s.e.l._.|
0020 65 00 71 00 75 00 69 00 74 00 79 00 5f 00 6d 00 |e.q.u.i. t.y._.m.|
0030 65 00 74 00 61 00 5f 00 64 00 61 00 74 00 61 00 |e.t.a._. d.a.t.a.|
0040 20 00 40 00 70 00 5f 00 65 00 71 00 75 00 69 00 | .@.p._. e.q.u.i.|
0050 74 00 79 00 5f 00 69 00 64 00 3d 00 31 00 30 00 |t.y._.i. d.=.1.0.|
0060 3b 00 |;.|


2003-12-05 09:26:23 ct_send() succeeded
2003-12-05 09:26:24 inside ct_results()
Received header @ 2003-12-05 09:26:24
0000 04 01 01 fe 00 45 01 00 |.....E..|


Received packet @ 2003-12-05 09:26:24
0000 81 03 00 00 00 10 00 6c 11 0a 00 0e 65 00 71 00 |.......l ....e.q.|
0010 75 00 69 00 74 00 79 00 5f 00 74 00 79 00 70 00 |u.i.t.y. _.t.y.p.|
0020 65 00 5f 00 69 00 64 00 00 00 08 00 6c 11 0a 00 |e._.i.d. ....l...|
0030 09 66 00 61 00 63 00 74 00 6f 00 72 00 5f 00 69 |.f.a.c.t .o.r._.i|
0040 00 64 00 00 00 08 00 6c 11 0a 00 15 65 00 6e 00 |.d.....l ....e.n.|
0050 74 00 69 00 74 00 79 00 5f 00 73 00 65 00 72 00 |t.i.t.y. _.s.e.r.|
0060 69 00 65 00 73 00 5f 00 74 00 79 00 70 00 65 00 |i.e.s._. t.y.p.e.|
0070 5f 00 69 00 64 00 d1 05 01 02 00 00 00 05 01 02 |_.i.d... ........|
0080 00 00 00 05 01 02 00 00 00 d1 05 01 02 00 00 00 |........ ........|
0090 05 01 03 00 00 00 05 01 02 00 00 00 d1 05 01 02 |........ ........|
00a0 00 00 00 05 01 04 00 00 00 05 01 02 00 00 00 d1 |........ ........|
00b0 05 01 02 00 00 00 05 01 05 00 00 00 05 01 02 00 |........ ........|
00c0 00 00 d1 05 01 02 00 00 00 05 01 06 00 00 00 05 |........ ........|
00d0 01 02 00 00 00 d1 05 01 02 00 00 00 05 01 07 00 |........ ........|
00e0 00 00 05 01 02 00 00 00 d1 05 01 02 00 00 00 05 |........ ........|
00f0 01 08 00 00 00 05 01 02 00 00 00 d1 05 01 02 00 |........ ........|
0100 00 00 05 01 09 00 00 00 05 01 02 00 00 00 d1 05 |........ ........|
0110 01 02 00 00 00 05 01 0a 00 00 00 05 01 02 00 00 |........ ........|
0120 00 d1 05 01 02 00 00 00 05 01 0b 00 00 00 05 01 |........ ........|
0130 02 00 00 00 d1 05 01 02 00 00 00 05 01 11 00 00 |........ ........|
0140 00 05 01 03 00 00 00 d1 05 01 02 00 00 00 05 01 |........ ........|
0150 12 00 00 00 05 01 03 00 00 00 d1 05 01 02 00 00 |........ ........|
0160 00 05 01 13 00 00 00 05 01 03 00 00 00 d1 05 01 |........ ........|
0170 02 00 00 00 05 01 14 00 00 00 05 01 03 00 00 00 |........ ........|
0180 d1 05 01 02 00 00 00 05 01 17 00 00 00 05 01 03 |........ ........|
0190 00 00 00 d1 05 01 02 00 00 00 05 01 18 00 00 00 |........ ........|
01a0 05 01 03 00 00 00 d1 05 01 02 00 00 00 05 01 19 |........ ........|
01b0 00 00 00 05 01 05 00 00 00 d1 05 01 02 00 00 00 |........ ........|
01c0 05 01 1a 00 00 00 05 01 04 00 00 00 d1 05 01 02 |........ ........|
01d0 00 00 00 05 01 1b 00 00 00 05 01 02 00 00 00 ff |........ ........|
01e0 11 00 c1 00 13 00 00 00 79 00 00 00 00 fe 00 00 |........ y.......|
01f0 e0 00 13 00 00 00 |......|


2003-12-05 09:26:24 processing result tokens. marker is 81(TDS7_RESULT)
2003-12-05 09:26:24 tds7_get_data_info:1083:
type = 108 (numeric)
column_varint_size = 1
colname = equity_type_id
colnamelen = 14
2003-12-05 09:26:24 tds7_get_data_info:1083:
type = 108 (numeric)
column_varint_size = 1
colname = factor_id
colnamelen = 9
2003-12-05 09:26:24 tds7_get_data_info:1083:
type = 108 (numeric)
column_varint_size = 1
colname = entity_series_type_id
colnamelen = 21
2003-12-05 09:26:24 inside ct_results() process_result_tokens returned 1
(type 4049)
2003-12-05 09:26:24 processing result tokens. marker is d1(ROW)
2003-12-05 09:26:24 inside ct_results() process_result_tokens returned 1
(type 4040)
2003-12-05 09:26:26 inside ct_res_info()
2003-12-05 09:26:26 ct_res_info(): Number of columns is 3
2003-12-05 09:26:30 inside ct_describe()
2003-12-05 09:26:32 inside _ct_get_client_type(type 108, size 17)
2003-12-05 09:26:33 inside ct_describe() datafmt->datatype = 7 server type
108
2003-12-05 09:26:42 inside ct_bind()
2003-12-05 09:26:47 inside ct_bind() item = 1 datafmt->datatype = 7
2003-12-05 09:26:55 inside ct_describe()
2003-12-05 09:26:57 inside _ct_get_client_type(type 108, size 17)
2003-12-05 09:26:57 inside ct_describe() datafmt->datatype = 7 server type
108
2003-12-05 09:27:06 inside ct_bind()
2003-12-05 09:27:06 inside ct_bind() item = 2 datafmt->datatype = 7
2003-12-05 09:27:11 inside ct_describe()
2003-12-05 09:27:13 inside _ct_get_client_type(type 108, size 17)
2003-12-05 09:27:13 inside ct_describe() datafmt->datatype = 7 server type
108
2003-12-05 09:27:19 inside ct_bind()
2003-12-05 09:27:19 inside ct_bind() item = 3 datafmt->datatype = 7
2003-12-05 09:27:25 inside ct_fetch()
2003-12-05 09:27:29 processing row tokens. marker is d1(ROW)
2003-12-05 09:27:29 processing row. column is 0 varint size = 1
2003-12-05 09:27:29 processing row. column size is 5
2003-12-05 09:27:29 clearing column 0 NULL bit
2003-12-05 09:27:29 swapping numeric data...
2003-12-05 09:27:29 processing row. column is 1 varint size = 1
2003-12-05 09:27:29 processing row. column size is 5
2003-12-05 09:27:29 clearing column 1 NULL bit
2003-12-05 09:27:29 swapping numeric data...
2003-12-05 09:27:29 processing row. column is 2 varint size = 1
2003-12-05 09:27:29 processing row. column size is 5
2003-12-05 09:27:29 clearing column 2 NULL bit
2003-12-05 09:27:29 swapping numeric data...
2003-12-05 09:27:30 inside ct_fetch() process_row_tokens returned 1
2003-12-05 09:27:36 inside _ct_bind_data()
2003-12-05 09:27:42 inside _ct_get_server_type(7)
2003-12-05 09:27:50 inside _ct_get_client_type(type 108, size 17)
2003-12-05 09:27:55 inside _ct_bind_data() setting source length for 0 = 35
destlen = 17
2003-12-05 09:28:03 inside cs_convert()
2003-12-05 09:28:03 inside _ct_get_server_type(7)
2003-12-05 09:28:04 inside _ct_get_server_type(7)
2003-12-05 09:28:05 inside cs_convert() srctype = 108 (35) desttype = 108
(50)
2003-12-05 09:28:09 inside cs_convert() srctype = desttype





  • [freetds] RE: FreeTDS Digest, Vol 11, Issue 16, David Nsengiyumva, 12/05/2003

Archive powered by MHonArc 2.6.24.

Top of Page