[freetds] call a stored procedure and tds_submit_query

Fabrizio Taretto fabrizio.taretto at sinedita.it
Fri Jul 23 10:47:06 EDT 2004


excuse me, but what is the TDSDUMP log? I don't create any log file.

Fabrizio

> Fabrizio,
>
> If you capture a TDSDUMP, you should be able to see whats happening....
>
> Bill
>
> -----Original Message-----
> From: Fabrizio Taretto [mailto:fabrizio.taretto at sinedita.it]
> Sent: 23 July 2004 15:36
> To: FreeTDS Development Group
> Subject: Re: [freetds] call a stored procedure and tds_submit_query
>
>
> ...ok, but if I test the doneFlags, the error code is TDS_DONE_ERROR.
> Is my syntax query wrong?
>
> Fabrizio
>
>>>
>>> ...thanks a lot,
>>>
>>> but I can't manage to use my stored procedure.
>>>
>>> My stored procedure's definition is:
>>> create procedure GetDraw(
>>> 	@tes int,
>>> 	@ted int,
>>> 	@tfp varchar(20)
>>> 	@ded varchar(10)	
>>> }
>>> ....
>>>
>>> In my C source code I call:
>>>
>>> tds_submit_query(gSocket, "exec GetDraw @tes=100, @ted=100,
>>> @tfp='01010101', @ded='2004-03-03'");
>>>
>>> ...
>>>
>>> tds_process_result_tokens(gSocket, &resulttype, &doneFlags)
>>>
>>> ...but the result type is Always TDS_DONE_RESULT.
>>>
>>> Where is my mistake?
>>>
>>> Regards
>>> Fabrizio
>>>
>>
>> I don't suggest you to use libTDS directly (see
>> http://www.freetds.org/which_api.html) however it's normal. Server  
>> it's
>> just telling you that current recordset it's finished (with no rows
>> returned in this case).
>>
>> freddy77
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS at lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
> ======================================================================= 
> =======
>
> If you are not an intended recipient of this e-mail, please notify
> the sender, delete it and do not read, act upon, print, disclose,
> copy, retain or redistribute it.
>
> Click here for important additional terms relating to this e-mail.
>      <http://www.ml.com/email_terms/>
>
> ======================================================================= 
> =======
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




More information about the FreeTDS mailing list