[freetds] mssql_execute(): stored procedure execution failed
Sylvain Viart - Gmail
sylvain.viart at gmail.com
Mon May 24 03:39:48 EDT 2010
Hi,
On 23/05/2010 03:07, Robert Gonzalez wrote:
>>>> t give any error messages when it doesn't work?
>>>>
>> PHP Warning: mssql_init(): unable to init stored procedure in
>> read_msg.php on line 46
>> PHP Warning: mssql_execute() expects parameter 1 to be resource,
>> boolean given in read_msg.php on line 47
>> PHP Warning: mssql_free_statement() expects parameter 1 to be resource,
>> boolean given in read_msg.php on line 48
>>
>>
> If possible, take the return from mssql_init() and check it for boolean
> false. If it is, try to trap the error returned from the server with
> mssql_get_last_message(). All of the errors you see after the mssql_init()
> failure are because you are trying to pass a boolean value (in this case, a
> FALSE) to functions that expect an initialized stored proc resource handle.
>
Yes, I gonna log that and report it back.
No clue about the difference between mssql_init + mssql_bind versus
mssql_query("EXEC ...")?
Regards,
Sylvain.
More information about the FreeTDS
mailing list