Skip to Content.
Sympa Menu

freetds - RE: [freetds] call a stored procedure and tds_submit_query

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] call a stored procedure and tds_submit_query
  • Date: Fri, 23 Jul 2004 16:29:46 +0100

good news,

remember to unset the TDSDUMP environment variable or you start creating
files all over the place!

Bill

-----Original Message-----
From: Fabrizio Taretto [mailto:fabrizio.taretto AT sinedita.it]
Sent: 23 July 2004 16:20
To: FreeTDS Development Group
Subject: Re: [freetds] call a stored procedure and tds_submit_query


Bill,

with the TDSDUMP log I've understood my problem!!

Thanks a lot.

Fabrizio

> Sorry Fabrizio,
>
> In a UNIX environment if you set the following environment variable..
>
> setenv TDSDUMP <myfilename>
>
> or
>
> export TDSDUMP=<myfilename>
>
> you will get a log file of a lot of the TDS internals.
> This will help you or us to see what is going on...
>
> see the user guide for more details...
>
> Bill
>
> -----Original Message-----
> From: Fabrizio Taretto [mailto:fabrizio.taretto AT sinedita.it]
> Sent: 23 July 2004 15:47
> To: FreeTDS Development Group
> Subject: Re: [freetds] call a stored procedure and tds_submit_query
>
>
> 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
>
> _______________________________________________
> 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

_______________________________________________
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/>

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





Archive powered by MHonArc 2.6.24.

Top of Page