[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