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: Fabrizio Taretto <fabrizio.taretto AT sinedita.it>
  • 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:47:06 +0200

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





Archive powered by MHonArc 2.6.24.

Top of Page