Re: mssql_execute(): stored procedure execution failed
"Craig A. Berry" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
________________________________________
Craig A. Berry
mailto:[email protected]
"... getting out of a sonnet is much more
difficult than getting in."
Brad Leithauser