Skip to Content.
Sympa Menu

freetds - RE: [freetds] Stored Proc & MS SQL Server 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Stored Proc & MS SQL Server 2000
  • Date: Thu, 4 Dec 2003 11:13:23 -0000

Hey david,

your problem is that you haven't fully processed the result set from your
previous command that is accessing sysobjects, syscolumns etc.


You are doing a ct_results() and then a ct_fetch(), but you haven't fully
processed the result set before issuing your "exec stored proc" command.
You need to call ct_results in a loop until it returns CS_END_RESULTS

see <freetds>/src/ctlib/unittests/t0002.c for an example of a ct_results
loop.

The CS_RECOMPILE options will force the stored procedure to be recompiled
before executing.

Bill

> -----Original Message-----
> From: David Nsengiyumva [SMTP:davidn AT finsolutions.co.za]
> Sent: 04 December 2003 10:56
> To: freetds AT lists.ibiblio.org
> Subject: [freetds] Stored Proc & MS SQL Server 2000
>
> 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
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page