Skip to Content.
Sympa Menu

freetds - [freetds] Stored proc on MS SQL Server 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "David Nsengiyumva" <davidn AT finsolutions.co.za>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Stored proc on MS SQL Server 2000
  • Date: Thu, 4 Dec 2003 01:28:47 +0200

Please If you can help...this is kind of urgently,

I am using FreeTDS 7.0 and wants to execute stored procs. I can get the
stored proc in the format 'exec stored_proc_name @param1=value,
@param2=value, ect';

But when I send this string as a simple query then there is no error but I
don't get any result back. I've got also this problem....in the
'tds_submit_query' function (in tds), the tds->state is pending!!!! but no
result still pending from previous queries!!!!

Since I've got the query (with all its parameters) as a simple string, can I
declare the command using ct_command like this
'ct_command(cmd, CS_LANG_CMD, (CS_CHAR*)CommandText, CS_NULLTERM,
CS_UNUSED);

(no need for CS_RPC_CMD??? )

And then send it using ct_send??? Can I do that???

Has anyone ever executed stored procs with FreeTDS and MS SQL Server 2000???
If you did, please advise on what to do, what to change or just give some
orientation...I am kind of lost here. I've been struggling with this for
quite some time now..

Thanx a lot

David Nsengiyumva

Software Developer
Tel: +27 21 464 7215
Cel: +27 73 351 3975
Fax: +27 21 464 7201
http://www.finsolutions.co.za

CONFIDENTIALITY CAUTION
This page and any accompanying documents contain privileged and confidential
information for the specific individual to whom it is addressed, and are
protected by law. If the reader is not the intended recipient, you are
hereby notified that any review, dissemination, distribution or copying or
the taking of any action based on the contents of this communication is
strictly prohibited. If you have received this communication in error,
please desist from reading the contents, notify us immediately and destroy
the communication.







Archive powered by MHonArc 2.6.24.

Top of Page