FreeTDS Development Group

["David Nsengiyumva" <davidn AT finsolutions.co.za>]

e: [freetds] Stored proc on MS SQL Server 2000
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Message-ID: <20031203201507.0fcf280f.jklowden AT schemamania.org>
Content-Type: text/plain; charset=US-ASCII

>>That sounds like you actually do get results back but don't read them.
>>TDSDUMP would answer that.
>>
>>Could you boil this down to a simple C program to illustrate the problem?
>>My guess is it's an error in how you're using ct-lib, but I can't be sure
>>from your description.

>>--jkl

Hi James,

I am not getting any result set back. I send my stored proc as a normat SQL
query and my C codes look like this:

char* query = "exec ap_sel_equity_meta_data @p_equity_id=10;"  // sample
query

if(ct_command(cmd, CS_RPC_CMD, (CS_CHAR*)query.c_str(), CS_NULLTERM,
CS_RECOMPILE) != CS_SUCCEED)
      throw FTDSException("ct_command() failed");
if(ct_send(cmd) != CS_SUCCEED)
      throw FTDSException("ct_send() failed");

But I do send a connection request to the server(that works) and send
another query to request parameters type,name,etc And that also works. But
when I then send the stored proc, in the <tds_submit_query> (in query.c
file), tds->state==TDS_PEDING and hence returns TDS_FAIL. I don't kow what's
wrong.

The other thing that I want to ask is that what effect does the CS_RECOMPILE
and CS_NO_RECOMPILE options and CS_RPC_CMD have on the command??

Thanx a lot for your help.

my log file looks like this

============================================================================
=================================================

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


Received packet @ 2003-12-04 12:43:23
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-04 12:43:23 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-12-04 12:43:23 inside tds_process_default_tokens() marker is ab(INFO)
2003-12-04 12:43:23 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-12-04 12:43:23 inside tds_process_default_tokens() marker is ab(INFO)
2003-12-04 12:43:23 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-12-04 12:43:23 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-12-04 12:43:23 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-12-04 12:43:23 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-12-04 12:43:23 increasing block size from 4096 to 4096
2003-12-04 12:43:23 inside tds_process_default_tokens() marker is fd(DONE)
2003-12-04 12:43:23 inside tds_process_end() more_results = 0, was_cancelled
= 0
2003-12-04 12:43:23 inside tds_process_default_tokens() setting state to
COMPLETED
Sending packet @ 2003-12-04 12:43:23
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-04 12:43:23
0000  04 01 00 1d 00 64 01 00                            |.....d..|


Received packet @ 2003-12-04 12:43:23
0000  81 01 00 00 00 00 00 34  00 d1 64 00 fd 10 00 c1   |.......4 ..d.....|
0010  00 01 00 00 00                                     |.....|


2003-12-04 12:43:23 processing result tokens.  marker is  81(TDS7_RESULT)
2003-12-04 12:43:23 tds7_get_data_info:1083:
        type = 52 (smallint)
        column_varint_size = 0
        colname =
        colnamelen = 0
2003-12-04 12:43:23 processing row tokens.  marker is  d1(ROW)
2003-12-04 12:43:23 processing row.  column is 0 varint size = 0
2003-12-04 12:43:23 processing row.  column size is 2
2003-12-04 12:43:23 clearing column 0 NULL bit
2003-12-04 12:43:23 processing row tokens.  marker is  fd(DONE)
2003-12-04 12:43:23 inside tds_process_end() more_results = 0, was_cancelled
= 0
2003-12-04 12:43:23 inside tds_process_result_tokens() state is COMPLETED
2003-12-04 12:43:23 leaving tds_process_login_tokens() returning 1
2003-12-04 12:43:23 leaving ct_connect() returning 1
2003-12-04 12:43:23 inside ct_cmd_alloc()
2003-12-04 12:43:31 inside ct_command()
2003-12-04 12:43:34 inside ct_send()
Sending packet @ 2003-12-04 12:43:34
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-04 12:43:34 ct_send() succeeded
2003-12-04 12:43:35 inside ct_results()
Received header @ 2003-12-04 12:43:35
0000  04 01 00 bc 00 64 01 00                            |.....d..|


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


