Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Sylvain Viart - Gmail <sylvain.viart AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] mssql_execute(): stored procedure execution failed
  • Date: Thu, 20 May 2010 08:50:00 +0200

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.

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

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.




Archive powered by MHonArc 2.6.24.

Top of Page