Skip to Content.
Sympa Menu

freetds - [freetds] stored proc parameters

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Paparo, Joshua" <Joshua.Paparo AT bankofamerica.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] stored proc parameters
  • Date: Fri, 3 Dec 2004 11:16:53 -0000

Hi,



I am using FreeTDS 0.63RC2 on GNU Linux 2.4.20 to connect to SQLServer2000
and am having trouble with stored procedures.



I'm attempting a port of RogueWave's dbtools++ (dblib) from Sybase to FreeTDS.



Procedures I run with just null parameters seem okay but when I try to run
one with say a date (non-null) and a string (null) as below I get no rows
returned when I know there should be. I have verified this in both tsql and
sqsh.



Is it possible to tell from the hex code below what values for @date and
@label I'm actually sending to the server?



Thanks,



Josh Paparo



10:57:12.317001 tds_process_end() state set to TDS_IDLE

10:59:18.640678 dbrpcinit() added rpcname "dbo.pdtMatchAlphas"

11:00:22.296402 dbrpcparam() added parameter "@date"

11:02:25.675630 dbrpcparam() added parameter "@label"

11:02:39.413132 dbrpcsend()

11:02:39.413228 tds_free_all_results()

11:02:39.413275 tds_put_data_info putting param_name

11:02:39.413292 tds_put_data_info putting status

11:02:39.413305 tds_put_data: is_null = 0, colsize = 8

11:02:39.413316 tds_put_data: not null param varint_size = 0

11:02:39.413329 tds_put_data_info putting param_name

11:02:39.413343 tds_put_data_info putting status

11:02:39.413354 tds_put_data: is_null = 0, colsize = 0

11:02:39.413364 tds_put_data: not null param varint_size = 2

11:02:39.413378 Sending packet

0000 03 01 00 5d 00 00 01 00-12 00 64 00 62 00 6f 00 |...].... ..d.b.o.|

0010 2e 00 70 00 64 00 74 00-4d 00 61 00 74 00 63 00 |..p.d.t. M.a.t.c.|

0020 68 00 41 00 6c 00 70 00-68 00 61 00 73 00 00 00 |h.A.l.p. h.a.s...|

0030 05 40 00 64 00 61 00 74-00 65 00 00 3d 0e 8c 00 |.@.d.a.t e..=...|

0040 00 00 00 00 00 06 40 00-6c 00 61 00 62 00 65 00 |......@. l.a.b.e.|

0050 6c 00 00 a7 00 00 09 04-c0 00 33 00 00 |l..§.... À.3..|



11:02:40.175909 in dbsqlok()

11:02:40.175987 Received header

0000 04 01 00 97 00 33 01 00- |.....3..|



11:02:40.176015 Received packet

0000 81 05 00 28 01 0a 00 a7-08 00 09 04 c0 00 33 05 |...(...§ ...À.3.|

0010 74 00 65 00 6e 00 6f 00-72 00 00 00 08 00 3e 05 |t.e.n.o. r.....>.|

0020 76 00 61 00 6c 00 75 00-65 00 0c 01 08 00 3d 0b |v.a.l.u. e.....=.|

0030 70 00 72 00 69 00 63 00-69 00 6e 00 67 00 64 00 |p.r.i.c. i.n.g.d.|

0040 61 00 74 00 65 00 14 01-0b 00 a7 10 00 09 04 c0 |a.t.e... .§....À|

0050 00 33 05 6c 00 61 00 62-00 65 00 6c 00 00 00 08 |.3.l.a.b .e.l....|

0060 00 34 08 73 00 65 00 71-00 75 00 65 00 6e 00 63 |.4.s.e.q .u.e.n.c|

0070 00 65 00 a9 02 00 05 00-ff 11 00 c1 00 00 00 00 |.e.©.... ÿ..Á....|

0080 00 79 00 00 00 00 fe 00-00 e0 00 00 00 00 00 |.y....þ. à.....|



11:02:40.176080 dbsqlok() marker is 81

11:02:40.176088 dbsqlok() found result token




Notice to recipient:
The information in this internet e-mail and any attachments is confidential
and may be privileged. It is intended solely for the addressee. If you are
not the intended addressee please notify the sender immediately by telephone.
If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful.

When addressed to external clients any opinions or advice contained in this
internet e-mail are subject to the terms and conditions expressed in any
applicable governing terms of business or client engagement letter issued by
the pertinent Bank of America group entity.

If this email originates from the U.K. please note that Bank of America,
N.A., London Branch, Banc of America Securities Limited and Banc of America
Futures Incorporated are authorised and regulated by the Financial Services
Authority.





Archive powered by MHonArc 2.6.24.

Top of Page