2003-12-04 12:43:51 ct_send() succeeded
2003-12-04 12:43:54 inside ct_results()
Received header @ 2003-12-04 12:43:54
0000  04 01 01 0a 00 64 01 00                            |.....d..|


Received packet @ 2003-12-04 12:43:54
0000  81 05 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 00 00 08 00 34   |._.t.y.p .e.....4|
0050  0e 70 00 61 00 72 00 61  00 6d 00 65 00 74 00 65   |.p.a.r.a .m.e.t.e|
0060  00 72 00 5f 00 73 00 69  00 7a 00 65 00 00 00 21   |.r._.s.i .z.e...!|
0070  00 26 02 13 70 00 61 00  72 00 61 00 6d 00 65 00   |.&..p.a. r.a.m.e.|
0080  74 00 65 00 72 00 5f 00  70 00 72 00 65 00 63 00   |t.e.r._. p.r.e.c.|
0090  69 00 73 00 69 00 6f 00  6e 00 00 00 21 00 26 04   |i.s.i.o. n...!.&.|
00a0  0f 70 00 61 00 72 00 61  00 6d 00 65 00 74 00 65   |.p.a.r.a .m.e.t.e|
00b0  00 72 00 5f 00 73 00 63  00 61 00 6c 00 65 00 a9   |.r._.s.c .a.l.e..|
00c0  02 00 00 00 d1 18 00 40  00 70 00 5f 00 65 00 71   |.......@ .p._.e.q|
00d0  00 75 00 69 00 74 00 79  00 5f 00 69 00 64 00 0e   |.u.i.t.y ._.i.d..|
00e0  00 6e 00 75 00 6d 00 65  00 72 00 69 00 63 00 09   |.n.u.m.e .r.i.c..|
00f0  00 02 0a 00 04 00 00 00  00 fd 10 00 c1 00 01 00   |........ ........|
0100  00 00                                              |..|


2003-12-04 12:43:54 processing result tokens.  marker is  81(TDS7_RESULT)
2003-12-04 12:43:54 tds7_get_data_info:1083:
        type = 39 (varchar)
        column_varint_size = 2
        colname = parameter_name
        colnamelen = 14
2003-12-04 12:43:54 tds7_get_data_info:1083:
        type = 39 (varchar)
        column_varint_size = 2
        colname = parameter_type
        colnamelen = 14
2003-12-04 12:43:54 tds7_get_data_info:1083:
        type = 52 (smallint)
        column_varint_size = 0
        colname = parameter_size
        colnamelen = 14
2003-12-04 12:43:54 tds7_get_data_info:1083:
        type = 38 (integer-null)
        column_varint_size = 1
        colname = parameter_precision
        colnamelen = 19
2003-12-04 12:43:54 tds7_get_data_info:1083:
        type = 38 (integer-null)
        column_varint_size = 1
        colname = parameter_scale
        colnamelen = 15
