FreeTDS Development Group

[Fabrizio Taretto <fabrizio.taretto AT sinedita.it>]

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