Skip to Content.
Sympa Menu

freetds - Re: [freetds] mssql_execute(): stored procedure execution failed

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Craig A. Berry" <craigberry AT mac.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] mssql_execute(): stored procedure execution failed
  • Date: Thu, 20 May 2010 13:10:51 -0500


On May 20, 2010, at 1:50 AM, Sylvain Viart - Gmail wrote:

Hi,

I've migrated a linux server

* from: freetds-0.61-1
* to: freetds-bin 0.82-6

Now we experience problem with stored procedure, called that way from
php (its legacy code)

$query=mssql_init("mail_exclusion_get", $conn);
mssql_bind($query, "@id", $receiverId, SQLINT4);
mssql_bind($query, "@type", $tag_mail, SQLINT4);
$rt=mssql_execute($query);
mssql_free_statement($query);


sometime it works, sometime not.

It's unlikely anyone unfamiliar with your environment can help you without a much more detailed definition of "works". Does it give any error messages when it doesn't work? Does it run but return incorrect results? What exact differences are there in a server-side trace for the case where it works compared to the case where it doesn't?

Activating freetds log doesn't seem to give useful information.

What exact differences are there in the log between the case that doesn't work and the one that does, or between your old FreeTDS version and the new one?


We patched some procedure call with :

mssql_query("EXEC mail_exclusion_get @id = 1276963, @type = 1");

To you have any clue to fix this problem?

Regards,
Sylvain.
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

________________________________________
Craig A. Berry
mailto:craigberry AT mac.com

"... getting out of a sonnet is much more
difficult than getting in."
Brad Leithauser





Archive powered by MHonArc 2.6.24.

Top of Page