note 55299 added to function.mssql-get-last-message

From: Date: Fri, 29 Jul 2005 14:48:02 +0000
Subject: note 55299 added to function.mssql-get-last-message
Groups: php.notes 
Request: Send a blank email to php-notes+get-92727@lists.php.net to get a copy of this message
As Klaus pointed out earlier, the command MSSQL_GET_LAST_MESSAGE() only returns the last line of an error message and that may not be enough for debugging. I had a failing MSSQL_QUERY returning "the statement has been terminated" via MSSQL_GET_LAST_MESSAGE() so I tried Klaus' technique to get more information. Unfortunately, the connection to the database was also being broken, keeping Klaus' technique from looking up the error number. The solution to my case was to increase the PHP timeout for MSSQL queries from the default 60 seconds to 300 by adding this to PHP.INI: mssql.timeout = 300 ---- Submitter IP: 12.160.245.96 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-get-last-message.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+55299 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+55299&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+55299&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+55299&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+55299&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+55299&report=yes&reason=non-english Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+55299&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+55299&report=yes Search -- http://master.php.net/manage/user-notes.php

« previous php.notes (#92727) next »