mssql_execute(): stored procedure execution failed

Sylvain Viart - Gmail <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.