FreeTDS Development Group

["Craig A. Berry" <craigberry AT mac.com>]

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