Re: mssql_execute(): stored procedure execution failed
Sylvain Viart - Gmail <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Hi, On 24/05/2010 18:27, Robert Gonzalez wrote: > mssql_init() essentially prepares a stored proc to be called as a prepared > statement with the possibility of placeholders added to it for multiple > calls using different params. mssql_bind() allows you to bind those > different params into the prepared statement for processing using the > mssql_execute() function. > > mssql_query() takes the query as entered, sends it to the database server > and receives the response from the DB server, usually in the form of a > result resource handle. You can just as easily send stored procedure > requests using mssql_query() as you could using init, bind and execute. Thanks. mssql_get_last_message() give useless message. :-( I've tried to raise the error severity from 10, 16, 17 ; Minimum error severity to display. mssql.min_error_severity = 17 ; Minimum message severity to display. mssql.min_message_severity = 17 no change. here is the error message: Changed database context to 'D2_master'. where D2_master is the database name. Still searching. Regards, Sylvain.