Skip to Content.
Sympa Menu

freetds - Re: [freetds] mssql_execute(): stored procedure execution failed

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Sylvain Viart - Gmail <sylvain.viart AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] mssql_execute(): stored procedure execution failed
  • Date: Mon, 24 May 2010 09:39:48 +0200

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.




Archive powered by MHonArc 2.6.24.

Top of Page