2003-12-04 12:43:54 inside ct_results() process_result_tokens returned 1
(type 4049)
2003-12-04 12:43:54 processing result tokens.  marker is  a9(ORDERBY)
2003-12-04 12:43:54 inside tds_process_default_tokens() marker is
a9(ORDERBY)
eating token 169
2003-12-04 12:43:54 processing result tokens.  marker is  d1(ROW)
2003-12-04 12:43:54 inside ct_results() process_result_tokens returned 1
(type 4040)
2003-12-04 12:43:54 inside ct_res_info()
2003-12-04 12:43:54 ct_res_info(): Number of columns is 5
2003-12-04 12:43:55 inside ct_describe()
2003-12-04 12:43:55 inside _ct_get_client_type(type 39, size 256)
2003-12-04 12:43:55 inside ct_describe() datafmt->datatype = 1 server type
39
2003-12-04 12:43:55 inside ct_bind()
2003-12-04 12:43:55 inside ct_bind() item = 1 datafmt->datatype = 1
2003-12-04 12:43:55 inside ct_describe()
2003-12-04 12:43:55 inside _ct_get_client_type(type 39, size 256)
2003-12-04 12:43:55 inside ct_describe() datafmt->datatype = 1 server type
39
2003-12-04 12:43:55 inside ct_bind()
2003-12-04 12:43:55 inside ct_bind() item = 2 datafmt->datatype = 1
2003-12-04 12:43:55 inside ct_describe()
2003-12-04 12:43:55 inside _ct_get_client_type(type 52, size 2)
2003-12-04 12:43:55 inside ct_describe() datafmt->datatype = 3 server type
52
2003-12-04 12:43:55 inside ct_bind()
2003-12-04 12:43:55 inside ct_bind() item = 3 datafmt->datatype = 3
2003-12-04 12:43:55 inside ct_describe()
2003-12-04 12:43:55 inside _ct_get_client_type(type 38, size 2)
2003-12-04 12:43:55 inside ct_describe() datafmt->datatype = 3 server type
38
2003-12-04 12:43:55 inside ct_bind()
2003-12-04 12:43:55 inside ct_bind() item = 4 datafmt->datatype = 3
2003-12-04 12:43:55 inside ct_describe()
2003-12-04 12:43:55 inside _ct_get_client_type(type 38, size 4)
2003-12-04 12:43:55 inside ct_describe() datafmt->datatype = 2 server type
38
2003-12-04 12:43:55 inside ct_bind()
2003-12-04 12:43:55 inside ct_bind() item = 5 datafmt->datatype = 2
2003-12-04 12:43:55 inside ct_fetch()
2003-12-04 12:43:55 processing row tokens.  marker is  d1(ROW)
2003-12-04 12:43:55 processing row.  column is 0 varint size = 2
2003-12-04 12:43:55 processing row.  column size is 24
2003-12-04 12:43:55 clearing column 0 NULL bit
2003-12-04 12:43:55 processing row.  column is 1 varint size = 2
2003-12-04 12:43:55 processing row.  column size is 14
2003-12-04 12:43:55 clearing column 1 NULL bit
2003-12-04 12:43:55 processing row.  column is 2 varint size = 0
2003-12-04 12:43:55 processing row.  column size is 2
2003-12-04 12:43:55 clearing column 2 NULL bit
2003-12-04 12:43:55 processing row.  column is 3 varint size = 1
2003-12-04 12:43:55 processing row.  column size is 2
2003-12-04 12:43:55 clearing column 3 NULL bit
2003-12-04 12:43:55 processing row.  column is 4 varint size = 1
2003-12-04 12:43:55 processing row.  column size is 4
2003-12-04 12:43:55 clearing column 4 NULL bit
2003-12-04 12:43:55 inside ct_fetch() process_row_tokens returned 1
2003-12-04 12:43:55 inside _ct_bind_data()
2003-12-04 12:43:55 inside _ct_get_server_type(1)
2003-12-04 12:43:55 inside _ct_get_client_type(type 39, size 256)
2003-12-04 12:43:55 inside _ct_bind_data() setting source length for 0 = 12
destlen = 256
2003-12-04 12:43:55 inside cs_convert()
2003-12-04 12:43:55 inside _ct_get_server_type(1)
2003-12-04 12:43:55 inside _ct_get_server_type(1)
2003-12-04 12:43:55 inside cs_convert() srctype = 47 (12) desttype = 47
(256)
2003-12-04 12:43:55 inside cs_convert() srctype = desttype
2003-12-04 12:43:55 inside cs_convert() desttype = character
2003-12-04 12:43:55 inside _ct_bind_data() length binding len = 12
2003-12-04 12:43:55 inside _ct_get_server_type(1)
2003-12-04 12:43:55 inside _ct_get_client_type(type 39, size 256)
2003-12-04 12:43:55 inside _ct_bind_data() setting source length for 1 = 7
destlen = 256
2003-12-04 12:43:55 inside cs_convert()
2003-12-04 12:43:55 inside _ct_get_server_type(1)
2003-12-04 12:43:55 inside _ct_get_server_type(1)
2003-12-04 12:43:55 inside cs_convert() srctype = 47 (7) desttype = 47 (256)
2003-12-04 12:43:55 inside cs_convert() srctype = desttype
2003-12-04 12:43:55 inside cs_convert() desttype = character
2003-12-04 12:43:55 inside _ct_bind_data() length binding len = 7
2003-12-04 12:43:55 inside _ct_get_server_type(3)
2003-12-04 12:43:55 inside _ct_get_client_type(type 52, size 2)
2003-12-04 12:43:55 inside _ct_bind_data() setting source length for 2 = 2
destlen = 2
2003-12-04 12:43:55 inside cs_convert()
2003-12-04 12:43:55 inside _ct_get_server_type(3)
2003-12-04 12:43:55 inside _ct_get_server_type(3)
2003-12-04 12:43:55 inside cs_convert() srctype = 52 (2) desttype = 52 (2)
2003-12-04 12:43:55 inside cs_convert() srctype = desttype
2003-12-04 12:43:55 inside _ct_bind_data() length binding len = 2
2003-12-04 12:43:55 inside _ct_get_server_type(3)
2003-12-04 12:43:55 inside _ct_get_client_type(type 38, size 2)
2003-12-04 12:43:55 inside _ct_bind_data() setting source length for 3 = 2
destlen = 2
2003-12-04 12:43:55 inside cs_convert()
2003-12-04 12:43:55 inside _ct_get_server_type(3)
2003-12-04 12:43:55 inside _ct_get_server_type(3)
2003-12-04 12:43:55 inside cs_convert() srctype = 52 (2) desttype = 52 (2)
2003-12-04 12:43:55 inside cs_convert() srctype = desttype
2003-12-04 12:43:55 inside _ct_bind_data() length binding len = 2
2003-12-04 12:43:55 inside _ct_get_server_type(2)
2003-12-04 12:43:55 inside _ct_get_client_type(type 38, size 4)
2003-12-04 12:43:55 inside _ct_bind_data() setting source length for 4 = 4
destlen = 4
2003-12-04 12:43:55 inside cs_convert()
2003-12-04 12:43:55 inside _ct_get_server_type(2)
2003-12-04 12:43:55 inside _ct_get_server_type(2)
2003-12-04 12:43:55 inside cs_convert() srctype = 56 (4) desttype = 56 (4)
2003-12-04 12:43:55 inside cs_convert() srctype = desttype
2003-12-04 12:43:55 inside _ct_bind_data() length binding len = 4
2003-12-04 12:43:56 inside ct_describe()
2003-12-04 12:43:56 inside _ct_get_client_type(type 39, size 256)
2003-12-04 12:43:56 inside ct_describe() datafmt->datatype = 1 server type
39
2003-12-04 12:43:56 inside ct_bind()
2003-12-04 12:43:56 inside ct_bind() item = 1 datafmt->datatype = 1
2003-12-04 12:43:56 inside ct_describe()
2003-12-04 12:43:56 inside _ct_get_client_type(type 39, size 256)
2003-12-04 12:43:56 inside ct_describe() datafmt->datatype = 1 server type
39
2003-12-04 12:43:56 inside ct_bind()
2003-12-04 12:43:56 inside ct_bind() item = 2 datafmt->datatype = 1
2003-12-04 12:43:56 inside ct_describe()
2003-12-04 12:43:56 inside _ct_get_client_type(type 52, size 2)
2003-12-04 12:43:56 inside ct_describe() datafmt->datatype = 3 server type
52
2003-12-04 12:43:56 inside ct_bind()
2003-12-04 12:43:56 inside ct_bind() item = 3 datafmt->datatype = 3
2003-12-04 12:43:56 inside ct_describe()
2003-12-04 12:43:56 inside _ct_get_client_type(type 38, size 2)
2003-12-04 12:43:56 inside ct_describe() datafmt->datatype = 3 server type
38
2003-12-04 12:43:56 inside ct_bind()
2003-12-04 12:43:56 inside ct_bind() item = 4 datafmt->datatype = 3
2003-12-04 12:43:56 inside ct_describe()
2003-12-04 12:43:56 inside _ct_get_client_type(type 38, size 4)
2003-12-04 12:43:56 inside ct_describe() datafmt->datatype = 2 server type
38
2003-12-04 12:43:56 inside ct_bind()
2003-12-04 12:43:56 inside ct_bind() item = 5 datafmt->datatype = 2
2003-12-04 12:43:56 inside ct_fetch()
2003-12-04 12:48:36 inside ct_command() // this is where I do create a
command for the stored proc
2003-12-04 12:49:29 inside ct_send()
2003-12-04 12:51:38 ct_send() failed


============================================================================
=================================================

David